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
2 answers

C# OpenXML make Excel file downloadable

[EnableCors(origins: "*", headers: "*", methods: "*")] public class ExcelReportsController : Controller { private ExcelContext db = new ExcelContext(); [Route("/ExportToExcel")] [HttpGet] public void ExportPersonsToExcel() { …
user12067722
1
vote
0 answers

Is there a way using .NET and Open-xml to read the output value of a formula in a cell of an excel file?

Summary of the problem How to read the output value of a formula in a cell, using .NET and Openxml. Goal Using .NET open-xml, to read a value of a cell that contains a formula and that is not calculated at compile-time, but at run time. For example…
YazanGhafir
  • 464
  • 3
  • 8
1
vote
0 answers

Can not convert HTML with images using OpenXML to PDF using iText7

I am use Open XML SDK 2.12.1 version to convert docx word to html file protected void btnDisplay_Click(object sender, EventArgs e) { byte[] byteArray = (byte[])(Session["ByteArray"]); if (byteArray != null) { try { …
1
vote
1 answer

How do I insertContentControl() at the very end of a document

In javascript, I wish to insert a call to insertContentControl() at the very end of the document, after any text in the main body. I thought I could do it with: context.document.getSelection(); var cc =…
1
vote
1 answer

use of w:tag in Office openxml/javascript add-in

I have the following: Word.run(function (context) { docSelection = context.document.getSelection(); var text = '' +…
1
vote
0 answers

Add Relationship in existing Excel file with OpenXML

I have a simple Excel file with two worksheet. Each of them has an Excel table defined in it. The final result would be to add a relationship between tables using OpenXML so in the modified Excel appears like this: I tried with following…
1
vote
1 answer

OpenXML MainDocumentPart.Document.Save() doesn't seem to save in .Net 5 Core

I've been porting an application from .net framework to .net 5. I'm trying to generate a word document by reading a template file, using Open-XML-PowerTools to replace some text, and saving the new version. I can't get the "Save()" to do…
RichC
  • 49
  • 3
1
vote
1 answer

System Resource Exceeded Exception thrown by OleDB when reading Open Office XML generated spreadsheets

I am currently working on an Excel import/export utility that is leveraging existing OleDB code for the import process, with the spreadsheets being generated using Open Office XML. So far, the spreadsheets are generated properly formatted and are…
1
vote
2 answers

Why can't get cell value of excel file by OpenXML?

I must read excel file as sample: My code reading file: SPWeb web = SPContext.Current.Web; SPFile file = web.GetFile(path); Stream dataStream = file.OpenBinaryStream(); // Open the document . using…
D T
  • 3,522
  • 7
  • 45
  • 89
1
vote
1 answer

Displaying OOXML String with OMML tags in browser (Java)

so I am working on a JAVA/html/php project. I am reading the OOXML out of a docx and saving all that into a String, cause in that String I can search for the "relevant" tags with the help of regex. After that I save that tags in a MYSQL database.…
BastiTri
  • 39
  • 8
1
vote
0 answers

How to get the relationship between an embedded document and its media file from Word using OpenXML

When a Word document contains an embedded Office document it creates a media file to display the name and logo of the document and it embeds the Office document. I am failing to relate the media file to the document using OpenXML. I can get the…
Gridly
  • 938
  • 11
  • 13
1
vote
0 answers

Visual studio 2019 OpenXML polish letters

I'm trying to change basic font to "Arial" but if it is any polish symbol its change back to Calibri like on picture. Is is any way to apply it for polish symbols? Run run = new Run(); RunProperties runProp = new RunProperties(); …
Dazzyl
  • 53
  • 1
  • 3
1
vote
1 answer

Insert text into Table in a word processing document (Open XML )

I have Document file with header and footer part. In the footer portion I have one table. So now I am trying insert text into Table cell. But whenever I try to do by this code it will be append paragraph type and change the height and weight of the…
1
vote
0 answers

Custom metadata (UUID) at a paragraph / text level in a docx

In short: I'm looking for a way for a (known) UUID to be associated with a paragraph and/or text run. I'm using dolanmiu/docxjs for exporting docx, and was extending the Paragraph and TextRuns to add my own metadata (uuids) on export. And have them…
theProf
  • 11
  • 3
1
vote
0 answers

OpenXML - How can I insert a value into a specific worksheet?

I'm fairly new to creating Excel spreadsheets in C# and I'm looking for advice. I've spent 2 or 3 days now looking through documentation and blogs etc but I cannot seem to find an answer to a common task. I need to insert a text value into a…
John Doe
  • 29
  • 1
  • 8