Complex editing of XLSX files

  Editing Excel OpenXML documents using the OpenXML 2.0 SDK offers better performace and improved supportability compared to normal Office automation (e.g. VBA). There are also great examples on the Internet to get started: Office Open XML Formats: Inserting Values into Excel 2007 Cells. What I haven’t found until now is some clarifications as to…

0

OpenDoc tool unveiled

After the previous blog posts with the OpenDoc tool, I’ve learned that, while this tool can be very helpful, it also raises a lot of questions mainly because it lacks proper documentation. As such, I’ve decided to post the source code giving everybody who is interested the liberty of modifying it to suit their needs….

0

OpenDoc tool reloaded

In a previous post, I described a tool for editing OpenXML documents from a managed context. I’ve added three more features for some common tasks:  1. Remove a part Syntax:  OpenDoc.exe -r <Input file> <Part> Sample usage scenarios: removing the calculation chain, removing unwanted resources, removing slides, worksheets.  2. Remove all attributes  Syntax: OpenDoc.exe -t…

0

Working with OpenXML documents

The default format for saving Excel, Word and PowerPoint documents has luckily changed since Office 2007 to the Open XML formats. There is good documentation available for these formats on: MSDN: Introduction to the Office 2007 file formats: http://msdn.microsoft.com/en-us/library/aa338205.aspx   MSDN – sample code: Editing Excel cell values from .NET code: http://msdn.microsoft.com/en-us/library/bb332058.aspx   ECMA: ECMA…

0