openxml Questions
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
3
Solved
I'm using this method for generating docx file:
public static void CreateDocument(string documentFileName, string text)
{
using (WordprocessingDocument wordDoc =
WordprocessingDocument.Create(do...
Escutcheon asked 11/5, 2016 at 6:20
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
The problem:
I am using EEPlus.
I am stuck at applying a hex color code, e.g. #B7DEE8, for a cell in my Excel sheet.
I got the following (working) code:
ws.Cells["A1:B1"].Style.Fill.PatternType...
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
I am trying to write an Excel Xlsx spreadsheet with styling using OpenXmlWriter (SAX).
I am able to create the file with rows and columns (populate them as strings).
I am looking for a simple code...
1
Solved
I have code that copies the content of one PowerPoint slide into another. Below is an example of how images are processed.
foreach (OpenXmlElement element in sourceSlide.CommonSlideData.ShapeTree.C...
Discovert asked 31/8, 2020 at 17:40
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
1
Following is the code I have and in the final method below, I do all the operation. Please ignore the return types of methods, I have changed it later.
public static byte[] CreateExcelDocument<...
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
4
Solved
I am generating xlsx files and would like to not have to compute the values of all formulae during this process.
That is, I would like to set <v> to 0 (or omit it) for cells with an <f>...
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
2
Solved
Please clarify the my doubt
WordML/DOCX Default Unit Measurement is pixel or point or EMU or inches.. ?
2
I'm creating a word document using OXML in Visual Studio. I don't know how long it is going to be and I need to add a simple page number in the footer of the document.
To generate headers and foot...
Conatus asked 18/7, 2016 at 7:17
3
Solved
I have a xml which I want it to be extracted using OpenXML within SQL Server
Here is the sample XML
<row>
<student_token>7</student_token>
<student_ssn>552</student_ssn...
Appurtenant asked 6/3, 2012 at 14:13
4
Solved
Is it possible to extract chart information from an Office 2007 (xlsx / OpenXML) spreadsheet using Apache POI? I've managed to read in the spreadsheet and even get the part that refers to the chart...
Fayina asked 8/4, 2011 at 18:28
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
4
Solved
I've been searching for hours and I just can't seem to find a solid answer for this. I have an existing document with content controls that I need to edit the text in with external data. If the dat...
2
So I was trying to replicate this answer Getting cell-backgroundcolor in Excel with Open XML 2.0
but VS is complaining about SpreadsheetReader not existing in the current context. I can't ctrl+. r...
Messaline asked 23/7, 2015 at 10:35
1
Solved
I'm trying to use SXSSFWorkbook to write an Excel spreadsheet from scratch.
wb = SXSSFWorkbook(500)
wb.isCompressTempFiles = true
sh = streamingWorkbook.createSheet(t.getMessage("template.shee...
Undermanned asked 31/3, 2020 at 14:36
8
I need to use C# programatically to append several preexisting docx files into a single, long docx file - including special markups like bullets and images. Header and footer information will be st...
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
3
Solved
I have spent many hours trying to determine a formula to convert .NET pixels to an Excel column width using the OpenXML format. I am using EPPlus to generate xmls documents. I'm trying to determine...
© 2022 - 2024 — McMap. All rights reserved.