Add new columns to user uploaded excel with data?

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

Parents Reply
  • 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).

Children
No Data