Data excel

Help Studio
, ,
1

Uploading: excel1.xlsx…

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
21

i want output like these excel file
output.xlsx (29.5 KB)

guyes help me please

2

Guys please help me in that process
Can you do these process than send me the xmal file

3

Hello @purnima_mandan

in the output sheet i can see more number of rows than 5. Also the input excel is not uploaded properly.

Please check.

Thanks

4

Yes output file was right because I 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 data of row

5

Hello @purnima_mandan
Find the Xaml file attached here, it may gives some idea to you.
Forum_GetLast5Row.zip (176.5 KB)

6

I think @Gokul_Jayakumar provided with that let us know if you still need help

7

these was not a right a output i want output like these

output.xlsx (29.5 KB)

and these is colume scrreen shot
24
25
26
in that image can you show the last5 data of every 3 colume group after partition it will be new 3 colume group so we have to output file like these

23
23292×620 7.38 KB

every colume group we have to take the last 5 data

and main excel file is here

Uploading: excel1 (1).xlsx…

these was the full explanation of my process is given below:-

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

Yes output file was right because I 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 data of row

please guyes can you help me to do these project

8

excel1 (1).xlsx (9.4 MB)

this is the excel file

9

Hello @purnima_mandan

Kindly Refer to this Xaml file, You may get some idea
Excel_Column_Read_Dynamical.zip (346.8 KB)

10

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