Edit existing excel workbooks and sheets with xlrd and xlwt

by

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 = open_workbook("names.xls")
wb = copy(rb)

s = wb.get_sheet(0)
s.write(0,0,'A1')
wb.save('names.xls')

This replaces the contents of the cell located at a1 in the first sheet of “names.xls” with the text “a1”, and then saves the document.

More Related Contents:

  1. Insert row into Excel spreadsheet using openpyxl in Python
  2. Preserving styles using python’s xlrd,xlwt, and xlutils.copy
  3. writing to existing workbook using xlwt [closed]
  4. Pandas: Looking up the list of sheets in an excel file
  5. python xlrd unsupported format, or corrupt file.
  6. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  7. Get formula from Excel cell with python xlrd
  8. Error: Unsupported format, or corrupt file: Expected BOF record
  9. Convert date from excel in number format to date format python [duplicate]
  10. How to obtain sheet names from XLS files without loading the whole file?
  11. Python xlwt – accessing existing cell content, auto-adjust column width
  12. Identifying Excel Sheet cell color code using XLRD package
  13. django excel xlwt
  14. Python convert csv to xlsx
  15. How can I open an Excel file in Python?
  16. Running an Excel macro via Python?
  17. How to convert a python datetime.datetime to excel serial date number
  18. xls to csv converter
  19. pandas xlsxwriter, format table header – not sheet header
  20. Refresh Excel External Data with Python
  21. How can I see the formulas of an excel spreadsheet in pandas / python?
  22. Python: Open Excel Workbook using Win32 COM Api
  23. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  24. how to write to a new cell in python using openpyxl
  25. How do I call an Excel macro from Python using xlwings?
  26. Pandas: parse merged header columns from Excel
  27. How to write to an existing excel file without breaking formulas with openpyxl?
  28. Automation Excel from Python
  29. Appending Pandas DataFrame to existing Excel document
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment