Is it possible to read data from an Excel sheet in Python using Xlsxwriter? If so how?

python xlsxwriter
Ambi picture Ambi · Dec 10, 2013 · Viewed 35.9k times · Source

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?

Answer

jmcnamara picture jmcnamara · Dec 11, 2013

It is not possible to read data from an Excel file using XlsxWriter.

There are some alternatives listed in the documentation.

Related questions

How to write/update data into cells of existing XLSX workbook using xlsxwriter in python

I am able to write into new xlsx workbook using import xlsxwriter def write_column(csvlist): workbook = xlsxwriter.Workbook("filename.xlsx",{'strings_to_numbers': True}) worksheet = workbook.add_worksheet() row = 0 col = 0 for i in csvlist: worksheet.write(col,row, i) …

Read More
How to save a new sheet in an existing excel file, using Pandas?

I want to use excel files to store data elaborated with python. My problem is that I can't add sheets to an existing excel file. Here I suggest a sample code to work with in order to reach this issue …

Read More
xlsxwriter: is there a way to open an existing worksheet in my workbook?

I'm able to open my pre-existing workbook, but I don't see any way to open pre-existing worksheets within that workbook. Is there any way to do this?

Read More