Merging three different workbook into one sheet
Hey,
I have a requirement that want me to automate the merge three sheet from different workbooks into one new workbook with some manipulation on columns of workbooks.
can anyone suggests me way to do that , since I am beginner in pega studio?
Accepted Solution
Pegasystems Inc.
US
Read all the posts here on Excel. Search using "robotics excel". For example, here is a post that may help:
Accenture India PVT Ltd
IN
Hi,
What if i have to copy data from three different workbook into three different sheet of one workbook.
Can you please suggest me how can i do that....as i have tried using three export and import component but it did not work and also for importing in one workbook, we have to take three different component of excel and providing the pat of same file as one component will not let you select all three different sheet.
Can you please help.
Thanks
Pegasystems Inc.
US
I am unclear of what you mean by three components. If you are simply moving data around one workbook, then you should only have one Excel connector. You would use the ExportData method to export the range of data from one sheet and the ImportData to move it to the new sheet.