Hi Everyone,
I have stumbled upon a challenge where I need to convert an excel sheet having 2 sheets in it, in both sheet the columns are different. As I need to work on the details in it, I hoping for the solution.
I tried using Excel TO Record List in server action, however, it asks for the record definition and I can assign only one sheet as structure.
Kindly help, Thank you
Hi @Chandrashekhar Mankar
Could you please provide a detailed description of the issues you're facing and your requirements?
If I understand correctly, you are trying to extract data from two different sheets and then organize them into 2 different structures. So want to assign the data from your Excel sheet to a structure, you can utilize the "Sheet Name" property in the "ExcelToRecordList" function.
Hope this helps you.
Thank you.
Hi @Rishabh Chawda
I also have a problem, If 2 sheet have the same structure, how to get list of sheet name from File Content. Thank you