Hi, Is there any way to combine multiple Excel files into one excel f

subhojitm

Certified Associate Developer

over 10 years ago

Hi,
Is there any way to combine multiple Excel files into one excel file. Is there any such smart service or any other way to achieve that?
...

Discussion posts and replies are publicly visible

Parents

0 siddharthg521 over 10 years ago

Hi,
You can parse your each excel data in your process variables/CDT (one process variable for each excel) using existing read excel service. Once you have the data of all your excel in Appian process, use export to excel service to generate a new excel by dumping data from process variables to different sheets of the same workbook/excel.

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 siddharthg521 over 10 years ago

Hi,
You can parse your each excel data in your process variables/CDT (one process variable for each excel) using existing read excel service. Once you have the data of all your excel in Appian process, use export to excel service to generate a new excel by dumping data from process variables to different sheets of the same workbook/excel.

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data