Excel Report Error

[AlbertoOrdoñez_García]

Hi all,

we are getting the following error trying to create a Excel Report (Reports > Excel) in ArcGIS Monitor 10.7.

Any idea on how to resolve this?

Thank you.

[JohnGraham2 · Accepted solution]

Hi Alberto,

The xlsxwriter used to write_url to a cell in Excel returns this error when the Url is longer than the Excel limit of 255 characters. A solution would be to use a shorter url. A url (String) longer than the Excel limit of 255 characters would need to be somehow split or truncated to fit in the Excel limit to prevent this error. Reference:

https://xlsxwriter.readthedocs.io/worksheet.html

[AlbertoOrdoñez_García]

Hi John,

thanks for your response. As you can see in the images, service URL is not especially long, the thing is that for any reason it is also inluded the token string and i don't know how i can avoid this.

Thank you.