Hello Team,
Could anyone please let me know if there is any new plugin or method or smart service to read excel data uploaded and display in Grid.
I have seen, "Parse Excel Spreadsheet to CDT" smart service and 'readexcelsheet()' method.
Looking forward for some response.
Thanks in advance,
Divya
Discussion posts and replies are publicly visible
As far as I know, "Parse Excel Spreadsheet to CDT" from the Excel Tools plugin (iirc) is the suggested method.
Hi Divya,
You can use readExcelSheet() fn, parse it to some cdt type using foreach() and store it in some local variable.
This local variable u can pass to data attribute of gridField.
Do you mean you want to import an excel and show the data in a grid?
More precisely you can use "readexcelsheetpaging()" to extract data from Excel, as an output it would give you a data subset, which will be easy to use further in the grid or any other object.