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. |