i have got a XML-Excel file (SpreadsheetML format): <?xml version="1.0" encoding="utf-8"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office...

With ClosedXML I am trying to add data to an existing Excel Sheet In an Existing Table. The easy thing to do is to add a table to an excel sheet below is a quick example of how to do that. What I d...

Excel doesn't support the shared formulas (created by the OpenXML SDK https://www.microsoft.com/en-us/download/details.aspx?id=30425) as expected: formulas having a reference to a sheet and not u...

using code like using OfficeOpenXml; // namespace for the ExcelPackage assembly … FileInfo newFile = new FileInfo(@"C:\mynewfile.xlsx"); using (ExcelPackage xlPackage = new ExcelPackage(newFile)...

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 ...

I want to add a section break at the end of the document and add some text. My code is as below: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Docume...

I have pre define excel format i need to pass the data to excel.I'm able to get the particular sheet .But don't know how to pass the data to cell. var excelDocument = new ExcelDocument(); var file...

I am using openxml to create an excel report. The openxml operates on a template excel file using named ranges. The client requires a totals row at the end of the list of rows. Sounds like a reaso...

I am trying to generate a spreadsheet in .NET which will be opened by my manager on his iPad when he's out of the office. The spreadsheet opens fine on a Windows PC, but when trying to open on the...

I'm using Microsoft Open XML SDK 2 and I'm having a really hard time inserting a date into a cell. I can insert numbers without a problem by setting Cell.DataType = CellValues.Number, but when I do...

Edit: This question's text has been changed to reflect utilizing open xml code and interop. I'm trying to insert a base 64 encoded image to a Word document via a ribbon. The following code is for r...

I want to apply a text alignment in table cell in a table with OpenXML. I don't understand why it is not applied. Table table = new Table(); TableRow tableHeader = new TableRow(); table.AppendChi...

I am trying to open .docx file and convert to PDF using Interop.Word.Application. It works as console application but If I use the same in my web application it doesn't work. I tried to see the per...

I am using the following code to generate excel. http://www.docjar.com/html/api/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java.html import java.io.*; import java.util.*; import java.util...

I am able to add in an image to an excel spreadsheet by using OpenXML. However for the rest of the program I use ClosedXML to add data. I can add data at a specific cell using the column and row in...

I am trying to create an Excel file in xlsx format using OpenXML because I need to use that on a web server. I don’t have any problem to fill the values in the sheets; however I am struggling to s...

My OpenXML Word document generation project requires text, tables, and images. But first, I need a document header with a logo (image) in it. I've used the Microsoft example for creating headers a...

I am creating a sample handler to generate simple Word document. This document will contains the text Hello world This is the code I use (C# .NET 3.5), I got the Word document created but there i...

I'm currently trying to work with docx files using PHPWord library and its templating system. I have found and updated someones (cant remember the name, but its not important) path to this library ...

I'm attempting to open a Word document, change some text and then save the changes to a new document. I can get the first bit done using the code below but I can't figure out how to save the change...

I am using PHPWord to load a docx template and replace tags like {test}. This is working perfectly fine. But I want to replace a value with html code. Directly replacing it into the template is no...

With EPPlus and OpenXML does anyone know the syntax on how to count the rows? Say my worksheet is called "worksheet" int numberRows = worksheet.rows.count()? or worksheet.rows.dimension I'm cert...

Using OpenXML, I'm inserting some text into a document that I know will be marked as incorrectly spelled (because it's a product name) and will be marked with the angry red line/squiggly when the f...

I'm parsing a piece of hmtl into a word document using the following code //Need the following packages //<package id="DocumentFormat.OpenXml" version="2.7.2" targetFramework="net471" /> //&...

I have an XML file with the data that I need to be populated on a Word document. I need to find a way, to define a template which can be used as a base line to populate data from an XML file and c...