You’re offline. This is a read only version of the page.
276
How can I fix this issue I'm having with LARGE Excel Files?
It appears to be timming out every 2 minutes, which appears to not be long enough for it to convert to a table.
I keep getting this bad gateway...and the werid thing is this worked fine 6 months ago, but now it doesn't and two minutes appears to now not be long enough to complete the script???
Understood.
Thank you Mark!
So my requirement was a bit different than yours. Mine was already in Excel, it appears you need to convert it from CSV to Excel. The link you provided appears to give you code to accomodate for the size.
In my situation, I needed to convert the Excel File to a Table, then I was validating no empty cells, row headers match a template, etc. I needed to split them up...so Script 1 ONLY does the Convert to Excel, then I have another script that validates the row headers, then I have another script that validates no empty fields.
Like I mentioned before, trying to do all that in one script was causing it to timeout.
Good luck,
Mark
Office script is running successfully with below 200 rows.
But currently I have around 2000 rows in my CSV.
I want to copy paste it into excel workbook.
Here I am getting this bad gateway error.
Could you please guide me on making separate scripts?
It would be great If I get some reference.
Thanks for your response!
Currently I am using the below script - Convert incoming CSV data into a range and add it to the workbook.(MS Page)
Ref : https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv
What I ended up doing was breaking up the code or actions or validation or whatever you are doing into smaller scripts. So instead of doing 3 things in one script, I ended up doing each of those 3 in 3 seperate scripts. So that each script will have time to complete. Trying to do too much stuff/code in one script will just make it timeout.
Good Luck!
Mark
I am facing the same issue now, what should I do?
Share
Report
All responses (
Answers (
