Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

python

xlsxwriter

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?

like image 606
Ambi Avatar asked Dec 10 '13 09:12

Ambi

People also ask

Is XlsxWriter included in Python?

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.

Does pandas use XlsxWriter?

You can use XlsxWriter as an engine for Pandas ExcelWriter class to output a DataFrame to Excel.

1 Answers

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

There are some alternatives listed in the documentation.

like image 136
jmcnamara Avatar answered Oct 03 '22 04:10

jmcnamara
Sign in to Comment

Related questions

How to determine when DST starts or ends in a specific location in Python? [duplicate]
Paramiko and exec_command - killing remote process?
Subclassing and overriding a generator function in python
Why is Pydev giving a syntax error for built-in keywords?
Python : UnicodeEncodeError: 'latin-1' codec can't encode character
django manage.py settings default
Debugging code in the Python interpreter
Simple tutorial for Neo4J and using it with django + python
Read a text file with non-ASCII characters in an unknown encoding
Can we use regular expressions to check if there are an odd number of each type of character?
How do I disable the keyboard shortcuts in Matplotlib?
Get country code for timezone using pytz?
have sphinx report broken links
Python module won't install
How do I plot a spectrogram the same way that pylab's specgram() does?
What's the unit of RSS in psutil.Process.get_memory_info?
Filtering two lists simultaneously
shebang env preferred python version
How to compile a string of Python code into a module whose functions can be called?
A ThreadPoolExecutor inside a ProcessPoolExecutor

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!