openxml-sdk

OpenXML: Read text between two document fields using OpenXML SDK

Hi, I'm new to programming with the OpenXML SDK and I've tried excessively to locate and read text that is between two document fields, but never really succeeded. There are tons of samples and tutorials on the web about almost everything you can think of doing with the OpenXML SDK, from setting watermarks to doing merge mail, but not o...

Excel "Refresh All" with OpenXML

Hello, I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts are using this table. I am trying to find a way with OpenXML SDK v2 to do the same as the "Refresh All" button in Excel. So that I could automatically update my file as soon as a new xml file is ...

Using TDD with OpenXml-SDK

I have started using a TDD approach to develop a small app that reads data from Excel files. Using a repository pattern type approach I have come to a hurdle which baffles me. In order to read the Excel files, I am using the OpenXml-SDK. Now typically reading from an Excel file using the SDK requires several if not more steps to actuall...

Is there an expectable function to find out what type an image is in C# using OpenXML?

I hooked into the question located at "Replace image in word doc using OpenXML". I noticed that there are several ImagePartType types. Is there any easy "built in" way to determine which type a specific image should be other than going by it's extension? The ImagePartType enum is also used in PowerPoint as is alot of the WordProcessingML...

Is openXml2.0 chart generation compatible with office 2007?

I have not done any OpenXml, but the download page for OpenXml is clear that 1.0 is compatible with office 2007. The download page for OpenXml 2.0 does not specify any outlook versions at all. If we only have office 2007 or need to be office 2007 viewable/compatible and I'm looking at generating charts in outlook from c# code, can I pro...

Update Chart Data while creating Dynamic Word Documents

We have a requirement, in which we need to create dynamic word document and these word documents contains Table, Chart, text and images to be replace/update dynamically. So we decided to create a template and place text holders at dynamic places. To create new document by reading and updating Template we decided to go for OpenXML SDK 2.0...

How to output an excel spreadsheet with images from ASP.net

Suppose I'm writing an ASP.net web application. The original designer of the application was using "PopChart" to make some images appear in the web application. One of the pages had an "Export To Excel" button on it. When the button is clicked, the page content is output to Excel as in this tutorial: http://aspalliance.com/articleView...