openxml-sdk Questions
5
Solved
I am trying to use openxml to produce automated excel files. One problem I am facing is to accomodate my object model with open xml object model for excel. I have to come to a point where I realise...
Helminthology asked 2/8, 2012 at 22:44
3
Solved
I am new to OpenXML (v. 2.5), and I can create rows and cells, but I need to be able to set the column width and I can not do that correctly for some reason.
Without this code:
Columns cols = ...
Chick asked 19/12, 2015 at 19:57
2
Solved
I have an Excel Template with various sheets to which I am dumping data retrieved from SQL Server using OpenXML, C#.
After I am done with dumping the data, I need to hide some of the sheets based ...
Lashawn asked 12/8, 2012 at 12:2
7
Solved
I'm reading an .xlsx file using the Office Open XML SDK and am confused about reading Date/Time values. One of my spreadsheets has this markup (generated by Excel 2010)
<x:row r="2" spans="1:22...
Ose asked 18/1, 2011 at 23:14
6
Solved
I have written a code to generate Excel file using OpenXML.
Below is the code which generates the Columns in the Excel.
Worksheet worksheet = new Worksheet();
Columns columns = new Columns();
int ...
Bookmaker asked 16/8, 2013 at 8:3
8
I am working on generating an excel template from code. When I run the piece to create my WorkBook, I get no errors in code, however when I go to open the Excel document, I get an error indicating ...
Scrubland asked 29/7, 2012 at 3:22
4
Solved
I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts.
I am trying to find a way with OpenXML SDK v2 to do the same...
Mudskipper asked 11/10, 2010 at 5:25
2
Solved
Is it possible to create and edit an excel document using OpenXML SDK without creating a local file?
As per the documentation the Create method demands for a filepath, which creates a local copy o...
Stringer asked 27/4, 2015 at 4:59
2
I am using below code to get the page count but it is not giving actual page count(PFA). What is the better way to get the total pages count?
var pageCount = doc.ExtendedFilePropertiesPart.Propert...
Soosoochow asked 27/11, 2018 at 5:43
3
I'm playing around with OpenXmlSDK to see if it's a viable solution for our Powerpoint needs. One thing that is required is the ability to position shapes in the Powerpoint. I've been searching aro...
Alastair asked 29/11, 2012 at 17:29
8
Solved
My program have ability to export some data and DataTable to Excel file (template)
In the template I insert the data to some placeholders. It's works very good, but I need to insert a DataTable too...
Fleur asked 4/8, 2012 at 18:42
2
Solved
Hi I use the below method to apply an AutoFilter :
public static void ApplyAutofilter(string fileName, string sheetName, string reference)
{
using (SpreadsheetDocument document = SpreadsheetDocu...
Ineffective asked 20/8, 2014 at 6:52
2
Solved
How can I change the font family of the document via OpenXml ?
I tried some ways but, when I open the document, it's always in Calibri
Follow my code, and what I tried.
The Header Builder I thin...
Pyrognostics asked 31/10, 2011 at 16:31
3
I have been working successfully with the C# OpenXml SDK (Unofficial Microsoft Package 2.5 from NuGet) for some time now, but have recently noticed that the following line of code returns different...
Bugloss asked 25/6, 2015 at 17:29
2
Solved
I know that there was same question here, however answers are kinda vague and do not show the full source code. I've got a method for generating a header, but it does not work(shows x on the image ...
Aeolic asked 20/6, 2017 at 9:12
2
Solved
The following takes the format of existing sheet sSheet and creates a red font (along with some timestamp content) at A19:
using (SpreadsheetDocument document = SpreadsheetDocument.Open(sPath, tru...
Citation asked 31/7, 2018 at 20:2
1
Solved
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 ite...
Clapp asked 9/1, 2020 at 16:46
5
Solved
I spent a lot of time trying to figure out a good way to embed any file into Microsoft Word using OpenXml 2.0; Office documents are fairly easy but what about other file types such as PDF, TXT, GIF...
Concave asked 23/7, 2010 at 20:50
1
I know there are many posts on SO about this topic, but none seems to treat this particular issue.
I'm trying to make a small generic document generator POC.
I'm using Open XML.
The code goe...
Mourning asked 12/12, 2019 at 11:32
1
Solved
I've spent countless hours trying to understand ordered lists in Open XML. Here's one of many references.
I found this incredibly helpful example of a simple document creator here.
Also if I may ...
Berglund asked 28/11, 2019 at 17:25
1
We are trying to manipulate a word document to remove a paragraph based on certain conditions. But the word file produced always ends up being corrupted when we try to open it with the error:
Wo...
Westward asked 18/6, 2019 at 12:51
2
Solved
This one very simple thing I can't find the right technique. What I want is to open a .dotx template, make some changes and save as the same name but .docx extension. I can save a WordprocessingDoc...
Pyrognostics asked 23/7, 2010 at 9:39
1
Solved
When working with Office Open XML documents, e.g., as created by Word, Excel, or PowerPoint since Office 2007 was released, you will often want to clone, or copy, an existing document and then make...
Mcgraw asked 28/11, 2019 at 13:43
6
Solved
I have an Excel 2007 spreadsheet that I edit with the OpenXML SDK 2.
I remove some rows etc.
I would like to know how to save that Spreadsheetdocument to another filename.
Pointsman asked 5/3, 2011 at 10:16
4
Solved
Using the SDK I'm building Word documents that contain reports. These documents need to have TOC.
Does anybody have a complete solution that I can follow in order to understand how to do this?
(I'...
Baroja asked 18/3, 2012 at 21:57
© 2022 - 2024 — McMap. All rights reserved.