Skip to main content
sivasuryap0002
sivasuryap0002
May 13, 2023
Question

Excel Functions

  • May 13, 2023
  • 4 replies
  • 0 views

Hi All,

I have multiple individual excel files and i have a requirement that each file should be made aa a sheets in a  new single excel file.
is there any plug-in/way to achieve this ?

Thanks in Advance,
SSP

    4 replies

    wajahata0003
    wajahata0003
    May 14, 2023

    You can try creating a Process flow and use Export Data Store Entity to Excel to achieve it. Iterate over it so that the output of this smart service should be the input file of the next iteration with updated Sheet name and data. 

    amitm956894
    amitm956894
    May 15, 2023

    Please check https://community.appian.com/b/appmarket/posts/excel-utility
    You can combine multiple Excel files into a single file containing sheets of all the combined files

    sivasuryap0002
    sivasuryap0002Author
    May 15, 2023

    Hi Amit,
    Yes it worked. But it's getting the sheet names as "Sheet0", "Sheet1"...etc
    Is there any way to change the Sheet names as well.

    amitm956894
    amitm956894
    May 15, 2023

    As per the given utility, you can't rename sheet , while using "Merge Excel Documents".
    If it is very important for you then a work around is to dump all you data in staging tables (1 table per sheet) and then "Export Data Store Entity to Excel" in loop for each sheet where you can provide your sheet name(s). But this is not a ideal way or best practice. So avoid to use and convince user to use "Sheet 0","Sheet 1" etc...

    Terms & ConditionsAccessibility statement