Part of the Office Open XML specification ECMA-376
Part of the Office Open XML specification ECMA-376, along with WordprocessingML, PresentationtML, DrawingML, Shared MLs and Custom XML Schema
Questions tagged [spreadsheetml]
79 questions
5
votes
1 answer
Style for wrapped text with spreadsheetml
I generate my spreadsheet with xslt and want a cell with wrapped text (or better: a text with a line break in it).
So my xslt generates the following XML for the sheetdata:
…
domueni
- 304
- 8
- 19
4
votes
4 answers
How to apply outline table border to a cell range using OpenXml?
I set border style for each cell. But if you look closely, you'll see the blue lines are not consecutive. There are some white hash marks across the vertical lines. Because inside the table, I set the top and bottom cell border as white. Anyone…
Joyin
- 295
- 1
- 3
- 11
3
votes
1 answer
How does Excel calculate how many pixels to add/subtract when switching from "Normal" view mode to "Page Layout" view mode?
If you create a new table in Excel and look at the column width in "Normal" view mode, it will be 64px
Now if you switch to "Page Layout" mode and look at the column width, it will be 69px
That is, Excel added 5px (this is for the Calibri font, set…
Ramil Shavaleev
- 364
- 3
- 12
3
votes
0 answers
Save vnd.openxmlformats-officedocument.spreadsheetml.sheet python
I have a file that is extracted through an API in the following form:
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
that I want to save to my computer. I'm using Python to save this xlsx file, but no success so far.
Anyone who…
Michiel Aarts
- 63
- 2
- 7
3
votes
1 answer
Format Excel Cells with XML
I want to generate an Excel programmatically (Salesforce Apex) something similar to below screenshot. The number of Cells, background color of the cells will be decided at the run time and hence using programmatic way.
To achieve this I tried to…
highfive
- 628
- 3
- 12
- 31
3
votes
2 answers
Existing API for reading dates from SpreadsheetML files?
Is there an existing API in Office Open XML SDK or a 3rd party to properly read dates from a SpreadsheetML / .xlsx file?
Since there are so many variables that affect detecting when a value is a date (numFmtId + custom number formats) and then…
Samuel Neff
- 73,278
- 17
- 138
- 182
3
votes
1 answer
What does mean in OpenXML?
I'm try to understand OpenXML spreadsheet inner file content.
IN some file I found this string . Other tags has same prefix.
Also tags may have prefixes p: w: etc.
Can you help me undestend the meaning of these prefixes in tags?
Klom Brethermod
- 31
- 1
3
votes
0 answers
Parse SpreadsheetML using Java
Need to parse Excel 2003 XML file
someuser
- 83
- 1
- 1
- 6
3
votes
0 answers
How to insert hyperlink in excel using open XML in c#
How to insert hyperlink in Excel using C#? I tried this, but it's not working
WorksheetPart workSheetPartss = new WorksheetPart();
workSheetPartss.AddHyperlinkRelationship(new Uri("http://www.google.com", UriKind.Absolute), true);
…
user2377806
- 53
- 1
- 2
- 7
3
votes
2 answers
Excel file with openxml with multiple sheets in single workbook
I am trying to insert data to multiple sheets. For my excel, I have two sheets which are "charts" and "ChartData". I'm able to update the data in sheet2, chartdata sheet, but I'm unable to insert data to sheet1. Here is code which I have tried to…
Sumanth Sharma
- 135
- 2
- 16
3
votes
3 answers
OpenXML Selecting a specific column
I'm attempting to select a specific column so that I can set it's width automatically but am having little success. Should I not be able to use MSDN's version of GetRow to select the column from the columns collection instead?
return…
Kulingar
- 941
- 3
- 14
- 30
2
votes
1 answer
How to add a cell with an inline string value to a Spreadsheet using the Open XML SDK
When using the Open XML SDK to add cells with non-numeric text to a worksheet, the officially documented method is to use the shared string table. While I recognize the performance and storage efficiency benefits of this approach in the general use…
Dan Stevens
- 6,392
- 10
- 49
- 68
2
votes
1 answer
OpenXML SDK - C# - Calculation Chain / Marking Cells as Edited to Force Full Recalculation on Open for Mobile/Web
Use Case
I have a windows service that makes use of the OpenXML sdk to write in tabular pricing data to an Excel sheet each day. This report is made available via a file share as well as sent out as an attachment. There are several other sheets in…
Roy
- 69
- 7
2
votes
1 answer
XSL: create a cross tab under Excel with XSLT
I have an xml file like this :
Audi
S3
1
…
рüффп
- 5,172
- 34
- 67
- 113
2
votes
1 answer
Excel Insists that my OpenXml file has errors
Okay, I'm generating an Excel file from a DataTable. I generate the file and save it, no compilation or run-time errors. When I open the file in Excel though, it pops up the message:
We found a problem with some content in 'filename.xlsx'. Do you…
eidylon
- 7,068
- 20
- 75
- 118