Save In pop-up using exportExcel

Archived Topics
5

Unfortunately there is currently no easy way to save to an Excel spreadsheet file without the popup. This has been improved in the next version, where there is also a dataSetToExcel function that returns a string. You have 2 options:

  1. Wait for the new release and use that.
  2. Open up the excel files that we export in a text editor - its all just plain text. You could output it yourself using fpmi.file.writeFile()

Al,
Like I’ve said before, our Excel compatability is limited. The output format is the xml format of an excel spreadsheet - the xls extension is so that excel opens it, not IE. The warning is unfortunate in 2007. In the future we should just standardize on the new xml format of 2007 and abandon all earlier versions of Excel.