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
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