Top "Xlrd" questions

xlrd is a python library to extract data from Microsoft Excel spreadsheet files

python xlutils : formatting_info=True not yet implemented

I've got simple code to copy files with xlutils, xlrd, xlwt (downloaded new libraries from python-excel.org) with not loosing …

python python-2.7 xlrd xlwt xlutils
Searching the string and getting the row and column value

How to search the particular string in the excel sheet and getting the row and column value of that particular …

python excel xlrd
Unicode to UTF8 for CSV Files - Python via xlrd

I'm trying to translate an Excel spreadsheet to CSV using the Python xlrd and csv modules, but am getting hung …

python unicode encoding csv xlrd
Adding a sheet to an existing excel worksheet without deleting other sheet

I am trying to add a sheet to the excel file: ex.xls and whenever I do it deletes all …

excel python-2.7 csv xlrd xlwt
Python xlrd : how to convert an extracted value?

Well i have a question that i feel i've been answered several times, from what i found here. However, as …

python xlrd
python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets

Struggling for this for hours so I decided to ask for help from experts here: I want to modify existing …

python pandas openpyxl xlrd
How to set NULL for IntegerField instead of setting 0?

I'm uploading some data from an excel file using xlrd and turning that data into models (with mainly IntegerField values) …

python django django-models xlrd
Read merged cells in Excel with Python

I am trying to read merged cells of Excel with Python using xlrd. My Excel: (note that the first column …

python excel cell xlrd
sheets of Excel Workbook from a URL into a `pandas.DataFrame`

After looking at different ways to read an url link, pointing to a .xls file, I decided to go with …

python url pandas xlrd
Python xlrd.Book: how to close the files?

I read 150 excel files in a loop, opening them with xlrd.open_workbook(), which returns a Book object. At the …

python file-io xlrd