
I have a feeling I'm overthinking this and the answer is simple.
I am trying to manufacturer a dual-gallery setup in which the gallery on the left will display the Excel files in a Sharepoint library and when a file is selected, the rows of that Excel spreadsheet will display in the gallery on the right. I'm struggling to find an example of this done already.
I imagine a collection containing the file rows could be generated On-Select of the left gallery file, then populate the collection in the right-side gallery? Or is there a simpler method?
Hi @Ginko ,
The requirement cannot be fulfilled unless the column names of the tables in all excel files are the same.
If all your Excel formats are the same, I will provide a sample.
Hope it helps.
Best Regards,
Wearsky