Update cell values in an existing Excel workbook

[deleted-user-r12oOPKQjs2J]

Hello,

I need to export data from a feature class attribute table to an existing Excel (.xls) workbook.

The workbook has some formatting, so what I need ideally, is a way to write values in the existing workbook.

Any suggestions on how to do this using Python ?

(Ideally, Python in ArcGIS Pro)

[DanPatterson_Retired · Accepted solution]

There are separate packages that can be used with python that you can install for use with arcmap and ArcGIS Pro

Creating Excel files with Python and XlsxWriter — XlsxWriter Documentation 

Python Excel 

xlrd · PyPI 

You should see if they are installed in your site-packages folder already or you need to do a pip install (arcmap) or if using pro, see whether there is a conda install option

[NeilAyres]

The python packages xlwt & xlrd are included with Pro and Desktop.

xlwt documentation — xlwt 1.3.0 documentation 

Creating Microsoft Excel Spreadsheets with Python and xlwt | The Mouse Vs. The Python