Skip to main content
G
ghanashyam905071
June 20, 2023
Question

Edit csv file inline in Appian screen

  • June 20, 2023
  • 11 replies
  • 0 views

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
June 20, 2023

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

G
ghanashyam905071Author
June 20, 2023

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
June 20, 2023

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
June 20, 2023

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