Stack Overflow
Stack Overflow

Questions tagged [spreadsheetml]

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

79 questions
2
votes
1 answer

How to generate SpreasheetML samples for all three date compatibility settings from Excel 2010?

According to the ECMA-376, Second Edition, Part 1 - Fundamentals And Markup Language Reference SpreadsheetML supports date serial values with three possible compatibility settings and various…
Samuel Neff
  • 73,278
  • 17
  • 138
  • 182
2
votes
1 answer

Multiple Panes in Excel 2003 Spreadsheet XML

I want to generate an excel spreadsheet with three horizontal panes. Report Header Report Titles Report Values So that the Titles will scroll to the top of the document and then "freeze" while the Values scroll underneath the Titles. I have been…
Mr Griever
  • 4,014
  • 3
  • 23
  • 41
2
votes
1 answer

Specify column width and row height for excel using html table

I'm working on a project where I need to export a html table to excel sheet using jquery. I have the required plugins and all but what I'm unable to do is set column width when excel opens the file.I've tried setting and…
nj-ath
  • 3,028
  • 2
  • 25
  • 41
2
votes
2 answers

How change excel 2007 document orientation to landscape by OpenXML sdk

I need help with changing excel 2007 document orientation to landscape. I have not found any helpful information about this. I am using OpenXML SDK for this. The only thing I have found: when I create a new Worksheet I should set PageSetup() {…
Paul
  • 21
  • 1
  • 2
2
votes
1 answer

Add Excel's SUM() to XLST result page?

How to apply SUM() function to every hours node? I will be saving this transfomred XML as Excel where I would like it to have SUM() function embedded. After researching there seems to be so many ways to do it, but none really apply to my…
user3681280
  • 43
  • 2
  • 5
2
votes
5 answers

Excel not inserting leading zero

I am using Office OpenXml to write to an Excel file. The file is a template so it already has all my headers and formatting for my columns. I am inserting numbers that have leading zeroes to a "special" column which is basically a 10 digit number.…
user541597
  • 4,247
  • 11
  • 59
  • 87
2
votes
0 answers

SpreadsheetML - Errors and Validation

I generate a SpreadsheetML file for MS Excel in my C# project. This worked since some changes yesterday. Now I have issues opening it. It comes up with the error: XML PARSE ERROR: Null or missing attribute value Error occurs at or below this…
FinalNotriX
  • 385
  • 2
  • 13
1
vote
2 answers

OpenXML SpreadsheetML Sideways text

I'm trying to figure out how to get text to print sideways in a spreadsheet cell in OpenXML. I'm thinking it can be done somehow with the ExtendedProperties of the Cell class. here's what I've got. Cell cell = GetCell(worksheetPart.Worksheet,…
Kulingar
  • 941
  • 3
  • 14
  • 30
1
vote
1 answer

OpenXML validation error says knownFonts attribute not declared but it is

I'm getting a validation error when I run OpenXmlValidator.Validate(). The 'http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac:knownFonts' attribute is not declared. I use the following code to register my fonts. public uint Register(Font…
Jonathan Wood
  • 65,341
  • 71
  • 269
  • 466
1
vote
2 answers

How to use XPath in JavaScript to select from namespaced OOXML?

I am building a tool to get data from a user specified XML file with an XPath expression. Simple XML files and an XML file with a single namespace works fine but I do not get the following XML file to work where the same prefix is overridden at…
Robert
  • 2,357
  • 4
  • 25
  • 46
1
vote
1 answer

Inconsistent visualization of numerical values in Excel 2007 vs the underlying xml file

I am attempting to read an Excel 2007 file (xlsx) from outside of Excel and I am finding an inconsistency that I cannot explain. If you enter the value of 19.99 into a cell and then look at the underlying Xml document it is actually stored as…
Dale Couch
  • 113
  • 1
  • 6
1
vote
1 answer

XSLT 1.0 - Build an XML spreadsheet with two tables based on separate XML elements

I need to build an XML Spreadsheet (SpreadsheetML) file in a certain format from an XML document which contains the data structured in separate elements (using XSLT 1.0). A simplified sample is below: …
Bartosz
  • 4,406
  • 7
  • 41
  • 80
1
vote
0 answers

How/Can I Send an Email in BizTalk with an Excel attachment?

I have transformed my data into an XML (SpreadsheetML) that can be opened with Excel and then saved manually as an xlsx file. I can do the transformation into XML within BizTalk and I thought I could load and then save the XML into an Excel file. …
MintyOwl
  • 71
  • 1
  • 10
1
vote
0 answers

Unable to open xls (SpreadsheetML, XML Spreadsheet 2003, or XMLSS) on LibreOffice v5.4.4.2

I have does the installation of LibreOffice Version: 5.4.4.2 (x64) Build ID: 2524958677847fb3bb44820e40380acbe820f960 on my organization and they can open all documents except one, a .xls file (SpreadsheetML, XML Spreadsheet 2003, or XMLSS) with the…
alara
  • 11
  • 2
1
vote
1 answer

OSX / iOS Preview compatibility with SpreadsheetML (.xlsx)

I am programmatically generating SpreadsheetML, bundling in a .xlsx file. The files open perfectly on Excel on Windows, OSX, and iOS. But when using Preview or Numbers on OSX or iOS, the files do not display any content. It appears Preview and…
lschult2
  • 588
  • 2
  • 5
  • 16
1 2
3
4 5 6