Hi Champs,
Is there any way to edit CSV file inline in Appian screen and storing them back to Appian as document.
Regards,
Ghanashyam
Discussion posts and replies are publicly visible
Depends on the size. A larger volume of on screen controls makes the UI become sluggish. Do you mind providing a bit more background?
Hi Stefan,
Thanks for the reply. So the use case is the user can upload a csv file having around 1000 -2000 rows and we need to update any row over the appian screen . After update , we need to create a new version of the csv file and upload it back to appian folder. Here one of the main catch is that ,the header of the excel is dynamic not static.
Should not be a problem with the headers. I am more concerned about the 1000 rows because we are talking about editing all of them in a single view using the editable grid.
Can the edit happen anywhere in Excel? Like rows 1, 295, and 784?
This is a use case, Appian is not really made for. Try the following approach:
- Import the data into a database table
- Create the UI to browse the data and modify it. Use paging to limit the on-screen data volume
- Store the data back to the DB
- Export the data from the DB to the CSV.