Excel Report Error

399
2
Jump to solution
05-16-2019 02:51 AM
AlbertoOrdoñez_García
New Contributor III

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.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
JohnGraham2
Occasional Contributor

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

View solution in original post

0 Kudos
2 Replies
JohnGraham2
Occasional Contributor

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

0 Kudos
AlbertoOrdoñez_García
New Contributor III

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.

0 Kudos