Answer

To maintain values using open xml

srinath

11y

978

Hi,

I need have a maintain the cell values in an excel in different worksheets using openxml.

I have 6 columns A,B,C,D,E,F where 'A' has 720 rows, 'B' is splitted in to 6 elements with 120 rows, 'C' with 120 rows, 'D' is splitted in to 5 elements each with 24 rows , 'E' with 24 rows and 'F' with 8 elements with 3 rows each.

Each worksheet can have only 25 rows. so other rows data needed to be shifted to next worksheet.. like wise till end of 720 rows.

after splitting and populating the values from in worksheet, 26th row needed to be as 1st row in next worksheet.

This I have tried to do it by using cell reference but I couldn't achieve it. I have tried in google, I couldn't get the correct solution.

Please help me getting a solution.