Skip to main content
V
vinays346
August 30, 2024
Question

Add new columns to user uploaded excel with data?

  • August 30, 2024
  • 4 replies
  • 0 views

Can we add new columns to User Uploaded excel with columns and data already in it? 

Note: The added column's data is not unique for all the records

4 replies

karumurua531442
karumurua531442
August 31, 2024

hi,[mention:0dc49b57dcb749db86acd69375be40df:e9ed411860ed4f2ba0265705b8793d05]  may I know more details on your use case, please?

V
vinays346Author
September 3, 2024

Hi [mention:3510a5189ce1477eaf2e09f5858c87e9:e9ed411860ed4f2ba0265705b8793d05] - User uploads a file and it will have records in it. In Appian, I have to process each record and add two columns with status, reason which varies for every row. I have to give the file back to user to export/download it with the two columns in it.

mikes0011
mikes0011
Brainy
September 3, 2024

This is pretty advanced funcitonality within Excel to try to reproduce programmatically within Appian.  I suspect (beyond the development of a brand new bespoke and fairly complex Excel Handling Plug-in, which would need to be done by you or someone on your project team), the closest you'll be able to get is to read in the original Excel data, then generate a brand new exported Excel document after some manipulation to the original data, via the CDT to Excel service in Excel Tools. 

Though I'd stress that your output from doing this sort of thing will be a new document with its own formatting and not necessarily matching the original very strongly, in terms of aesthetics / formatting / etc.  Plus the usual caveat that the CDT to Excel smart service, though still 100% functional, is technically deprecated (but still not functionally replaced with anything else, which IMHO merits using it when still necessary).

Terms & ConditionsAccessibility statement