So I’ve been trying to copy a sheet from an excel to another, but with a different sheet name. Before the copy starts, Would Kill Application for Excel. Add an Excel Application Scope With Copy sheet activity inside of it. The Excel App Workbook path is file1, copy “Orders” sheet from it, then add to to excel file2 with sheetname “Failed Orders”. The file2 will always be new or created by excel application app.
Problem is, It keeps giving me either, 0x800706ba or 0x800a03ec error. I’ve tried using balareva’s “Create Workbook” , add delay, then “Copy To File” to copy the sheet. But the same error occurs on “Copy To File” activity.
Hi @Archie
Use Read range activity where mention the particular sheetname we want to get extracted with data and get the output with a variable of type datatable named dt
Now use WRITE RANGE activity and mention the sheetname we want and range as “” with ADD HEADERS property enabled and pass the variable dt as input
This will write that datatable to the new sheet
This one works for tabled excels. Problem is, there I have many excel files that aren’t table where the datas needed are in an exact cell location. Some Sheets are also in pictures so read ranging does not work.
As suggested by @nikhil.girish ,you can use a Read Range Activity to copy the desired range, and then for the sheet name, you can pass that value into the Write Range Activity which will then create a new sheet with the desired name.
Hey @Archie both @nikhil.girish and @ashwin.ashok suggestion is correct.
I’m also suggest the same why you are tell that it is not working? Have check the suggestion
This is the file, I’m trying to read range all but they are formatted like this. The Receipt Tab is also needed if the order process did not fail, but that sheet only contains the picture of the recepit
Anil_G
sonaliaggarwal47
ashokkarale
sharazkm32
Jon_Smith
Bal_Son
Nitesh
Marielle_Timajo_Apay_NCS
adi.mehare
Youri98