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
1
vote
0 answers

Unable to insert cells into an Open XML document

Unable to insert cells into an Open XML document as the OpenXml Excel document. I think the issue is that the cell.Remove() isn't actually clearing cell. I'm unsure because the document says that it has been modified public static void…
1
vote
1 answer

Find image placed in Powerpoint 16 file's slide.xml file

So I have upzipped a Powerpoint 16 presentation and I am looking at the XML from a slide from the ppt/slides/ directory. I am searching for a reference to the image that is place on this slide, I THINK it is one of the
Chris Norman
  • 225
  • 2
  • 11
1
vote
3 answers

Unexpected null members when reading XLSX with Excel Data Reader (.Net)

I'm reading an XLSX (Microsoft Excel XML file) using the Excel Data Reader from http://exceldatareader.codeplex.com/ and am having a problem with missing data. Data which is in the source Excel spreadsheet is missing from the data set returned by…
Mark Micallef
  • 2,643
  • 7
  • 28
  • 36
1
vote
0 answers

Change data in waterfall chart in powerpoint using openXml

I have trouble with update data in waterfall chart. If i create any chart, for example Stacked Column then i can change data in chart, because i can take ChartParts BUT, when i try to get data in Waterfall Chart then I get null in…
seph0z
  • 11
  • 3
1
vote
1 answer

How can I make my bullets larger in Open XML?

I'm generating docx files using the Open XML SDK for .NET The bullets in my lists are super tiny but I can't figure out why. So here's what I've done: Generating a doc with a single bulleted item Created a doc from Word with a single bulleted…
user1447679
  • 3,076
  • 7
  • 32
  • 69
1
vote
2 answers

How to get coordinates of Run or other WordProcessing element via OpenXML?

I was wondering if it is possible to find the coordinates of a specific Run (text, no drawing or other elements that have offset parameter) on a page in a Word document using OpenXML SDK. I know that OpenXML is basically .. well XML, and simple runs…
Proko
  • 1,871
  • 1
  • 11
  • 23
1
vote
1 answer

How to parse numbers from excel sheet using OpenXML C#

My main goal is to parse emails from a spreadsheet. What I need is to detect if a cell is containing anything other than an Email (wrong format, boolean, number...) to add this cell to an array (assume invalids) What I did: using…
1
vote
1 answer

Returning XElement from class in separate file

I'm new to C#. I created a class in a separate file for processing text. Both the main and text processing class are in the TextProcessing namespace. This is not the whole class, just the beginning: using System; using System.Linq; using…
John Korchok
  • 4,723
  • 2
  • 11
  • 20
1
vote
1 answer

Get List of possible elements expected on a node

I'm getting below error on validation my XML: "The element has unexpected child element 'http://schemas.openxmlformats.org/drawingml/2006/main:p'. List of possible elements expected:…
rr14
  • 43
  • 5
1
vote
2 answers

Convert XML-Blob to relational table

I have a table in SQL Server 2017 including XML-blobs and I want to convert the data into relational tables. I'm trying to use OPENXML and the sp_xml_preparedocument procedure in SQL Server. The XML-blob is a little bit special (as usual) and I…
Torbjörn
  • 13
  • 2
1
vote
2 answers

Populate .docx second table using OpenXml SDK WordprocessingDocument

Im trying to populate 2 tables in .docx file from a controller. I have no problem populating the first table. But I can't seem to find a way to populate the second one. Here is my controller code. using (WordprocessingDocument sourceDoc =…
Waller
  • 433
  • 1
  • 6
  • 20
1
vote
1 answer

How to open docx file in ASP.NET MVC project using openxml for overwriting some text

I have searched a lot for the solution but can't find any. I have a .docx file inside my MVC project folder which I want to open to overwrite some text but I'm unable to do so. Inside my project folder, I have a Template folder and in this folder a…
Umar Gulzar
  • 17
  • 1
  • 10
1
vote
1 answer

My font size set using openXML for a Powerpoint paragraph is not being used

I'm trying to set a font size for a paragraph in a PowerPoint slide. In my code when I print out the font size it displays as 9 but when I open up my PowerPoint it is set to 12. Notes: I don't have admin rights on my pc so I can't install tools…
Mandelbrotter
  • 2,216
  • 2
  • 11
  • 28
1
vote
1 answer

Extract text from Word-Document using XSLT

I must extract paragraphs (means: Headlines with their content) from a Word-document using XSLT. I have analyzed the structure and can reach the necessary nodes in the .docx-file with XSLT. But now i do not know how to group the content of the…
anion
  • 1,516
  • 1
  • 21
  • 35
1
vote
2 answers

How to use XPath in JavaScript to select from namespaced OOXML?

I am building a tool to get data from a user specified XML file with an XPath expression. Simple XML files and an XML file with a single namespace works fine but I do not get the following XML file to work where the same prefix is overridden at…
Robert
  • 2,357
  • 4
  • 25
  • 46
1 2 3
99
100