Dynamic columns

NA_AN · August 21, 2023, 7:52am

Hi

How do I make the number of columns in Excel dynamic?
This means it changes according to the number of columns in the input

thanks

Nguyen_Van_Luong1 · August 21, 2023, 7:55am

Hi @NA_AN ,
do you mean selecting cells after reading ?
you can use index cloumn(0)
start is 0
regards
LNV

ton · August 21, 2023, 8:15am

Will you be able to elaborate more? Or maybe if you could give a sample input and output.

Quenton_Wayne_Rebello · August 21, 2023, 8:24am

After reading the excel sheet, you can either use filter datatable activity or index to select the required cells

Praveen_Mudhiraj · August 21, 2023, 11:47am

can you provide the sample data with input and output.