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
1
vote
1 answer

Does Excel ever create files that use Rich Text Inline in a cell?

The OOXML specification says that an SpreadsheetML cell may have a string stored in the shared strings area, or may be a Rich Text Inline element, like this: This is inline string…
eaolson
  • 14,717
  • 7
  • 43
  • 58
1
vote
1 answer

Decode XML Spreadsheet content of a clipBoard generated by Excel

I want to do a very simple thing in my program : When a user do a copy of a selection in Excel (2007 - 2016), I want to be able to read the clipboard content, then extract all the values. Currently Excel puts into the clipboard lots a different…
Maxoudela
  • 2,091
  • 3
  • 15
  • 23
1
vote
0 answers

Formatting substrings in SpreadsheetML cells using Xelem

When looking for a Java library which can produce (and read) SpreadsheetML 2003 files, I came across the Xelem library. It almost perfectly fits all my needs; however, it does not seem to provide the possibility to format parts of strings in cells…
Wave
  • 61
  • 6
1
vote
4 answers

Add Hyperlink to Cell in Excel 2007 Using Open XML SDK 2.0

I can't seem to find any documentation or code samples on how to add a hyperlink to a cell in Excel 2007 using the Open XML SDK 2.0. I am using the following code, but is there a step I am missing? WorksheetPart workSheetPart =…
amurra
  • 15,221
  • 4
  • 70
  • 87
1
vote
2 answers

Office Open XML - how to add additional Information to Presentation?

I would like to store akey / value pair into my presentation (basically a GUID to know if I have seen the file before). I know that excel and word have extended properties, which can be used to store this kind ofinformation. But I am unsure if I can…
Christian Sauer
  • 10,351
  • 10
  • 53
  • 85
1
vote
1 answer

Chrome automatically opens SpreadsheetML in new tab as XML

Since version 33.0.1750.117 of Google Chrome we experience problems with SpreadsheetML from our system. Normally we could force the download of the XML with the following instructions in our HTTP server. Header Always Set…
user3350923
  • 11
  • 2
1
vote
1 answer

How to convert SpreadsheetMl created in 2007 to 2010

I have a xml spreadsheetml document. This is used to create an excel document through my silverlight application. When the file created through this template is saved as *.xlsx Excel 2010 throws an error "Excel cannot open file '*.xlsx' because the…
xaria
  • 842
  • 5
  • 24
  • 47
1
vote
2 answers

Spreadsheet ML Text Color (Colour) Rendering

I am writing a tool which generates some Spreadsheet ML (XML) to create an Excel spreadsheet for my users. I have defined a style as follows: This…
Chris Roberts
  • 18,622
  • 12
  • 60
  • 67
1
vote
1 answer

OpenXML - CellFormats - Do I really need to configure one for every single permutation?

I'm currently working with v2.0 of the SDK to generate an Excel workbook and it was all going well until I came to apply the cell formatting. I've created a few CellFormats and successfully applied them but there are a few more permutations that I…
DilbertDave
  • 3,406
  • 3
  • 33
  • 42
1
vote
1 answer

Newlines in Spreadsheet ML when read by Excel

I'm trying to write a XSLT to produce a Spreadsheet ML to be further read by Excel and run into a problem with newlines. I need to add a newline to cell data. I made a sample in Excel to check the Excel idea of newline and got the…
Mikhail Edoshin
  • 2,639
  • 16
  • 25
1
vote
1 answer

Export AsciiMathML equations to Excel Format

I have to export a list of mathematical questions which have AsciiMathML notation to an Excel spreadsheet and I want to show the equations properly. My code is written in PHP and I want to create the Excel file on the server side and make it…
Shakeel
  • 574
  • 1
  • 5
  • 16
0
votes
3 answers

Is there a way in SpreadsheetML to force Excel to recalculate formulas (and other dependencies) when document is opened?

As far as I understand cells with formulas in Microsoft Office Excel can contain calculated values when serialized and saved in Office Open XML formats (specifically SpreadsheetML). This most likely applies to other types of dependencies and…
Bohdan Tsymbala
  • 46
  • 3
0
votes
1 answer

Creating Dataset from spreadsheetML

Is there any way to create a dataset from a spreadsheetML using C# without using Interop.Excel?
Kings
  • 1
  • 1
0
votes
1 answer

How to convert Excel SpreadsheetML to .xlsx using python

I'm new to python, so i have this XML file which i can open pretty easily using Excel, this is XML file andi want to convert it to .xlsx or any compatible format to be able to use openpyxl module to it so that i can read it easily, is there any way…
Jolzal
  • 547
  • 7
  • 19
0
votes
1 answer

cognosdotnet_10_2 and spreadsheetML output

Trying to get spreadsheetML output from Cognos using cognosdotnet_10_2.dll. "Outputpage" data is base64 encoded string. I'm trying to get something readable out of base64string to plainText variable. I have tried with basically most of the basic…
RandomBug
  • 186
  • 1
  • 7
1 2 3
4
5 6