Hi devs, please I need assistance getting the first 8 columns of excel and their values and merging to another table.The logic to get that. Regards
Hi @RPA-botDev
How about the read range as Dynamic to fetch 8 Column from the datatable
Check with the below experssion!
Step1: Read Range the WholeExcel
Step2:Read Range the Excel Using
Giving range as below.
“A1:”+Convert.tochar(64+8).toString+Dt.Rows.Count.ToString
Regards
When you say merge, do you want use a value as an index to add corresponding information from the 8 columns? Or do you simply want to grab those 8 columns and place them into a different table?
Hi @RPA-botDev
First Read Range the whole Excel without mentioning the range and from that the Dt variable comes from!
Then in the second readRange try using the Range
A1:"+Convert.tochar(64+7).toString+Dt.Rows.Count.ToString
It will read upto column H with all the data
Regards
Yea, I want to grab those 8 columns and place them into a different table
Hi @RPA-botDev
Can we see the structure of the excel or ScreenShot of that excel hiding the sensistive information!
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.