Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
June 4, 2018
Solved

Upload excel file and display it in grid

  • June 4, 2018
  • 1 reply
  • 1979 views

Hi,

I am working on a project where I need to upload a excel file from my system and display its content in grid. On uploading it should direct to a popup with grid and the contents in excel has to be displayed in grid.

I tried to use file upload but its so confusing and the tutorial too didnt help me understand how to make my scenario possible.

Please provide some help.

 

Thanks,

V Shalini.

 

Best answer by mnarang

You can use CSVParser extension from Market place and can read a CSV file in to a grid .There is a service from this extension and that is "ReadCSVFile" .You can take output of this service and map it to grid .But this will only work for CSV file format .

1 reply

M
mnarang5-Regular MemberAnswer
5-Regular Member
June 4, 2018

You can use CSVParser extension from Market place and can read a CSV file in to a grid .There is a service from this extension and that is "ReadCSVFile" .You can take output of this service and map it to grid .But this will only work for CSV file format .

R
Rajesh_R1-Visitor
1-Visitor
September 25, 2019
Hi, Yeah i have used that service which you mentioned and it is working fine. I have build to three grids. One will fetch data from Windchill. Second grid is attached to the output of ReadCSVFile service & it is working fine. Third grid should display both the output of these grid. I have used the snippet Union to combine both the infotable output. It is working while executing the service but is not working in Navigate mashup.
Terms & ConditionsAccessibility statement