openxml-sdk Questions

2

Solved

I have an Excel 2010 spreadsheet that has 3 worksheets named Sheet1, Sheet2 and Sheet3. I'm trying to get a reference to a worksheet by name. I'm using the code: using (SpreadsheetDocument myWo...
Converter asked 11/1, 2012 at 2:14

2

Solved

I've been googling and searching on the site for the answer, but I couldn't find a solution - everywhere people mostly discuss how to add new number format to the document and apply it. What I nee...
Inhibit asked 19/1, 2012 at 16:40

1

Solved

Got template docx with image placeholder which replaced by correct picture. private void SetImagePartData(ImagePart imagePart, byte[] data) { if (imagePart != null) { using (var writer = new B...
Earnestineearnings asked 16/1, 2016 at 14:28

4

Solved

I have a spreadsheet document that has 182 columns in it. I need to place the spreadsheet data into a data table, tab by tab, but i need to find out as I'm adding data from each tab, what is the ta...
Lipkin asked 21/9, 2011 at 17:50

4

Solved

I have a Microsoft Word Document (docx) and I use Open XML SDK 2.0 Productivity Tool to generate C# code from it. I want to programmatically insert some database values to the document. For this I...
Wira asked 13/10, 2011 at 10:45

1

Solved

When using the OpenXML SDK to apply a border to a merged cell range, the border is only showing up for the first (top left) cell in the merge range. I have absolutely no idea and this is driving me...
Georgie asked 5/11, 2015 at 23:37

4

When I am trying to read .doc file using DocumentFormat.OpenXml dll its giving error as "File contains corrupted data." This dll is reading .docx file properly. Can DocumentFormat.OpenXml dll hel...
Branching asked 2/4, 2012 at 10:47

1

Solved

I'm working on a C#/ASP.NET web thing and want to do an Excel export. First I found OpenXML, made some first steps, but it's really hard to use. Now, I'm using ClosedXML and it's quite a relief - s...
Selfsufficient asked 17/7, 2015 at 11:7

2

Solved

I am working on taking an existing Excel File which already has all of its formulas and formatting, I add data to the a sheet with a Table and when I then open that file in Excel I get the error ...
Mackey asked 28/8, 2015 at 18:15

1

I am reading one element from code and I am getting Open XML string as a result. byte[] binary = Convert.FromBase64String(template.Attributes["body"].ToString()); string bodyContent = UnicodeEnc...
Input asked 1/7, 2015 at 4:38

1

Solved

I am attempting to iterate through the images in a PowerPoint presentation using OpenXML. I have worked out how to do that. I am now attempting to get the Images Alt-Text Title.... Here is my code:...
Haihaida asked 14/8, 2015 at 11:30

2

Solved

I have an Asp.Net Mvc application. In this application i have a functionality to download data from Database to Excel file (with OpenXml Sdk). It works now. But when data is large, time from user r...
Confutation asked 24/10, 2012 at 12:28

3

Solved

I have the piece of code below. I'd like replace the text "Text1" by "NewText", that's work. But when I place the text "Text1" in a table that's not work anymore for the "Text1" inside the table. ...
Merozoite asked 30/9, 2013 at 12:32

2

Solved

As to MSDN the basic document structure of a SpreadsheetML document consists of the Sheets and Sheet elements, which reference the worksheets in the Workbook. For example, there is one workbook wi...
Panada asked 18/3, 2015 at 5:50

1

Solved

I am using open XML(Microsoft Word - .docx) as a file template to automatically generate other documents. In the template document I have defined content controls, and I have written code to replac...
Sigurd asked 17/3, 2015 at 6:43

4

Solved

I am going to start a Server side Office automation project in .Net. Below are the key activities that are planned: Create a word document Use a existing word document template having cover page,...
Kessiah asked 10/6, 2011 at 5:40

4

Solved

Can the Open XML SDK be used in Mono?
Foresheet asked 26/5, 2011 at 21:11

2

Solved

I am trying to use Microsoft's OpenXML 2.5 library to create a OpenXML document. Everything works great, until I try to insert an HTML string into my document. I have scoured the web and here is wh...
Lamprey asked 6/8, 2013 at 20:32

1

Solved

Here are the steps I am following to examine the behavior: 1# Create an Excel(xlsx) file, put 1234.56789 in a cell, save it. 2# Extract the .xlsx file, see the sheet1.xml and styles.xml files. In...
Anamariaanamnesis asked 14/1, 2015 at 17:17

1

Solved

I'm iterating over my worksheets like so WorkbookPart wbPart = doc.WorkbookPart; SharedStringTablePart sstPart = wbPart.GetPartsOfType<SharedStringTablePart>().First(); SharedStringTable sst...
Janssen asked 31/10, 2014 at 6:9

2

Can anybody guide me how to add predefined styles on paragraph using open XML Word Processing? I have tried various solutions available on forums but nothing works for me. Here is what i want to ac...
Smalto asked 29/7, 2013 at 11:24

5

Solved

I recently started working on the Open XML SDK 2.0. I would like to know if there is any better documentation (instead of open xml sdk2.0 itself) or any other resource to learn working with ...
Thirza asked 3/12, 2010 at 6:40

1

Solved

I am parsing through an Excel spreadsheet and had some problems with some values, so on the suggestions of a stackoverflow member, I evaluated them as shared strings. Now, however, some of the cell...
Stud asked 7/8, 2014 at 15:56

1

I am attempting to create a datatable from an Excel spreadsheet using OpenXML. When getting a row's cell value using Cell.CellValue.innerXml the value returned for a monetary value entered by the u...
Serum asked 29/7, 2014 at 2:8

2

Solved

I'm trying to return a openXML spreadsheetdocument as a byte[] which I can then use to allow my MVC to send that file to a user. here is my spreadsheetdocument method to return the byte array usin...
Cordite asked 28/2, 2014 at 17:1

© 2022 - 2024 — McMap. All rights reserved.