Menu
I'm doing the following calculation.
worksheet.write_formula('E5', '=({} - A2)'.format(number))
I want to print the value in E5 on the console. Can you help me to do it? Is it possible to do it with Xlsxwriter or should I use a different library to the same?
606
XlsxWriter is a Python module for creating Excel XLSX files. (Sample code to create the above spreadsheet.) XlsxWriter is a Python module that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.
You can use XlsxWriter as an engine for Pandas ExcelWriter class to output a DataFrame to Excel.
It is not possible to read data from an Excel file using XlsxWriter.
There are some alternatives listed in the documentation.
136
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
