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
Discussion posts and replies are publicly visible
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.
Please check https://community.appian.com/b/appmarket/posts/excel-utilityYou can combine multiple Excel files into a single file containing sheets of all the combined files
Hi Amit,Yes it worked. But it's getting the sheet names as "Sheet0", "Sheet1"...etcIs there any way to change the Sheet names as well.
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...
Thanks for your reply, I have a lot more information about this uno online