Update cell values in an existing Excel workbook

Question

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 Answer

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