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).
As Mike mentioned you can create a new Excel document. You will have to add these columns in your database and add null values when you upload the file. When you process your records you can add the values into those columns. You can use the Export DSE to Excel. But you need to manually download this generated document. Also as Mike mentioned you would not have the same formatting in the generated file compared to your original document that has been uploaded.
When you say this, what is the role of user post uploading the file.
vinays346 said: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.