Read Range from InputBox

Hi Everyone.

I have range from A1:D10… but I want to Read Range only base on text which inputed into the Input Dialog Window as below picture.

Exp: I want to read range “A1:C5”… I have entered A1:C5 into the the InputBox… and then I want to read this range to write into datatable

Thank in advance!

Hi @trunghai

in read range in range pass: “”+range.toString+""

Regards,
Kommi Jeevan.

1 Like

Hi Bro

I have tried to change but the result not correct as below picture.

Item.xlsx (9.2 KB) Main.xaml (11.6 KB)

@trunghai
Give a try on removing the doubled quotes
Use range.tostring only for the Range setting

1 Like

Hi Bro

I have changed it but still same.

Pls kind check in my XAML as above.

Thanks you!

@trunghai
I Guess the confusions comes from your for each Block and Ränge Split Logic. I assume you want to write Out the Data that you have read in.

So Just use dt_out in the write range

2 Likes

Hi Bro.

Thanks you so much!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.