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
0
votes
0 answers

How to open an Excel file in PrintPreview without suspending the code

I'm new to C#/OpenXML and could not find an answer to this. Apologies in advance if it's a stupid question... Basically, I am writing an application that creates Excel files from an input string. This input string may contain information about…
Nick McGurk
  • 1
  • 1
0
votes
0 answers

How do you make a workbook or worksheet read only using SpreadsheetML / Excel 2003 XML?

I am using SpreadsheetML to generate an Excel spreadsheet with multiple worksheets. I would like to make the document read only when opened with Excel. How can I do this? (I appreciate that a user could open the XML file as text and do what they…
ALT__
  • 86
  • 1
  • 1
  • 4
0
votes
1 answer

speadsheetml invalid when the data contains <>

I noticed that the spreadsheetML will break if the data contains a <> tag inside the data element. For example, the tag below is valid if the data is testing data testing data The…
Jonas
  • 137
  • 1
  • 5
  • 18
0
votes
2 answers

Converting Open XML to SpreadsheetML in Open XML SDK 2.7 C#

I have an excel workbook with a small table in Sheet 1 like this: If I open the raw XML via 7zip or something, the Open XML output for the worksheet data looks like this:
JasonWH
  • 179
  • 2
  • 17
0
votes
0 answers

File that normally opens our application, but will fall back to Excel

Our application exports snippets of databases in XLSX format. We wrote our own code on top of System.Packaging as it is many (many!) times faster than using the Excel objects. Right now we save these files with a .xlsx format, and that works OK.…
Maury Markowitz
  • 9,082
  • 11
  • 46
  • 98
0
votes
1 answer

Exporting tabular data in Numbers-readable format

I have app that exports data in CSV. Recently I added "Open In..." feature for opening .csv files in other apps. I would like to be able to have Numbers (on iPad) open exported files as well. Trawling through Numbers's Info.plist, I saw that it…
westsider
  • 4,967
  • 5
  • 36
  • 51
0
votes
1 answer

Apache POI "Invalid header signature" opening Excel XML

Is it possible to open an excel xml ( an xml which can open in microsoft office excel ) and it is a perfectly good xml that complies with xml spreadsheet reference I tried to use : String outputFile = "output.xml"; FileInputStream file = new…
SomeDude
  • 13,876
  • 5
  • 21
  • 44
0
votes
2 answers

XSLT Transformation to Excel

I have to transform the result of a query (xml format) into an Excel file. Example of the query-result :
Soldierflup
  • 114
  • 1
  • 9
0
votes
3 answers

With C# is it possible to put an object on the clipboard that will paste into excel as data and formulas?

In a WPF application, I need to generate data that can be put on the clipboard and pasted into excel. I need to paste something that can carry over data and formulas. I was attempting OpenXML... but I'm not sure that works. I am currently…
Phobis
  • 7,524
  • 10
  • 47
  • 76
0
votes
3 answers

Parsing SpreadsheetML Using Perl

What's the best way to parse a file in SpreadsheetML format with Perl? I've tried Spreadsheet::ParseExcel, but it doesn't recognize the format. Here's the error I get when trying that module: No Excel data found in file It looks like CPAN doesn't…
Dave
  • 5,436
  • 11
  • 48
  • 74
0
votes
1 answer

I didn't understand what is 's' refering to in s="1", "s=2" and so on in the SpreadsheetDocument in Openxml

Please tell me what is 's' referring to in SpreadsheetML
Anand T
  • 123
  • 1
  • 3
  • 8
0
votes
1 answer

Building an Excel API

I tried unzipping the .xlsx file and could find some files in it. But I am not sure as to what these files contain and how they are related. Where can I find the DOCS for creating spreadsheetML?
Trijit
  • 501
  • 1
  • 4
  • 18
0
votes
1 answer

Open XML SDK for JavaScript spreadsheeml

I am creating excel spreadsheet by using Open XML SDK for javascript. used below script to add spreadsheet data. Open XML SDK Javascript var table = wsXDoc.descendants(openXml.S.sheetData).firstOrDefault(); var newRow = new…
fazil
  • 1
  • 1
0
votes
2 answers

Need to manually set pagebreak in manually created Excel file

I am creating an Excel file manually from within an iOS app I wrote. It just spits out an XML sheet with an Excel file extension attached to it that opens in Excel without issue. The problem is that the file has 5 columns. For whatever reason -…
Hanny
  • 2,078
  • 6
  • 24
  • 52
0
votes
1 answer

How to expand spreadsheetML markup to regular matrix markup using XSLT 1.0

With spreadsheetML generated by Excel 2007 (and onwards into newer versions), the xl:Row and xl:Cell elements may include attributes for ss:Index which provides a row or column designation that "skips over" intervening entirely blank cells. This…
Dave
  • 378
  • 4
  • 14
1 2 3 4
5
6