Stack Overflow
Stack Overflow

Questions tagged [openxml]

Questions regarding reading and writing of Microsoft Office Open XML files either through direct manipulation of the XML files contained in a zip package or through the Microsoft Office Open XML SDK.

Office Open XML File Formats Official Standard

http://www.ecma-international.org/publications/standards/Ecma-376.htm

Microsoft Office Open XML SDK 2.0

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en

3743 questions
6
votes
3 answers

What are some techniques for generating PowerPoint presentations without using Office Automation?

While it is possible to generate PowerPoint presentations automatically using Office Automation, this is not recommended for use on a server. How can you go about generating a PowerPoint presentation without using Office Automation?
rjzii
  • 14,236
  • 12
  • 79
  • 119
6
votes
1 answer

Parsing OpenXML with multiple elements of the same name

I have a data structure as such: 1 first string second string 2 third string …
MSpeed
  • 8,153
  • 7
  • 49
  • 61
6
votes
1 answer

Using a template with OpenXML and SAX

I'm creating a large XLSX file from a datatable, using the SAX method proposed in Parsing and Reading Large Excel Files with the Open XML SDK. I'm using an XLSX file as a template. The method described in that post works fine to substitute a new…
Jonathan Sayce
  • 9,359
  • 5
  • 37
  • 51
6
votes
3 answers

How do you convert Excel to CSV using OpenXML SDK?

I have a requirement to convert Excel (2010) files to csv. Currently I'm using Excel Interop to open and SaveAs csv, which works well. However the Interop has some issues in the environemt where we use it, so I'm looking for another solution. I…
TheSean
  • 4,516
  • 7
  • 40
  • 50
6
votes
1 answer

How can I retrieve some image data and format using MS Open XML SDK?

This is a follow-up question to How can I retrieve images from a .pptx file using MS Open XML SDK? How can I retrieve: The image data from a DocumentFormat.OpenXml.Presentation.Picture object? The image name and/or type? in, say, the…
user610650
6
votes
2 answers

How can I retrieve images from a .pptx file using MS Open XML SDK?

I started experimenting with Open XML SDK 2.0 for Microsoft Office. I'm currently able to do certain things such as retrieve all texts in each slide, and get the size of the presentation. For example, I do the latter this way: using (var doc =…
user610650
6
votes
1 answer

where can i find office open xml complete reference?

i am planning to develop a server side generation of MS office files with the help of office open XML method..... I found only less examples/reference in microsoftsite.... does any one know where can i find the complete…
Jeba Prince
  • 1,669
  • 4
  • 22
  • 41
6
votes
3 answers

Using Open XML how do you insert a formula into an Excel 2010 worksheet?

I'm using Visual Studio 2010 (VB.Net) and Open XML SDK 2.0. How do you insert a formula into an Excel 2010 worksheet? When I do this I also wish to set the CellValue property of the cell to a DBNull or EmptyString to force Excel to recalculate the…
vbasic321
  • 61
  • 1
  • 2
6
votes
2 answers

Excel file and program structure

I need to know for a school project how Excel work. Precisely I need to know what kind of structure is behind an Excel file and how the Excel program work with this file. I know Excel is a Microsoft propriety and it' s not Open Source so I know I…
user482966
6
votes
1 answer

new lines, default font and size (open xml sdk)

What I need is to insert a new line at the end of a text. I try with run.Append(**new Break()**); but this simulates to pressing (Shift+Enter) keys, and if I want a justified text the latest line autofits with lot of spaces between word and…
Displaying
  • 117
  • 3
  • 8
6
votes
1 answer

Programmatically count number of characters/words/paragraphs with a specific style in a DOCX document

I need to programmatically count the characters and/or words and/or paragraphs which have been applied a specific known style in a DOCX document. I need to know 1) if this is possible and to 2) any hints as to where I can start to get going to solve…
andrerav
  • 404
  • 5
  • 14
6
votes
4 answers

How to get chart info from an Excel spreadsheet using Apache POI?

Is it possible to extract chart information from an Office 2007 (xlsx / OpenXML) spreadsheet using Apache POI? I've managed to read in the spreadsheet and even get the part that refers to the chart but not sure how I can retrieve any info from this…
Aodh
  • 662
  • 1
  • 7
  • 24
6
votes
2 answers

DOCX w:t (text) elements crossing multiple w:r (run) elements?

We have written a piece of software that processes XML out of a Word document's internal XML files, and replaces certain codes with replacement values. Sometimes we find that such codes are broken up between multiple runs. Here is an example of the…
user6499401
6
votes
1 answer

Resources for learning about Word XML format?

What resources would you recommend to learn about the Microsoft's Open Office format (the XML format introduced with Office 2007, not to be confused with OpenOffice.org), specifically for .docx Word files? (Ideally, ones with lots of samples and…
Tony the Pony
  • 40,327
  • 71
  • 187
  • 281
6
votes
2 answers

C# OpenXML Embed Spreadsheet Chart in Word Document

I have generated a spreadsheet with data and a chart based on the data using C# OpenXML. I am now wanting to now embed this chart into a word document, so that when these reports are sent out, the charts can be edited if need be (Not an external…
Duncan Palmer
  • 2,865
  • 11
  • 63
  • 91
1 2 3
…
99 100