Posted: 29 Apr 2019 4:44 EDT Last activity: 2 May 2019 13:28 EDT
Excel Upload with specific columns
Need some help , According to the requirement user should upload a excel and data of that should get displayed on the screen in table view and gets saved in the pagelist fro further processing .
But here if the user uploads a file with 80 column and and i want to show data for only specific 10 columns of that UI what approach should I follow ?
I am using Table grid for viewing the data and for upload i am using "MSOParseExcelFile" ootb activity with input parameters as its template file name and binary file, using this above mentioned requirement is working fine if the user uploads a file with the columns present on UI.
The OOTB activity will create a pagelist which can be mapped to a grid to display the data.
Now to cater your requirement, you need to create your custom activity which will essentially perform the filtering from the existing page list, pick the data from each row and map them to a new page list.