Skip to main content
ghanashyam905071
Known Participant
Jun 20, 2023 5:09 AM UTC
Question

Edit csv file inline in Appian screen

Hi Champs,

Is there any way to edit CSV file inline in Appian screen and storing them back to Appian as document.

Regards,

Ghanashyam

11 replies

stefanhelzle0001
stefanhelzle0001
Brainy
Jun 20, 2023 5:30 AM UTC

Depends on the size. A larger volume of on screen controls makes the UI become sluggish. Do you mind providing a bit more background?

ghanashyam905071Author
Known Participant
Jun 20, 2023 6:28 AM UTC

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.

Regards,

Ghanashyam

harshitb6843
harshitb6843
Brainy
Jun 20, 2023 6:36 AM UTC

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?

stewart.burchell
stewart.burchell
Employee
Jun 20, 2023 8:58 AM UTC

You might want to try and reimagine this so as to add value to the users who are using it. As you describe it I cannot see any reason not to just use Excel natively. But if you can wrap process/data validation/approvals etc etc around the import/edit/export of the data then you'll be leveraging Appian to add value to your user community.

Terms & ConditionsAccessibility statement