OpenXML SDK Spreadsheet starter kits

Posted by JWendel on Stack Overflow See other posts from Stack Overflow or by JWendel
Published on 2009-05-05T09:24:11Z Indexed on 2010/05/03 18:48 UTC
Read the original article Hit count: 559

Filed under:

openxml

|

openxml-sdk

|

SDK

|

excel

|

spreadsheetml

I am trying to start working with excel documents through the OpenXML SDK Spreadsheet API. But I havent found any good guides or even examples on how to create a xlsx file from scratch. Only how to open an existing document and modify it.

I have been thinking on having a empty template document and make a copy of it an then begin my proccessing on it. But it doesent feel right. It might be easier but I not comfortable using a technique I dont feel that I understand "pretty" good atleast.

So my question is: Anyone has any god tips on articles or books or any other type of resource that explains the API.

Thanks in advance. /johan

© Stack Overflow or respective owner

Related posts about openxml

Convert OpenXml Excel files to HTML

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. I'm developing printing solution for MS Office 2007, office automation is not good for me, because it requires installed office. Open XML Document Viewer is solution for converting Word files (.docx) to HTML format by XSLT transform, but it works only for .docx. Can you suppose related or similar… >>> More
Remove mailmerge data source via OpenXML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided). I initially tested this against a document created in Office 2007 and it seemed to work great. We then created one in 2003 based… >>> More
Can someone explain how OpenXML works(in this SP)?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am looking at this tutorial and it confuses me as I don't get the SP CREATE PROCEDURE [dbo].[spTEST_InsertXMLTEST_TEST](@UpdatedProdData nText) AS DECLARE @hDoc int exec sp_xml_preparedocument @hDoc OUTPUT,@UpdatedProdData INSERT INTO TBL_TEST_TEST(NAME) SELECT XMLProdTable.NAME … >>> More
Retrieve the content of Microsoft Word document using OpenXml and C#

as seen on YBBest - Search for 'YBBest'
One of the tasks involves me to retrieve the contents of Microsoft Word document (word2007 above). I try to search for some resources online with not much luck; most of the examples are for writing contents to word document using OpenXml. I decide to blog this as my reference and hopefully people… >>> More
OpenXML SDK: Make Excel recalculate formula

as seen on Stack Overflow - Search for 'Stack Overflow'
I update some cells of an Excel spreadsheet through the Microsoft Office OpenXML SDK 2.0. Changing the values makes all cells containing formula that depend on the changed cells invalid. However, due to the cached values Excel does not recalculate the formular, even if the user clicks on "Calculate… >>> More

Related posts about openxml-sdk

OpenXML SDK: Make Excel recalculate formula

as seen on Stack Overflow - Search for 'Stack Overflow'
I update some cells of an Excel spreadsheet through the Microsoft Office OpenXML SDK 2.0. Changing the values makes all cells containing formula that depend on the changed cells invalid. However, due to the cached values Excel does not recalculate the formular, even if the user clicks on "Calculate… >>> More
OpenXML SDK Spreadsheet starter kits

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to start working with excel documents through the OpenXML SDK Spreadsheet API. But I havent found any good guides or even examples on how to create a xlsx file from scratch. Only how to open an existing document and modify it. I have been thinking on having a empty template document and… >>> More
Associating Worksheets with their Names using OpenXML SDK 1.0

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using version 1.0 of Microsoft's OpenXML SDK to do some basic parsing of .xlsx files. I can get and parse the worksheets, and I can get a list of worksheet names, but I cannot for the life of me figure out how to link up what name goes with what worksheet. I understand that an element like <sheet… >>> More
How to create a Word document from a Silverlight 4 application

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for some options to programmatically create a Word document from within a Silverlight 4 application. I found two approaches which seemed promising at first but don't look like they will work. OpenXML SDK The OpenXML SDK isn't available for Silverlight at this time. Word Automation via… >>> More
How do I add a new sheet to an Excel .xlsx file using the OpenXML SDK v2.0 with c#?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just posting the solution I worked out today. See my answer below. If you don't have the very helpful OpenXML SDK v2.0 Tool, you can find it at http://www.microsoft.com/downloads/details.aspx?FamilyID=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en If you know the purpose of the lines I… >>> More