topic Re: Error exporting table to Excel format from ArcGIS Pro 2.6 in ArcGIS Pro Questions

Error exporting table to Excel format from ArcGIS Pro 2.6

josuedi — Wed, 26 Aug 2020 13:48:46 GMT

Hello everyone!

I am trying to export a table from ArcGIS Pro 2.6 to Excel (xlsx) format, I have excel 2013. The table contains 86,775 records, but when I try to export this data in the end it gives me an error that is described below. I would appreciate your support.

I have tried to resolve the error in the following way.

1. I have exported the table to another geodatabase again.
2. I have checked that the fields have the proper format.

Traceback (most recent call last):
File "C:\Program Files\ArcGIS\Pro\Resources\ArcToolBox\Scripts\TableToExcel.py", line 317, in <module>
arcpy.GetParameter(3))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcToolBox\Scripts\TableToExcel.py", line 226, in table_to_excel
worksheet.append(rowUpdated)
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\worksheet\_write_only.py", line 119, in append
self._rows.send(row)
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\worksheet\_write_only.py", line 71, in _write_rows
self._writer.write_row(xf, row, row_idx)
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\worksheet\_writer.py", line 136, in write_row
for cell in row:
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\worksheet\_write_only.py", line 132, in _values_to_row
cell.value = value
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\cell\cell.py", line 216, in value
self._bind_value(value)
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\cell\cell.py", line 192, in _bind_value
value = self.check_string(value)
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\openpyxl\cell\cell.py", line 159, in check_string
raise IllegalCharacterError
openpyxl.utils.exceptions.IllegalCharacterError
Failed to execute (TableToExcel).

Thanks!

Re: Error exporting table to Excel format from ArcGIS Pro 2.6

Robert_LeClair — Wed, 26 Aug 2020 15:54:35 GMT

Josue - question. Have you installed the Microsoft Access Database Engine driver to work with Excel files in AGP? You may learn more here.

Re: Error exporting table to Excel format from ArcGIS Pro 2.6

josuedi — Wed, 26 Aug 2020 18:11:42 GMT

Hi Robert.

Yes, i have installed Microsoft Accedd Database Engine.

Re: Error exporting table to Excel format from ArcGIS Pro 2.6

josuedi — Wed, 26 Aug 2020 18:52:00 GMT

The Problem is only with .xlsx format, because when i will go export in .xls format (65,000) records, the export is successful.

Re: Error exporting table to Excel format from ArcGIS Pro 2.6

DanPatterson — Wed, 26 Aug 2020 19:53:14 GMT

Do you have anything other than plain text or numbers in your table?

There is something with the conversion process that isn't liked (based on the last few lines of errors).

I am sure you have gone through this in detail

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

But you might also want to try to export to a *.csv using

Table To Table (Conversion)—ArcGIS Pro | Documentation

Then bring that into Excel, just in case the converter (python package) that esri is using has a 'glitch' or some other issue.

Re: Error exporting table to Excel format from ArcGIS Pro 2.6

josuedi — Wed, 26 Aug 2020 22:24:25 GMT

Hello Dan.

You're right. The problem is with the format of some fields. I removed some fields that I understood to have the problem and the problem was solved. Thank you very much for the help.

Best Regard,

Re: Error exporting table to Excel format from ArcGIS Pro 2.6

DanPatterson — Wed, 26 Aug 2020 22:26:15 GMT

Glad it worked out.