How do I read data from a spreadsheet using the OpenXML Format SDK?

Posted by ProfK on Stack Overflow See other posts from Stack Overflow or by ProfK
Published on 2010-04-12T18:20:09Z Indexed on 2010/04/12 18:23 UTC
Read the original article Hit count: 545

Filed under:

openxml

|

ms-office

|

office-2007

I need to read data from a single WorkSheet in an Excel 2007 WorkBook using the OpenXML Format SDK v2.0. I have spent some not insignificant time searching for basic guidelines to doing this, but I have only found help on creating spreadsheets.

How do I iterate rows in a WorkSheet and then iterate the cells in each row, using this SDK?

© 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 ms-office

How to change ms office 2010 beta key

as seen on Super User - Search for 'Super User'
I have installed office 2010, using a key that I found on forums on the internet. It said it was used to many times already. But when I try to use the mak key that is on my account, it says that it is invalid. How do I change the key, if a key is still installed and is available for 30 days. >>> More
Creating the Previews of MS Office Files like word excel and PPT in cocoa

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi How can I create the preview image for MS Office files like word, excel , power point in cocoa. Can anyone suggest me on this like how to handle those file?. I tried using the Bitmap representation of the .doc files.It dint work.. Which API i can use?.. thank you.. >>> More
=rand(100,60) - MSOffice Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Oho ! Have you tried this one ?? Very simple office utility question. The question is something like this. Open Microsoft word ( 2003 or 2007 ) whatever you use. ( Let me clarify that - I am not here for any kind of advertisement of Micro soft - I want to solution to my Query ) After opening… >>> More
User (MS-Office) generated content - how?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I allow users to share Microsoft Office generated content on an ASP.Net site? For example usage, imagine a site similar to StackOverflow. George, writing a question, uses Word, Excel or OneNote to create content, and then inserts the content into the question area (probably copying it into… >>> More
How to avoid the configuring ms office dialog box

as seen on Super User - Search for 'Super User'
I always see the configuring ms office with a an endless progress bar, 2 or more weeks after I installed ms office(2000, 2003, 2010 beta). I'm not exactly sure what it is called but it is trying to configure ms office.Or maybe repairing the installation. And it sucks because when I need to access… >>> More