Join
Sign in
Search Options
Search Everything
Search Development Tools
Home
Blog
Resources
Forums
About Open XML
More ...
Home
»
Forums
»
Development Tools
»
.Net
»
Howto copy a sheet between two different spreadsheetdocuments?
Howto copy a sheet between two different spreadsheetdocuments?
Development Tools
Discussions about working with Open XML using a wide range of development tools
Get this RSS feed
Details
1
Reply
1
Subscriber
Posted
over 2 years ago
Options
Subscribe via RSS
Share this
.Net
Howto copy a sheet between two different spreadsheetdocuments?
rated by 0 users
This post has
1 Reply |
1
Follower
oyvindolsen
40
Posted by
oyvindolsen
on
Mon, Apr 26 2010 3:07 AM
rated by 0 users
Post Points: 20
Howto copy a sheet between two different spreadsheetdocuments?
Hello
I'm trying to open a spreadsheet and create another spreasheet. Can anyone tell me how I can copy a sheet from the opened spreadsheet to the created spreadsheet?
I'm using C#.
Regards
Øyvind Olsen
Intergen
2610
Posted by
Intergen
on
Thu, Jul 22 2010 5:42 PM
rated by 0 users
Post Points: 5
Re: Howto copy a sheet between two different spreadsheetdocuments?
Hi Øyvind
I had a crack at how to do this but it's difficult due to IDs and shared strings that are tied to a sheet - to copy this straight to another SpreadsheetDocument is not straight forward..
You could try creating a new worksheet and then copying the contents into the new one.
I'm happy to help out with any trouble you have - but this isn't a simple task.
There's a blog post discussing how to do this here:
http://blogs.msdn.com/b/brian_jones/archive/2009/02/19/how-to-copy-a-worksheet-within-a-workbook.aspx
Page 1 of 1 (2 items)