Excel Upload with specific columns
Hi All,
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.
Pegasystems Inc.
IN
Hello,
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.
TCS
US
MSOParseExcelFile is a good option till you are using plain excel without formula , if your excel contains Formula and Macros MSOParseExcelFile does not work.
Use Apache POI api in that case to get data from the excel cells where formula and macro are involved.