How can I create a new spreadsheet file using the OOXML SDK that contains multiple worksheets?

Posted by Shawn Simon on Stack Overflow See other posts from Stack Overflow or by Shawn Simon
Published on 2010-05-18T21:32:27Z Indexed on 2010/05/18 21:40 UTC
Read the original article Hit count: 363

Filed under:

ooxml-sdk

|

c#

|

excel-2007

I downloaded the OOXML SDK. I need to create a simple excel spreadsheet that has x worksheets, each with 4 columns and y rows of data. It's pretty simple, but I can't find an example of how to create sheets anywhere. I am going absolutely insane here.

Thanks

© Stack Overflow or respective owner

Related posts about ooxml-sdk

How can I create a new spreadsheet file using the OOXML SDK that contains multiple worksheets?

as seen on Stack Overflow - Search for 'Stack Overflow'
I downloaded the OOXML SDK. I need to create a simple excel spreadsheet that has x worksheets, each with 4 columns and y rows of data. It's pretty simple, but I can't find an example of how to create sheets anywhere. I am going absolutely insane here. Thanks >>> More
Update Since Microsoft/PSC Office Open XML Case Study

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
In 2009 Microsoft released a case study about a project that we had done using the OOXML SDK 1.0 for Research Directors Inc. Since that time Microsoft has released version 2.0 of the SDK and PSC has done significant development with it. Below are some of the mile stones we have reached since the… >>> More
Chicago Code Camp Recap

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
My presentation on leveraging Open XML was a great experience and the attendees were very gracious. I was pleasantly surprised to have a full room. There was even one person sitting on the floor. You can check out some pictures here. I have posted my slides and code. If anyone has any feedback… >>> More
Speaking At The Chicago Code Camp

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I just got news that my talk on Office Open XML has been accepted for the Chicago Code Camp. I hear that they will be announcing the full schedule of sessions soon. Be sure to register and join us. As a bonus the guys from .NET Rocks will be there. http://www.chicagocodecamp.com del.icio.us Tags:… >>> More

Related posts about c#

.NET WebRequest.PreAuthenticate not quite what it sounds like

as seen on West-Wind - Search for 'West-Wind'
I’ve run into the problem a few times now: How to pre-authenticate .NET WebRequest calls doing an HTTP call to the server – essentially send authentication credentials on the very first request instead of waiting for a server challenge first? At first glance this sound like it should be easy:… >>> More
HttpWebRequest and Ignoring SSL Certificate Errors

as seen on West-Wind - Search for 'West-Wind'
Man I can't believe this. I'm still mucking around with OFX servers and it drives me absolutely crazy how some these servers are just so unbelievably misconfigured. I've recently hit three different 3 major brokerages which fail HTTP validation with bad or corrupt certificates at least according to… >>> More
The dynamic Type in C# Simplifies COM Member Access from Visual FoxPro

as seen on West-Wind - Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot… >>> More
Dynamic Type to do away with Reflection

as seen on West-Wind - Search for 'West-Wind'
The dynamic type in C# 4.0 is a welcome addition to the language. One thing I’ve been doing a lot with it is to remove explicit Reflection code that’s often necessary when you ‘dynamically’ need to walk and object hierarchy. In the past I’ve had a number of ReflectionUtils that used string based expressions… >>> More
Finding a Relative Path in .NET

as seen on West-Wind - Search for 'West-Wind'
Here’s a nice and simple path utility that I’ve needed in a number of applications: I need to find a relative path based on a base path. So if I’m working in a folder called c:\temp\templates\ and I want to find a relative path for c:\temp\templates\subdir\test.txt I want to receive back subdir\test… >>> More