KP13Occasional Contributor7 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 Hero7 years agoI prefer to use a special library (openpyxl) to operate data with excel >>> KP13Occasional Contributor to baxatob7 years ago baxatob Could you please share the official procedure to add openpyxl library to TestComplete.baxatobCommunity Hero to KP137 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 Hero7 years agoyou can find it hereKP13Occasional Contributor to shankar_r7 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 Hero7 years agoI prefer to use a special library (openpyxl) to operate data with excel >>>
KP13Occasional Contributor to baxatob7 years ago baxatob Could you please share the official procedure to add openpyxl library to TestComplete.
baxatobCommunity Hero to KP137 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_r7 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 write into excel file using Javascript?How to select Excel sheet in python?Can write image to cell while using Excel ObjectProblem with writing to Excel in Python
Recent DiscussionsAccess a child in a tree Structure through Keyword StrokesTurn off all Edge messageboxesHow to verify data from another application, the data which keeps changingAudit and Reporting purposesTextbox values disappear after adding Year value from Date Picker