openxml

How can a Word document be created in C#?

I have a project where I would like to generate a report export in MS Word format. The report will include images/graphs, tables, and text. What is the best way to do this? Third party tools? What are your experiences? ...

How do I convert a .docx to html using asp.net?

Word 2007 saves its documents in .docx format which is really a zip file with a bunch of stuff in it including an xml file with the document. I want to be able to take a .docx file and drop it into a folder in my asp.net web app and have the code open the .docx file and render the (xml part of the) document as a web page. I've been sea...

How can I read a Word 2007 .docx file?

I'd like to search a Word 2007 file (.docx) for a text string, e.g., "some special phrase" that could/would be found from a search within Word. Is there a way from Python to see the text? I have no interest in formatting - I just want to classify documents as having or not having "some special phrase". Thanks! Gerry ...

Insert HTML into OpenXML Word Document (.Net)

Using OpenXML SDK, I want to insert basic HTML snippets into a Word document. How would you do this: Manipulating XML directly ? Using an XSLT ? using AltChunk ? Moreover, C# or VB examples are more than welcome :) ...

How do I get the stream of header/footer in a WordprocessingDocument

Hi, I need to know how I get the stream of the headers and footers of a WordprocessingDocument. I get the MainDocument by the MainDocumentPart of a WordprocessingDocument. Do you know how I get the header? I tried to use the method GetPartsOfType but it returned null. Greets Sebastian ...

Insert cell comments in excel programmaticaly.

What's the better way to insert cell comments in excel 2007 files programmaticaly using c# and .net 3.5? ...

How can I programatically use C# to append multiple DOCX files together?

I need to use C# programatically to append several preexisting DOCX files into a single, long DOCX file - including special markups like bullets and images. Header and footer information will be stripped out, so those won't be around to cause any problems. I can find plenty of information about manipulating an individual DOCX file with...

Editing Excel Spreadsheets easily with the SDK

Hi, is there anyone who makes use of the Microsoft Open XML SDK 2.0 for editing Excel Spreadsheet, I edited Open XML documents already by only using XML methods, but as there exists the SDK, does someone know if there are really easy methods for some essential functions? For Example the inserting of content in a cell. Also the Open XML ...

What is the best way to populate a Word 2007 template in C#?

Hi, I have a need to populate a Word 2007 document from code, including repeating table sections - currently I use an XML transform on the document.xml portion of the docx, but this is extremely time consuming to setup (each time you edit the template document, you have to recreate the transform.xsl file, which can take up to a day to d...

Printing an OOXML document without MS Word installed

Is there any way to print an OOXML document (.docx file) without having MS Word installed? It works nicely via the MS Word interface but I need to find a way to use it on servers where MS Word is not installed. I've been digging through the API and haven't found anything obvious so I'm inclined to believe there isn't a way. Is this the...

Word 2007, Open XML - embedding an image

Do you know what basic information MUST include a paragraph (<w:p/>) in document.xml inside a *.docx document, that specifies an image? I do know there must be: <a:blip r:embed="rId4" /> specifing the relationship id, but what else? It's very hard to find it in Google and experimenting with cutting out tags from a ready document or...

Inserting a Comment in Docx file *around* a text inside a run

How do you search for a specific text inside a text run (in Docx using the OpenXML SDK 2.0) and once you find it how do you insert a comment surrounding the 'search text'. The 'search text' can be a sub string of an existing run. All example in the samples insert comments around the first paragraph or something simple like that... not wh...

How do I convert Excel OpenXML shared strings to inline strings?

I have a large spreadsheet in Excel 2007 OpenXML format that I want to manipulate in xml programmatically. Excel saves it using the shared strings method which, while more efficient, complicates the process. Does anyone know if there is an option buried in Excel to save using inline strings, or maybe a utility already build to place all ...

Insert string values in to Excel 2007 using Open XML SDK 1.0

Any example related to my topic in open XML SDK 1.0 not open XML SDK 2.0 Thanks in advance ...

Recalculating Excel 2007 in OpenXMLSDK 1.0

Workbook that i have used to set the Values at run time have some formula, Formula get invoked based on my inputs. After the values has been set to the Excel, formula in workbook not working. How can i recalculate using Open XML method Thanks in advance -Gunasekaran Sambandhan ...

Dynamically creating Office Open XML documents: update all fields on open

I am programmatically generating an Office Open XML document (Word 2007 format), and would like to have all the fields updated when the document I generate is first opened in Word. When I researched this a while ago, the only way to do this was to run VB Script when the document opens. But VB Script doesn't run by default, and for this ...

Adding Chart to WordprocessingML

I would like to generate an Open XML document containing a Chart using the Open Xml SDK 2. I found an SpreadsheetML example, but I can't work out how to add the chart in a .docx... Is there a good source for documentation/examples for the Open Xml SDK 2? ...

How to programmatically insert comments into a Microsoft Word document?

Looking for a way to programmatically insert comments (using the comments feature in Word) into a specific location in a MS Word document. I would prefer an approach that is usable across recent versions of MS Word standard formats and implementable in a non-Windows environment (ideally using Python and/or Common Lisp). I have been looki...

Creating cell comments in an Excel Spreadsheet with OpenXML SDK

I'm trying to add comments to cells in an Excel 2007 spreadsheet. I'm using the OpenXml SDK 2.0 to do so. My use case is this: I've created a template Excel file that I copy and use that as my starting point, rather than create an OpenXML document from scratch. My template file has a comment in cell A1 so that Excel has already crea...

how to create and download excel document using asp.net

How to create and download excel document using asp.net ? The purpose is to use xml, linq or whatever to send an excel document to a customer via a browser. Edit : Use case The customer load a gridview ( made with ajax framework ) in a browser, the gridview is directly linked to an sql database. I put a button 'export to excel' to let...