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

ClosedXML - Get conditional formatting Style Applied

I am working on manipulation Excel, in order to convert it to HTML, and I am using ClosedXML/EP plus. The issue here: I can't identify for a cell if conditional formatting has been applied or not. When I am doing…
Jijaxxx
  • 13
  • 4
1
vote
0 answers

Saving Excel file with OpenXML change Created date

I'm using OpenXML in a C# project to generate a file, read and write data in the generated Excel file. Everything is working, except that I need to compare the "Modified" and "Created" date in the file properties to be able to know if the file have…
Kaizer80
  • 23
  • 3
1
vote
2 answers

Need to parse the XML using OPENXML with Attributes and Elements

I am facing an issue while parsing the XML elements and attributes in SQL Server. …
Gopakumar N.Kurup
  • 916
  • 4
  • 18
1
vote
0 answers

OpenXML adding images to a Word document randomly corrupts the file

After adding one or more images to a Word document, I try to open it using Word Interop. At random, the document is corrupted and will throw a COMException "the file may be corrupted". While trying to determine a cause for this corruption, I used…
LambdaSigma
  • 11
  • 4
1
vote
1 answer

Numbers not rounded when reading excel file programmatically

I have a column in excel where numbers are rounded to 2 decimal places using ROUNDUP. In excel itself the numbers look as they should after rounding, i. e. "2,22". But when I read the numbers in c# code using openxml, instead of 2,22 I get…
john doe
  • 118
  • 6
1
vote
1 answer

Edit CustomXML with OpenXML C#

This is my first OpenXML project. I am trying to edit the CustomXML file of a docx file. I am trying to change this: NAME DOB …
JeremyH
  • 13
  • 3
1
vote
2 answers

Reading XML attribute values using OPENXML

For the following .nodes() approach, I need an equivalent OPENXML approach. The Attributes will be different and can not be hard-coded. DECLARE @Xml XML='
RandomUser
  • 1,843
  • 8
  • 33
  • 65
1
vote
1 answer

Add Custom Text on OpenXML BarChart

I want to add custom text on BarChart like this: How to do this using OpenXML which feature? Please help
Syed Md. Kamruzzaman
  • 979
  • 1
  • 12
  • 33
1
vote
2 answers

does openXML(C#) support generating number fields that are formatted (like 1,000,000)

i have existing code that generates a spreadsheet from excel using OpenXML. It works fine but i always have to go into the spreadsheet afterwards and add formatting. Is there anyway in my C# code I can specify that i want a column formatted with a…
leora
  • 188,729
  • 360
  • 878
  • 1,366
1
vote
3 answers

OPENXML, Xsi:nil and Decimals

I have some XML containing xsi:nil="true" for certain string and numeric elements. Here's an example: declare @data xml set @data = '
d4nt
  • 15,475
  • 9
  • 42
  • 51
1
vote
0 answers

Unable to create / save a word document with OpenXml with angular / typescript / javascript

I'm unable to create a document with Xml (OpenXml) in my angular - typescript application - file gets created but opened shows "found unreadable content in document..." error. When I open the file in notepad, all I see is the Xml. let blob = new…
Miey Stackoverflow
  • 55
  • 3
1
vote
1 answer

SQL Server parse XML to table - multiple node with the same name and first node should be table columns

I have a source xml like below and I want to convert to SQL table. First "tr" node should be columns for the table and remaining are rows. …
MKmuthu
  • 17
  • 4
1
vote
0 answers

How to Extract Font color from a PPT file in C#?

I am trying to extract color of the font from a PPTx file , I am a beginner using Open XML SDK. My aim is to extract the font color, replace the color and save the file. Here is what I have tried so far. using Drawing =…
Priyanka Adiga
  • 11
  • 1
1
vote
1 answer

Automate the Insertion of Custom Ribbon in Office Excel using OpenXML library VS2017 without VBA

Our application lets users download excel to enter configuration data which is then saved and used to process and estimate results. As of now we have task pane which we auto insert in the excel templates which are download. We wish to add a custom…
Nikhil Kolte
  • 75
  • 9
1
vote
1 answer

Why is openxml footer not posting to document

I have followed a few examples, but I simply can not get a footer to print to a word processing document using openxml. I am betting I am missing something trivial here, but I just can't see/find it. MainDocumentPart mainPart =…
Jim
  • 13
  • 3
1 2 3
…
99 100
Description Value