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
i want output like these excel file
output.xlsx (29.5 KB)
guyes help me please
Guys please help me in that process
Can you do these process than send me the xmal file
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
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
Hello @purnima_mandan
Find the Xaml file attached here, it may gives some idea to you.
Forum_GetLast5Row.zip (176.5 KB)
I think @Gokul_Jayakumar provided with that let us know if you still need help
these was not a right a output i want output like these
output.xlsx (29.5 KB)
and these is colume scrreen shot
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
and main excel file is here
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
excel1 (1).xlsx (9.4 MB)
this is the excel file
Hello @purnima_mandan
Kindly Refer to this Xaml file, You may get some idea
Excel_Column_Read_Dynamical.zip (346.8 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
