TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
srinath
NA
144
0
To maintain values using open xml
Jul 8 2013 11:05 AM
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.
Reply
Answers (
0
)
Word doc to RichTextbox along with shapes and images
properties