Browse by Tags

The purpose of PresentationBuilder is to build a new Presentation document using selected slides from one or more existing Presentation documents. The challenge is to include all references to other parts, or parts of parts, as appropriate for the slides that are being copied. In this series of screen...

The purpose of PresentationBuilder is to build a new Presentation document using selected slides from one or more existing Presentation documents. The challenge is to include all references to other parts, or parts of parts, as appropriate for the slides that are being copied. In this series of screen...

The purpose of PresentationBuilder is to build a new Presentation document using selected slides from one or more existing Presentation documents. The challenge is to include all references to other parts, or parts of parts, as appropriate for the slides that are being copied. In this series of screen...

This is a short (5 minute) introduction to the new PresentationBuilder. The purpose of PresentationBuilder is to build a new Presentation document using selected slides from one or more existing Presentation documents. The challenge is to include all references to other parts, or parts of parts, as appropriate...

I usually like to use the Linq objects (XDpcument, XElement) when searching and modifying OpenXML documents. However, I know a lot of people prefer to use the specific objects available in version 2.0 of the SDK. For simple operations, this approach can work pretty well. I decided to try this approach...

For the last couple of months, I have been exploring the contents of formulas in SpreadsheetML. Formulas can include functions, cell ranges, external references, references to other sheets in the same workbook, and a variety of operators. In fact, formulas even support union and intersection operators...

I have just updated the PowerTools Core (version 2.2.6) to fix a couple of problems with the spreadsheet and pivot examples. I have fixed twoproblems. There were some problems with the GetCellValue method. The other problem was with the pivot table configuration, which did not work when two or more data...

This will probably be the final installment of this series. In this example, I complete the pivot table creation process by configuring the fields that will appear in the rows, columns, filters and data values. This example builds upon the earlier examples. The screen-cast is divided into two sections;...

This example looks at a couple of OpenXML spreadsheet topics. I have been working with the cell styles a lot lately and this is a first example showing how to add some of the named styles to a spreadsheet cell. I plan to include even more style options in my next example and blog post. Also, after I...

A few weeks ago I made an article evolving around the intricate details of how to handle dates in SpreadsheetML . This is a follow-up on to that article. Introduction SpreadsheetML (and OpenXml as such) is divided in two chunks - "the Transitional chunk" and "the Strict chunk". In...

One of the most overlooked parts of dealing with OpenXML and SpreadsheetML in particular is handling dates in a spreadsheet. You can find tons of tutorials and articles evolving around charts, pivot-tabled and formulas, but they tend not to include date handling in their examples. This article aims to...

This is my first post about creating pivot tables using the Open XML SDK. I am assuming you already know how to create a pivot table using Excel. The first approach I am going to show for creating pivot tables is simplified by using a spreadsheet with the pivot table already set up. The source for the...

A number of people have reported a problem with the OpenXML SDK throwing an exception, "Invalid URI:The hostname could not be parsed." This exception is actually coming from the Uri class. Since the OpenXML SDK is using System.IO.Packaging to get relationships for the document and System.IO...

Eric and I have created a version of PowerTools that includes only the core code, without the cmdlet code. The C# project also includes several examples of how to use the core code from a C# program. You can get this project from the PowerTools CodePlex page ( http://powertools.codeplex.com/releases...

Eric and I made a number of significant design and organizational changes to PowerTools. This video briefly goes through the technical details of those changes. It will be most useful for people familiar with C# development. It also helps if you know something about cmdlet development in PowerShell,...

Three years ago Peter O'Kelly wrote a paper titled, "What?s Up, .DOC? Open XML Formats, OpenDocument Format, and the Revolutionary Implications of XML in Productivity Applications." This paper was an industry debate about the relative merits of Open XML Formats and OpenDocument Format and...

Combining PowerShell and Open XML, PowerTools for Open XML is a powerful way to do server-side document processing. By using PowerTools in you own PS scripts you can manage and generate Word and Excel documents ! PowerTools is available for a while, thanks to Eric , Bob McClellan and people at Staff...