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
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
== Updated to a fully functional version, based on feedback here: groups.google.com/forum/#!topic/openpyxl-users/wHGecdQg3Iw. == As the others have pointed out, openpyxl does not provide this functionality, but I have extended the Worksheet class as follows to implement inserting rows. Hope this proves useful to others. def insert_rows(self, row_idx, cnt, above=False, copy_style=True, fill_formulae=True): “””Inserts new (empty) rows … 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
Solution 1 A Python-only solution using the openpyxl package. Only data values will be copied. import openpyxl as xl path1 = ‘C:\\Users\\Xukrao\\Desktop\\workbook1.xlsx’ path2 = ‘C:\\Users\\Xukrao\\Desktop\\workbook2.xlsx’ wb1 = xl.load_workbook(filename=path1) ws1 = wb1.worksheets[0] wb2 = xl.load_workbook(filename=path2) ws2 = wb2.create_sheet(ws1.title) for row in ws1: for cell in row: ws2[cell.coordinate].value = cell.value wb2.save(path2) Solution 2 A solution that uses … 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
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