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
Discussion posts and replies are publicly visible
hi,vinays346 may I know more details on your use case, please?
Hi Abhishek Karumuru - 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.
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).