how to read all excel file rows by using advanced excel
Hi Sean,
I don't think that's what Omar means. He doesn't talk at all about populating an entity, so why do you think he does?
Hi Omar,
Have you seen this article from the documentation: https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Bootstrap_an_Entity_Using_an_Excel_File
OutSystems lets you create a new Entity and populate it with data directly from the Excel spreadsheet pretty easily in Service Studio.
Hope this helps!
Do we have any answers for this?I also need this, bcz, using default ExcelToRecordList gives only 1,93,000 records but my excel have million records.what to do in this case?
Hi Aravind
At the moment the only way to achieve this is by getting the number of rows and columns using `Worksheet_GetProperties` and then iterating through rows/columns and use `Cell_Read` to return the values.
Curious about your challenge with `ExcelToRecordList`... Does your excel sheet perhaps have blank rows?
No blank rows, we have 3lakh records in Excel but it's not giving the record list of all 3 lakh records.
Okay I'll try this Hanna.
Perhaps row 1,93,001 has invalid data and ExcelToRecordList is just failing silently?
It has valid data and failing silently
Have you tried deleting row 193001 to see if the import processes further after that? Maybe there is some weird character/text in one of the columns?
Okay let me check it.