laptop and a wrench

Bug

When running the exact codes provided by this documentation: https://developers.arcgis.com/python/guide/part5-generate-reports/#:~:text=Report%20for%20a%20Point,%27reports/esri_poly_business_profile.pdf%27, both "report for a point feature" and "report for a polygon study area" run but do not generate readable files. When launching the generated Excel files, the error message "Excel cannot open the file xxx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." is returned.

ArcGIS API for Python
Bug ID Number BUG-000161921
SubmittedOctober 6, 2023
Last ModifiedJune 23, 2025
Applies toArcGIS API for Python
Version found2.1.1
Operating SystemN/A
Operating System VersionN/A
Version FixedPlanned Release Date: Q1 2025
StatusFixed

Additional Information

The documentation has been updated to remove XLSX file as a supported format for the Business Locator report as it is only supported in PDF format. https://developers.arcgis.com/python/latest/guide/part5-generate-reports/#available-reports

Workaround

According to the example in theĀ ArcGIS REST API documentation on the ArcGIS GeoEnrichment Service with the Create report method, when passing a geometry as a study area, it must have a format as shown in the following example: "geometry":{"x":-117.1956,"y":34.0572}}. For example, when passing in this [{"geometry":{"rings":[[[-117.185412,34.063170],[-122.81,37.81],[-117.200570,34.057196],[-117.185412,34.063170]]],"spatialReference":{"wkid":4326}},"attributes":{"id":"1","name":"optional polygon area name"}}] to study areas in the create_report() function, the excel file generated is readable.

Steps to Reproduce

Bug ID: BUG-000161921

Software:

  • ArcGIS API for Python

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options