topic Excel Report Error in ArcGIS Monitor Questions

Excel Report Error

AlbertoOrdoñez_García — Thu, 16 May 2019 09:51:08 GMT

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.

Re: Excel Report Error

JohnGraham2 — Fri, 17 May 2019 00:38:55 GMT

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

Re: Excel Report Error

AlbertoOrdoñez_García — Fri, 17 May 2019 07:44:22 GMT

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.