Here are some options to choose from: xlwt (writing xls files) xlrd (reading xls/xlsx files) openpyxl (reading/writing xlsx files) xlsxwriter (writing xlsx files) If you need to copy only data (without formatting information), you can just use any combination of these tools for reading/writing. If you have an xls file, you should go with xlrd+xlwt … Read more
I just implemented a wrapper class that tracks the widths of items as you enter them. It seems to work pretty well. import arial10 class FitSheetWrapper(object): “””Try to fit columns to max size of any entry. To use, wrap this around a worksheet returned from the workbook’s add_sheet method, like follows: sheet = FitSheetWrapper(book.add_sheet(sheet_name)) The … Read more
As I wrote in the edits of the op, to edit existing excel documents you must use the xlutils module (Thanks Oliver) Here is the proper way to do it: #xlrd, xlutils and xlwt modules need to be installed. #Can be done via pip install <module> from xlrd import open_workbook from xlutils.copy import copy rb … Read more
neat package! i didn’t know about this According to the doc, the save(filename_or_stream) method takes either a filename to save on, or a file-like stream to write on. And a Django response object happens to be a file-like stream! so just do xls.save(response). Look the Django docs about generating PDFs with ReportLab to see a … Read more
There are two parts to this. First, you must enable the reading of formatting info when opening the source workbook. The copy operation will then copy the formatting over. import xlrd import xlutils.copy inBook = xlrd.open_workbook(‘input.xls’, formatting_info=True) outBook = xlutils.copy.copy(inBook) Secondly, you must deal with the fact that changing a cell value resets the formatting … Read more
Here’s some sample code I used recently to do just that. It opens a workbook, goes down the rows, if a condition is met it writes some data in the row. Finally it saves the modified file. from xlutils.copy import copy # http://pypi.python.org/pypi/xlutils from xlrd import open_workbook # http://pypi.python.org/pypi/xlrd START_ROW = 297 # 0 based … Read more