Forum Discussion

latosdforlife's avatar
latosdforlife
New Contributor
7 years ago

Is there a way to write to an Excel file using Python?

Hi.   Thanks in advance for any help.   I'm trying to write to a spreadsheet using Python. I need the ability to create a new spreadsheet/workbook file and also add worksheets, or tabs, in the sp...
  • latosdforlife's avatar
    latosdforlife
    New Contributor
    7 years ago

    Thanks for the link to the packages. I was wondering, how do I make TestComplete recognize third party libraries?

     

    I'm getting the ModuleNotFoundError.

     

    To install it, I pointed my PYTHON_HOME environment variable to Testcomplete's version of python, not the version installed on my C drive. Then I used that to build xlsxwriter. Then, setup.py places the XlsxWriter-0.9.6-py3.4.egg file in Testcomplete's Lib/site-packages folder. I can then run python in command prompt and import xlsxwriter just fine.

     

    However, when I try running import xlsxwriter in testcomplete, I get the ModuleNotFoundError.

     

    Any help is appreciated!

     

    Thank you!