openxml

Where can I find good documentation on OpenXML

I'm looking to create powerpoint file in OpenXML. I'm looking to use the following features Bind bits of the page to an xml file. For example, one tag would be bound to the name field of an xml file. The plan is to simple drop the xml file in the right folder, zip up the template, and rename the file the proper extension and have it j...

Query xml data from SQL2000 (xml saved directly in a cell, multiple rows)

Hi I get problem retrieve XML data from SQL2000 server. The table structure is as following: ID Name XML 1 Name1 <Root><DATA1>1-Data1</DATA2><DATA1>1-Data2</DATA2></Root> 2 Name2 <Root><DATA1>2-Data1</DATA2><DATA1>2-Data2</DATA2></Root> 3 Name3 <Root><DATA1>3-Data1</DATA2><DATA1>3-Data2</DATA2></Root> How can I get th...

CustomXML In Powerpoint

I want to create a PowerPoint template. I want the template to have references to items like NAME and the like based on an external source. I know with WordprocessingML I can just make a reference to an XML file and supply an x-path, but I also hear this is not supported in PowerPoint. So how do I do this with PresentationML? Are repeat...

How I can export a datatable to excel 2007 and pdf from asp.net?

I have to make reports with graphics in Excel and PDF from data in a database in an asp.net app. I don't want to use com objects so I have been using Open Xml Sdk to build the excel file from a template file and redirect the response to the new file generated but I don't know how to make the PDF file... I accept any comments about how I ...

OpenXml SDK - Image Reuse

Hi, I am creating a word document based on a template. The template contains a image in the header section which I would like to re-use elsewhere in the document. The image is stored in the package -> word/media/myImage.jpeg so I need to somehow add a relationship to my each section that I wish to display the image again. I have attem...

Reading data from an Excel document stored in Sharepoint?

How can I 'read' an excel 2003 document stored as a sharepoint spfile? I can retrieve the document from the library with no problems using the SPFile.OpenBinary() and then putting that into a MemoryStream. The original idea was to use OpenXML to interrogate the document (which will take this object type as a constructor), but the Excel ...

Password protect Open XML Wordprocessing Document

I need to add basic password protection to an Open XML Wordprocessing document. I can either use the COM interface, which is very slow when I have a large number of documents to process; or I can put the data directly in the docx file under <w:settings> <w:documentProtection> which is very fast. However, looking at the requirements to en...

Example using OpenXML with Parent Child Relationship and Associated Lookup Tables

I have an XML document that is loaded into a column of a table of the XML data type. Is there any good examples showing how to insert using a store procedure and OpenXML into a parent tables with primary key and also into a child table with it's associated foreign key? Both the Parent and Child have relationships to lookup tables. The ...

Word OpenXML . Traversing OpenXmlElements between bookmarks.

I need to traverse nodes between a bookmark start and a bookmark end tag. The problem appears to break down into a tree traversal but I am having trouble pinning down the correct algorithm. The bookmark start and end elements are non-composite nodes (no children) and may appear at an arbitrary depth in the tree. Bookmark start are als...

Horizontal Text alignment in Word using OpenXml Sdk 2.0

Hello Everyone, I need another help... My export function exports my report as a table in word. I need to apply horizontal alignment property for each cell. The Code I wrote for exporting is given below. Tbl is a textblock which I am using in my report. I wrote Alignment code here. But doesn't works.. Please help me to accomplish this t...

Change Page size of Wor Document using Open Xml SDK 2.0

Hello everyone, My application needs export custom report to Word document using Open xml Sdk 2.0 My Export function works fine except I need to increase Page size for showing it properly. (else word wrap will be an issue and Report won't look nice). Can any one suggest me how can I adjust Page size according to width of my report. I...

image in header/footer excel using openXML (c#)

I searched all over could not find a solution. ...

How to identify and validate an OOXML file?

I need to be able to identify that a given file is an OOXML file based on the contents of the file, and not on the file's extension. OOXML files are really a collection of XML and text files in a zip container, which means that I cannot use the file's magic number as it will just indicate that it is a zip file. So what I'm really askin...

In PowerPoint 2007, how can I position a Callout's Tail programatically?

I'm looking at the DrawingML of a PowerPoint 2007 file and this is what it has for the Callout object's coordinates and geometry: <p:spPr> <a:xfrm> <a:off x="2819400" y="5181600"/> // X,Y Position of Callout Box <a:ext cx="609600" cy="457200"/> // Width,Height of Callout Box </a:xfrm> <a:prstGeom prst="wedgeR...

SQL OpenXML returns nothing when the XML doesn't fill every level

I'm having an issue with OPENXML in SQL Server 2005 where I'll get no results back if the XML doesn't have every tier available. An example would clear up my question: So we have XML like this: <Connection Name="DEFAULT" />' <Branch Name="A_Branch"> <Leaf Name="A_Leaf.OP" > <Property Name="A_Property" /> </Leaf> ...

How to add content control in a word 2007 document using open xml

Hi I want to create a word 2007 document without using object model. So I would prefer to create it using open xml format. So far I have been able to create the document. Now I want to add a content control in it and map it to xml. Can anybody guide me regarding the same??? ...

Open XML SDK v2.0 Performance issue when deleting a first row in 20,000+ rows Excel file

Do anyone come across a performance issue when deleting a first row in a 20,000+ rows Excel file using OpenXML SDK v2.0? I am using the delete row coding suggested in the Open XML SDK document. It takes me several minutes just to delete the first row using Open XML SDK, but it only takes just a second in Excel applicaton. I eventually ...

Why OPENXML only returns one element

Can somebody explain me why this T-SQL code only returns one row with the value "1"? I was expecting to get two rows ("1" and "2"). Am I missing something here? DECLARE @XMLDoc2 XML SELECT @XMLDoc2 = '<ids><id>1</id><id>2</id></ids>' DECLARE @handle2 INT EXEC sp_xml_preparedocument @handle2 OUTPUT, @XMLDoc2 SELECT * FROM OPENXML (@ha...

Access the active Excel workbook using OpenXML and C#

I'm trying to manipulate an Excel spreadsheet in C# using OpenXML. Specifically, I would like to access the currently active workbook that is open. I've only been able to find examples that open up an Excel document given a filename, such as: using (SpreadsheetDocument myWorkbook = SpreadsheetDocument.Open(filename, true)) (Note...

(OpenXML) Add data pages to xml package without framework

Hi all, lately I've been into combining multiple OpenXML speadsheets via PHPExcel which showed me that this framework has certain issues which makes it pretty much unusable for what I want to do (my related SO question). To make it short: it's hard to guarantee that all formatting features of Excel 2007 will persist a file merge perfor...