I have different sheets in one excel in each sheet some row values to paste in another excel sheets specific row
I couldn’t able to use 2 read range activity “Add header” checked.
I need each sheet going to read ,but could able to read first sheet only
please can anyone help this.
May I know the error that you are facing when read another sheet .
Use GetWorkbookSheets activity
Use For Each Activity to loop thru each sheet.
Check the below link to red all sheets of excel
This is my error
“Read Range: A column named ‘.’ already belongs to this DataTable.”
Ok, you can build your own Datatable, also don’t include the headers in excel sheet, because It will throw the same exception already belongs to this DataTable
The cause of this error: data in first row is same with second row.
You need to read data from Excel files with specify range.
Please refer as below for guideline
(*Please chnge file path in below sample workflow first)
ReadRange.zip (21.2 KB)
I hope it will be useful to you
thanks, but yours code first activity i couldn’t able to see,
This activity is BalaReva EasyExcel Activities,
You can refer as below to install it
I have developed some activities to make easy excel automation.
Package manage Search keyword: Balareva.easyexcel
An activity library that makes Excel automation very easy
This package contains activities that will help automate your work with Excel. The below activities are available:
ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images.
ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet.
It is a very nice activity for handle excel.
I use it for find Last column name
HI I am new to RPA can i read a column by its name? my column position is not fixed and i want to locate it by its name in my process… I tired to put the Column header in the Range but I’m getting error as it needs cell number…but i cant put cell number i need to find it by its name…is there a way to achieve thiss…