Convert CSV files to Excel workbooks - Office JS error: Line 33: Worksheet getRangeByIndexes

[thanhrieker]

Hello,

I just got error from Power Automate after implement example convert CSV to Excel by following article bellow:

Article URL

Document about convert CSV to Excel

Issue

All step are working well but with large CSV file I run in troubleshooting and got error:

We were unable to run the script. Please try again.
Office JS error: Line 33: Worksheet getRangeByIndexes: The request failed with status code of 413.

Could you please have a look?

Thanks you
Thanh

[ElizabethSamuel-MSFT]

@thanhrieker Thanks for letting us know about this.

@AlexJerabek Can you take a look?

Thanks.

[AlexJerabek]

Thanks for reporting this @thanhrieker.

Is this error happening when you run the sample in Excel or through Power Automate? If you're seeing it in Excel, can you please share the Session ID? You can find that by going to File > About. That will help our team debug the error.

If possible, could you also provide a version of the .csv file that is generating the error? Please make sure it does not contain any personal or sensitive information before linking to it. Thanks!

[thanhrieker]

Thanks for reporting this @thanhrieker.

Is this error happening when you run the sample in Excel or through Power Automate? If you're seeing it in Excel, can you please share the Session ID? You can find that by going to File > About. That will help our team debug the error.

For sample file the script running well through Power Automate. The error just occur when I run own large file.

If possible, could you also provide a version of the .csv file that is generating the error? Please make sure it does not contain any personal or sensitive information before linking to it. Thanks!

Sorry but I can not provide a version of the .csv file. But I can tell you the file with more than 46.000 rows and 62 columns. Split by semicolon.

Thanks you for your quick reply
Thanh

[AlexJerabek]

Thank you for the response @thanhrieker.

It looks like that error is generated when too much information is being transferred. If that's coming through Power Automate, I think you're hitting this limit:
https://powerusers.microsoft.com/t5/General-Power-Automate/Error-code-413-when-using-Get-File-Content-on-files-larger-than/td-p/212326
You could also be bumping against the 5MB read/write limit of Excel: https://docs.microsoft.com/en-us/office/dev/scripts/testing/platform-limits#excel

If it's the latter, you could try the second version of the CSV script (found here that goes row-by-row. That should split the operations into smaller pieces. However, you may then hit the timeout limit in Power Automate.

Let me tag @GeoffRen to see if he has any insight or suggestions.

[thanhrieker]

Thanks you for your information. Yes, you are right. Our csv file come to the limit of Excel.

If it's the latter, you could try the second version of the CSV script (found here that goes row-by-row. That should split the operations into smaller pieces. However, you may then hit the timeout limit in Power Automate.

I already try both but:

• The first script got error: "The number of rows or columns in the input array doesn't match the size or dimensions of the range."
• Then try second script got error that I report on this issue.

Thanks
Thanh

[AlexJerabek]

Just to confirm, you're using the second script because your CSV file doesn't have equal sized rows, correct? Something like this?

1,2
3,4,5
6,7