Stack Overflow
Stack Overflow

Questions tagged [xml-spreadsheet]

Microsoft Excel spreadsheet file-format based on XML, called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002.

18 questions
7
votes
3 answers

Difficulty with send_data in Ruby on Rails in conjunction with Spreadsheet plug-in

I have a function in a controller that takes in some specifications and generates a report on them. This function user_report is called in a view: < %= submit_to_remote 'submit-button', "Export Report to Excel", :url => { :controller => :reports,…
Chris K
  • 71
  • 1
  • 2
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
2 answers

Google Sheets is unable to open an XML spreadsheet

I have an XML spreadsheet generated using VB.net I want to open it into Google Sheets, but Google is unable to perform this, and throws the error "Unable to convert". Is there any way to open an XML spreadsheet using Google Sheets?
Devdan Gaikwad
  • 93
  • 1
  • 2
  • 9
1
vote
0 answers

How to convert xls or xlsx to XML spreadsheet 2003 using C#

How to convert xls or xlsx to XML spreadsheet 2003 using C#? I know Spire.XLS does provide such functionality https://www.e-iceblue.com/Introduce/excel-for-net-introduce.html Is there any better way to do it? I will be having a bulk of xls or xlsx…
Vahi
  • 605
  • 1
  • 8
  • 17
1
vote
1 answer

C# and XML spreadsheet simple question

Hello guys I have 1675 line Code. Want to when user click button textbox.text insert into this xml spreadsheet and then create on desktop. does it possible? How can I insert text in current xml spreadsheet row? For example: `
Irakli Lekishvili
  • 33,492
  • 33
  • 111
  • 169
0
votes
2 answers

XMLSS styles using intag

Im working on program, that generate excel report from DB. Im using xmlss to create excel document and then convert it. Main problem is that to create cell with different from others style, i need to create the style first. But how to make this not…
StNickolas
  • 576
  • 7
  • 20
0
votes
2 answers

How to Read xml spread sheet

I have a 3rd Party tool that generates an xml spreadsheet (*.xls). I have another program that reads this spreasheet and processes it. The content of the generated xml spreadsheet is a table with 5 columns and my program runs select queries on them.…
Cshah
  • 5,612
  • 10
  • 33
  • 37
0
votes
2 answers

Array Formulas in Conditional Formatting of Excel XML Spreadsheet files?

Excel usually treats Conditional Formatting formulas as if they are array formulas, except when loading them from an Excel 2002/2003 XML Spreadsheet file. This is only an issue with the Excel 2002/2003 XML Spreadsheet format... the native Excel …
richardtallent
  • 34,724
  • 14
  • 83
  • 123
0
votes
1 answer

Converting XML SpreadSheet to XLSX using Javascript

I need to convert a XML SpreadSheet to a native Excel file (XLSX), without using MSOffice. In particular I need to make this conversion using Javascript. I'm searching for in "StackOverflow" web page and also in google and other portals, but I don't…
Ommarok
  • 3
  • 2
0
votes
1 answer

Sorting cells as per ss:Index

Server generated XML-spreadsheet has random sequence of s in each . Which is required to be sorted. I want to go with XSLT implementation for sorting s in each based on ss:Index. I tried but failed to get sorted result.(XSLT…
Amit Panasara
  • 600
  • 8
  • 16
0
votes
0 answers

Cell Styles don't work while generating excel without using any gem in Ruby on Rails

I used this template using cell styles: show_xls.xls.erb
Biju
  • 820
  • 1
  • 11
  • 34
0
votes
1 answer

XML Spreadsheets won't wrap text

I'm using XML Spreadsheets and cannot get the text to wrap value="Period
Totals
When I added "white-space: normal;" it will…
brezotom
  • 715
  • 1
  • 8
  • 12
0
votes
1 answer

How to select visibility of specific worksheet at the opening of Excel using Spreadsheet XML

I am getting spreadsheet xml from a code logic (Flex Grids to spreadsheet xml). I have 3 worksheets (A, B, C) in that spreadsheet xml. I am opening this spreadsheet xml in Excel. I want to view worksheet B when I am opening the spreadhseet xml in…
user211607
  • 57
  • 1
  • 1
  • 7
0
votes
1 answer

Laravel and DOMDocument createDocumentFragment

I have the following piece of code in a Laravel controller: public function toXMLSpreadsheet() { $doc = new DOMDocument(); $doc->load('xmlspreadsheet.xml'); $table = $doc->getElementsByTagName('Table')->item(0); $applications =…
rocordial
  • 17
  • 6
0
votes
2 answers

Doing "Save as" of an XML Spreadsheet document into an Excel Document in Java

How do I convert an "XML Spreadsheet" document into Excel using Java code? I can do this manually by opening this document (which windows recognize that it can be opened in Excel, so it opened it in Excel) in Excel and File->Save As-> Excel 2003…
dale
  • 439
  • 3
  • 11
  • 28
1
2