Update cell values in an existing Excel workbook

2860
2
Jump to solution
08-31-2018 03:19 AM
deleted-user-r12oOPKQjs2J
New Contributor III

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)

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Esteemed Contributor

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

View solution in original post

2 Replies
DanPatterson_Retired
MVP Esteemed Contributor

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
MVP Frequent Contributor