Writing Large Excel Files with the Open XML SDK

In my last post, I showed you guys how to use the Open XML SDK to read and parse large Excel files. Today, I am going to show you how to write large Excel files with the Open XML SDK. Like in the case of reading, the Open XML SDK provides two approaches for writing…

6

Parsing and Reading Large Excel Files with the Open XML SDK

I want to thank you guys for leaving blog post requests. Today’s post will focus on one of your requests: parsing and reading large Excel files with the Open XML SDK. The Open XML SDK provides two approaches for parsing Open XML files: 1. using the SDK DOM, 2. using the SAX-like reading/writing capabilities. The…

13

Open XML SDK + Office Services: Better Together

I am probably starting to sound like a broken record, but I am really excited about the different types of solutions that are possible when combining the Open XML SDK with Office Services. In the past, I showed you how to leverage the Open XML SDK to accomplish three main scenarios: Push data into Open…

0

Open XML and Office Services

If you didn’t see the news up on the Word team blog announcing Word Automation Services, and you have any interest in server side conversion of .docx files into .pdf or .xps, you should definitely go take a look: http://blogs.msdn.com/microsoft_office_word/archive/2009/10/26/introducing-word-automation-services.aspx Capturing Business Processes in Office I see a lot of different types of solutions people…

2

Finding Open XML Errors with Open XML SDK Validation

In a previous post, I gave you an overview of the functionality added to the Open XML SDK 2.0 August 2009 CTP. Today, I want to deep dive into the schema and semantic level validation support within the SDK. Specifically, I am going to show you guys the Open XML SDK code needed to actually…

2

Removing Comments from Excel and PowerPoint Files

In a previous post, I showed you how to remove comments from a Word file. In today’s post, I am going to show you how to accomplish the same scenario, but this time with Excel and PowerPoint files. Excel and PowerPoint have a Document Inspector feature, which is able to remove multiple types of data/content,…

8

Importing a Table from WordprocessingML to SpreadsheetML

In a previous post, I showed you how to import charts from spreadsheets to a Wordprocessing document. Today, as promised in my last post, I am going to show you how to import a table from a Wordprocessing document into a spreadsheet. Solution To import a table from a Wordprocessing document to a spreadsheet we…

4

Importing Charts from Spreadsheets to Wordprocessing Documents

There have been several requests made by people asking how to import a chart from one document type to another document type. In a previous post, I showed you how to push data into a spreadsheet to create a chart. Today, I am going to show you how to import a chart from a spreadsheet…

6

How to Copy a Worksheet within a Workbook

As promised in my previous post about reusable methods for manipulating WordprocessingML, I mentioned I would write a post on how to copy a worksheet within a workbook. Note that this blog post talks about copying a worksheet within the same package. Perhaps sometime in the future I will write a post on how to…

5

Importing your XML into a spreadsheet

I’m going to try to get back on top of all the e-mails folks have been sending me. If you’ve e-mailed me over the past 6 months the odds are that I didn’t reply yet, and I’m sorry about that. I’ll start reading through the e-mails again and rather than just replying directly I’ll actually…

4