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-Nummer BUG-000161921
EingereichtOctober 6, 2023
Zuletzt geändertJune 23, 2025
Gilt fürArcGIS API for Python
Gefunden in Version2.1.1
BetriebssystemN/A
BetriebssystemversionN/A
Behoben in VersionPlanned Release Date: Q1 2025
StatusFixed

Zusätzliche Informationen

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.

Schritte zur Reproduzierung

Bug-ID: BUG-000161921

Software:

  • ArcGIS API for Python

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln