openxml

Writing MS Word 2007 XML

How would I write Word 2007 XML (WordProcessingML) on my own? I have a requirement to do so, where I need to write a Word 2007 XML format for a Word template. The important thing is I should convert a Word template doc to XML (by zipping it, etc), where I need to write Word 2007 XML with those respective tags. How can I do this? ...

Finding a Content Control in Word based on Tagname

Hi. I'm currenty trying some new things with OpenXml but I recently came across some trouble. As the title says I'm trying to insert data dynamically into a table using Xml. To indentify the table in my Worddoc I've put a Rich Text Content Control arround it. Everything worked & looked fine until I tried to search my document for the t...

Binding CustomXml to Headerpart

Hi I am at my whits-end with this problem. I can successful bind xml to the main document part, however I cannot seem to be able to get content controls in the header to bind to the xml. AddCustomXmlPart doesn't seem to exist for Headerpart and if I try to add a CustomXmlPart via hdrpart.AddPart(xmlPart); I get an Invalid operation ...

Convert Open XML Excel files to HTML

I'm developing printing solution for MS Office 2007. Office automation is not right for me, because it requires Office to be installed. Open XML Document Viewer is solution for converting Word files (.docx) to HTML format by XSLT transform, but it works only for .docx. Can the same technology be used for Excel spreadsheets files? ...

HexBinaryValue.FromString OPENXML

Hi What paratemeter I need to pass to this function. It is taking 00c0c0c0 format. I am not sure how to convert #00ccff into that format? Any help will be appreciated ...

Finding contained bordered regions from Excel imports.

I am importing massive amounts of data from Excel that have various table layouts. I have good enough table detection routines and merge cell handling, but I am running into a problem when it comes to dealing with borders. Namely performance. The bordered regions in some of these files have meaning. Data Setup: I am importing directly f...

Open XML SDK to edit Active document

Hello, Is it possible to use the Open XML sdk to manipulate parts of document which is currently open in the ofice app (word/ppt). I know the easiest thing is to use VSTO, but its slow and would involve clipboard use to insert elements, the OXML sdk is direct and simpler. If somebody could post some code sample that would be great. Th...

Merge documents

I'm trying to merge two docx-documents into one docx-document using OpenXML SDK 2.0. The documents should be merged without loosing their styling and custom headers and footers. I hope I can achieve this using AltChunk and a section break. But I can't get it working. Is it possible what I'm trying to do? Can someone give me a hint how t...

Remove MailMerge data source via OpenXML

I have some code that uses Open XML 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 off an Excel spreadsheet data source ...

Insert Image on Excel using Open XML

Hello All I am using this toolkit to write Excel.Every thing is fine with this, but i am not getting how can i inset image and also put style on some rows on my excel http://excelpackage.codeplex.com/wikipage?title=Creating%20an%20Excel%20spreadsheet%20from%20scratch&referringTitle=Home i am using c# ...

Save PowerPoint 2007 as PowerPoint 2003 using Open Office SDK 2.0

Is there anyway to use the Open Office SDK 2.0 to save a PowerPoint presention that you created using OOXML to a PowerPoint 2003 presentation? I know if you open a 2007 file and click Save As you have the option to save it as a PowerPoint 97 to 2003 document and I didn't know if I could do this grammatically using this SDK. The reaso...

OpenXML SDK How to position an image in MS Word ?

I did insert an image using the OpenXML SDK API .. however i can not figure out how to position the image to appear on any part of the page (probably using anything similar to (x,y) co-ordinates)? ...

Error while trying to insert image in to wordML

Hi, Help needed. I am getting this error {"The xml has invalid content and cannot be constructed as an element.\r\nParameter name: outerXml"} while passing constructed xml in to DocumentFormat.OpenXml.Office.Drawing.Drawing() constructor like this DocumentFormat.OpenXml.Office.Drawing.Drawing d = new DocumentFormat.OpenXml.Office...

openxml option to be fully in text format ?

I have tried to generate "Hello World" with openxml sdk. To my surprise when trying to open the xml document it was not purely text format but it contains some ugly binary stuff. Is there any option to have text format when the content is only text ? I can't see any rationale for the binary part if it is supposedly "open". Update: my ...

Use SSIS to populate Excel workbook generated using OOXML

We are trying to generate MS Excel workbook using OOXML and populate data using SSIS. We are able to generate Workbook and sheets, also able to create columns and insert data in the Header cell. We can also populate data using SSIS. But the Sheet (DocumentFormat.OpenXml.Spreadsheet.Sheet) and all cells (DocumentFormat.OpenXml.Spreadshee...

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

I need to read data from a single worksheet in an Excel 2007 workbook using the Open XML SDK 2.0. I have spent a lot of 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? ...

How to split table to new PowerPoint slide when content flows off current slide using Open XML SDK 2.0

I have a bunch of data that I need to export from a website to a PowerPoint presentation and have been using Open XML SDK 2.0 to perform this task. I have a PowerPoint presentation that I am putting through Open XML SDK 2.0 Productivity Tool to generate the template code that I can use to recreate the export. On one of those slides I...

Write a Word 2007 document in OpenXML

My problem is in two parts: How can I, in Word 2007, put an id on a section so I can easy access this section from my code? For example, if I have Name : Here I want to set the name from my C# code. How can I, from my C# code, fill this section id ? ...

Is there an Open XML parser for C++?

Hello, I want to scan a PowerPoint 2007 file, but I'm trying to do it with C++. Is there any Open XML parser for C++? ...

Is sql server's openXML bulk insert faster than bcp or is it more convient to use only?

Is sql server's openXML bulk insert faster than bcp or is it more convient to use only? ...