Hi everyone,
This is a strange behaviour for me: I'm downloading an excel file that's being populated with data and I'm using a template as resource file. This template has 7 sheets, each with some formulas in it.
After downloading the file I will simply upload it again. When I upload the action ExcelToRecordList throws an error "Error: Index was out of range. Must be non-negative and less than the size of the col ".
If I repeat the same steps, download, but instead of uploading right away, I open the downloaded file and simply save it, then I can upload sucessfully with no errors. Why? I thought the error could be a mismatch with the structure, but after saving the file everything works.
I'm using this component but I'm really not sure if this is something with the component or the formulas present in the excel template that is causing this.
I've tried changing the mime-type from the generic one to "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet ". No luck.
Has anyone ever faced this issue?
Thanks.
Hi @RhuanW
I'm assuming you are using Advanced Excel to populate the templates with data?
Are you evaluating the formulas before downloading the Excel file?
Hi @Hanno ,
Yes, I’m using advanced excel :
Workbook_Open(resource.template)
Worksheet_Select(), Cell Write(), CellWriteRange(), Workbook_GetBinary()
I’m not sure what you mean by evaluating the formulas, the formulas are already in the template, we’re just filling it with data, so the formula columns can calculate. I’ve added the Calculate actions from advanced excel to see if it works, but again no luck.
Thanks for the reply
Hi Rhuan
Yeah, I was alluding to using the Calculate action but should have been more clear, sorry.
I guess the only way to see if it is the formulas is to remove them all from the template and see if you still get an error.
If not, then it might be a case of trial and error to try and identify which of the formulas might be causing the issue...
Unless it is actually data related? Can you perhaps download/upload without doing the data fill and see if you still get the error?
Hi RhuanW,
Please share your OML file and excel sheet.
Thanks,
Ramesh
Hi Rhuan,
Don't want to introduce more confusion to your issue. But can you please check if you're getting problems due to an unsupported function? Also, is it possible that you share even a simplified version of your template file so we can better troubleshoot and help you?
I'll leave here a list of supported function: