Get First 8 columns from an excel and merge to another table

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

@pravin_calvin, Where’s dt coming from

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

1 Like

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.