Excelfile

Help Studio
, ,
1

I have one excel file in that file there are many rows ans many columns in that excel 1,2,3 column with data but 4th column is blank then 5,6,7 with data and 8th column is blank as you can see in my attachment i upload image there are input and output both file how to do that i want last 5 last column in output can you do this programme

2022-12-27 (2)
2022-12-27 (2)1920×1080 235 KB

2

Surya -
I’d love to help, but could you please do us a favor and reword your post? It’s a little confusing to read through and I’m not sure what exactly the problem is

3

in that sheet1 excel file we have to take last 5 data of every colume
it means in the excel file there will be group of 3 colume after 1 colume is blue colour partetion
so in every 3 colume we have to take last 5 data of every partition

like these we did not take blank data only we have to complete full row data taken and paste into excel file like

we have to copy all the colume means in excel file there will be 3 column partition so we have to take all the colume one by one to group of 3 that’s why data is more than 5 row

First 5 row data in the output file is first 3 colume group

After 5 row data is after partition 3 group of colume group

Next also 5 row data is after partition
So we have to take all the last 5 d
I have given both file input and out put in image

4

Hello @Surya_Pawar
Kindly Refer to this XAML file, You may get some idea
Excel_Column_Read_Dynamical.zip (346.8 KB)

2 Likes