topic Re: Update cell values in an existing Excel workbook in Geoprocessing Questions

Update cell values in an existing Excel workbook

deleted-user-r12oOPKQjs2J — Fri, 31 Aug 2018 10:19:24 GMT

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)

Re: Update cell values in an existing Excel workbook

DanPatterson_Retired — Fri, 31 Aug 2018 10:48:02 GMT

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

Re: Update cell values in an existing Excel workbook

NeilAyres — Fri, 31 Aug 2018 10:52:45 GMT

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