Replies

• max4ever Posts: 45Questions: 0Answers: 0

  February 2011

  if you look in tabletools.js (the uncompressed version)
  there is this part
  [code]
  "xls": {
  "sAction": "flash_save",
  "sCharSet": "utf16le",
  "bBomInc": true,
  "sFileName": "*.csv",
  "sFieldBoundary": "",
  "sFieldSeperator": "\t",
  "sNewLine": "auto",
  "sTitle": "",
  "sToolTip": "",
  "sButtonClass": "DTTT_button_xls",
  "sButtonClassHover": "DTTT_button_xls_hover",
  "sButtonText": "Excel",
  "mColumns": "all",
  "bHeader": true,
  "bFooter": true,
  "fnMouseover": null,
  "fnMouseout": null,
  "fnClick": function( nButton, oConfig, flash ) {
  this.fnSetText( flash, this.fnGetTableData(oConfig) );
  },
  "fnSelect": null,
  "fnComplete": null,
  "fnInit": null
  },
  ...
  [/code]
  
  so basically you can do it like this (i tried and it works)
  [code]
  "oTableTools": {
  "sSwfPath": "/flash/copy_cvs_xls_pdf.swf",
  "aButtons": [
  {
  "sExtends": "xls",
  "sButtonText": "<?php echo $this->translate('xls tabella')?>",
  "sFileName": "*.xls"
  },
  ....
  [/code]
  
  that is you use "sFileName": "*.xls"
• GregP Posts: 487Questions: 8Answers: 0

  February 2011

  Are the two files not actually the same? I was wondering about this myself. It seems to me that the "Excel" sheet is just a CSV, which Excel can also read. The main benefit of changing the extension would be for the user's machine to open the proper helper application (Excel); but for Excel users, it's also usually the default for CSV.
  
  I'm currently disabling export to "excel" and letting Excel users just open the CSV. But if there's an actual format difference between the two, I might re-enable it and use the above suggestion.
• allan Posts: 61,627Questions: 1Answers: 10,090 Site admin

  February 2011 edited February 2011

  Greg is exactly right here - the Excel export is a little bit of a cheat since it's really outputting a CSV file (with UTF-16LE BO), which Excel will open no problem (and open by default on most systems). It's perfectly possible to use the .xls extension instead, however some versions of Excel will give a warning saying that the file is not in xls format (which it isn't - so fair enough). There was some concern that end users didn't like this (which I agree with), so I chose to use the .csv extension, which should have as small as possible impact on the end user (particularly non-technical ones).
  
  It is perfectly possible to write xls files, I just need to get the time to read, understand and reproduce the format - it is on the to-do list :-)
  
  Regards,
  Allan
• talkitivewizard Posts: 30Questions: 0Answers: 0

  March 2011 edited March 2011

  If you want to do the 2007/2010 format, it would be VERY simple seeing as it is just xml. I've done lots of work with powerpoints and have gotten to look at the file formats for all office documents. Maybe I can give you a hand on this part at some point. I'll just have to sit down and learn your framework for saving files from JS using flash.
  From one Allan to another Allan :P
  
  Allan Chappell
• allan Posts: 61,627Questions: 1Answers: 10,090 Site admin

  March 2011

  Aren't the xlsx files zip compressed in a certain directory structure? Or is it just an uncompressed XML stream? I don't actually have Office available at the moment, so perhaps someone might be able to send me a XML file which Excel can open so I can reproduce the format?
  
  Allan
• talkitivewizard Posts: 30Questions: 0Answers: 0

  March 2011

  your first assumption is actually correct. There's alot to the SpreadsheetML. Here's alink to the reference http://dl.dropbox.com/u/7177934/Ebooks/2427191-Office-Open-XML-Part-4-Markup-Language-Reference.pdf.
  Also a quick more picture filled guide
  http://dl.dropbox.com/u/7177934/Ebooks/Open%2BXML%2BExplained.pdf
  
  and lastly, an xlsx file that you can have fun with... just use winrar, or your favorite archive utility to unzip it... it's just a standard zip.
  http://dl.dropbox.com/u/7177934/tracking_report_476.xlsx
  
  I hope this helps
• allan Posts: 61,627Questions: 1Answers: 10,090 Site admin

  March 2011

  Cool thanks very much! It looks like that although Flash has built in ZIP compression for ByteArrays it doesn't do directory structures - so I'll probably need an external library for that kind of thing. Its not going to be trivial I suspect, since it looks like more than just creating an XML file, which would be dead easy... So it goes :-)
  
  Allan
• talkitivewizard Posts: 30Questions: 0Answers: 0

  March 2011 edited March 2011

  Sorry about miss leading you in anyway. I'm used to using PHP or C# to perform tasks. JS is not my strongest of languages, however, it has prepared me and spoiled me to the functionality that finally came out in PHP5.3 with anonymous functions and closures. (not that php5.3 has closures really but JS does! :D)
  
  Good luck, and you're welcome. Thank you for providing such a cool product. Many a site would be bland and less user friendly if it wasn't for you.