KP13Occasional Contributor6 years agoWriting data into excel using PythonCan any one please share that Python script for writing data into excel sheet
5 RepliesReplies sorted by Most LikedSort ByMost LikedOldestNewestbaxatobCommunity Hero6 years agoI prefer to use a special library (openpyxl) to operate data with excel >>> KP13Occasional Contributor to baxatob6 years ago baxatob Could you please share the official procedure to add openpyxl library to TestComplete.baxatobCommunity Hero to KP136 years agoPlease check this topic: https://community.smartbear.com/t5/TestComplete-General-Discussions/How-can-import-python-external-libraries-in-TestComplete/td-p/137370shankar_rCommunity Hero6 years agoyou can find it hereKP13Occasional Contributor to shankar_r6 years agoshankar_rThanks for the reply. I have checked this article. Its all about reading data from excel. It would be helpful if you would share links/sample python script to write into Excel.Anyway, I found the solution.
baxatobCommunity Hero6 years agoI prefer to use a special library (openpyxl) to operate data with excel >>>
KP13Occasional Contributor to baxatob6 years ago baxatob Could you please share the official procedure to add openpyxl library to TestComplete.
baxatobCommunity Hero to KP136 years agoPlease check this topic: https://community.smartbear.com/t5/TestComplete-General-Discussions/How-can-import-python-external-libraries-in-TestComplete/td-p/137370
KP13Occasional Contributor to shankar_r6 years agoshankar_rThanks for the reply. I have checked this article. Its all about reading data from excel. It would be helpful if you would share links/sample python script to write into Excel.Anyway, I found the solution.
Related ContentExcel-Write valueHow to select Excel sheet in python?How to write into excel file using Javascript?Can write image to cell while using Excel ObjectProblem with writing to Excel in Python
Recent DiscussionsTestComplete14.72 is not recognizing WinUI-3 objectsFloating window **bleep** overlapping window takes longer time (~10 min) to click the button on it.Test case randomly fails with "parent object was not found"Does TC have a .within() method similar to Cypress.io?SolvedSessionCreator /Timeout option not firing EventControl_OnTimeout