OpenEuphoria

2. Re: Creating an Excel file?

• Posted by Greg Haberek Jul 03, 2008
• 881 views

There is something in the Archive to do this. However, the Archive is not currently search able.

-Greg

4. Re: Creating an Excel file?

• Posted by Jeremy Cowgar Jul 03, 2008
• 793 views

I thought I remembered searching for one before w/no luck, that's why I asked here. However, since you said there was, I browsed each category. I found it under Utilities. Thanks for the pointer. It's doing what I want, as of now. It only has add_label and add_number routines, but I can work with it.

Thanks for the tip!

Jeremy

6. Re: Creating an Excel file?

• Posted by Michael Sabal Jul 03, 2008
• 786 views

integer fh = open("file.xls", "wb") 
 
addCell(fh, 1, 1, "Name", {"font=bold", "size=15"}) 
addCell(fh, 2, 1, "John", {}) 
addCell(fh, 2, 1, "Jane", {}) 
-- etc... 

Your best bet is to create an HTML table and save it with an XLS extension. MS Excel will be quite happy to read it completely formatted as if it were a BIFF8/OLE2 (Excel's native format) file. OpenOffice, however, will try to open the file with Writer instead of Calc. The demo in the archives uses BIFF2, which is a very old format that modern versions of Excel have trouble with. OpenOffice, however, reads it just fine.

Contrary to common sense, Microsoft Office files are really FAT file systems, with indexed tables and pointers all over the place. I have a very limited program to read BIFF8 files, but haven't been successful with writing them, and haven't tried too hard since the HTML option is so much easier.