I have attached sample excel template. I am trying to upload it & want to save data to the entity.
As it is an Excel template, columns & data are are not started immediately from the 1st row.
When i am trying with "ExcelToRecordList" & it throws an exception: "none of the column headers match with record attributes."
I tried with advanced Excel, but unfortunately, i did not find any option, so that it would start from the specific row.
In AdvancedExcel component to openworkbook, select worksheet, Workbook_GetBinaryData
but i did not find any element which specified converting Excel to a record list from any specific row. or to convert to list so that i can start iterating on it.
Here also, i am getting an error on the last element, Workbook_GetBinaryData() "object reference not set to an instance of element" with 0 bytes.
Hi @Pradip Chavhan
Is this the template fixed, Header (1empty row +4 rows) and Footer(2rows).
In that case, you can follow the steps as shown
1. Create the structure, and follow as in Pic.
2. In For each we can set the start index and Max iterations based on Header and Footer.
For Ex: This will work only incase of the header and footer used in the given excel.
3. The updated entity after creation.
Please let me know if any help needed.
Thanks.
Thank you for your reply. The issue has been resolved; the issue is with accessibility.
You mean to say that the Workbook_GetBinaryData() returned 0 bytes due to accessibility issue ?
btw your excel is custom template and you need to handle explicitly through Advanced Excel which I believe you already handled.