Save files in excel-format

BlitzPlus Forums/BlitzPlus Programming/Save files in excel-format

Hi!

Is it possible to write date into a format that excel could read? If I do WriteFile I get a strange data format which I can use in BlitzPlus again but cannot copy/paste into another (windows) program.

Thank you very much in advance!

yes, it is completely possible but you would need to look up excel format specs. Here's the format for Excel 97...a bit old http://www.wotsit.org/download.asp?f=excel97

You might also want to have a look at the CSV (comma separated values) file specification. Nearly all-spreadsheet packages can read-it and it's really easy to make.

I hope you are up for the task.??? here is the complete 2003 excel format in a pdf file good luck:
http://sc.openoffice.org/excelfileformat.pdf#search=%22excel%20format%22
all 222 pages.

I think CSV would be the best way to go with this, unless you need any of the advanced stuff the excel format provides.