PureBasic Forums - English

Been wondering, any of you here have tried to open excel XLS files? any format of them (I know they may have changed with 2k or XP) as I need to open them and at least get the value of some cells, is that possible, to open and read XLS files?

Thanks in advance

Kaiser wrote:Been wondering, any of you here have tried to open excel XLS files? any format of them (I know they may have changed with 2k or XP) as I need to open them and at least get the value of some cells, is that possible, to open and read XLS files?

Thanks in advance

Try this viewtopic.php?t=14864

There is some great powerbasic code for Excel files : http://www.powerbasic.com/files/pub/pbw ... API_PB.zip
Maybe one of the experts around could translate it ?

Oooohhh those two links look quite useful! thanks! I'm gonna check them out and ask here if anything for not making another thread ^^

Hi,
I'm working on this problem, my solution creates a BIFF2 file, but it needs double float numbers (see http://www.purearea.net/ and download "F64" librarys).

My program (TOXCEL) reads an ASCII file (called "TOX" file), and creates a XLS file. Download it at:

http://www.tcseries.com/FTP/TOXCEL.ZIP

I've included a test file (PRUEBA.TOX) and F64 librarys needed.

Enjoy
JOAQUIN

Congratulations! this is very useful. Really esteem this lib


Y a la española : ¡Felicides! esto es muy útil!. Realmente aprecio esta librería

UBA UBA!

Nice one !

Here is a HotBasic example : http://www.angelfire.com/space/netcensus/hot/hotxls.zip (include file with many functions).

Kaiser or others, do you know how can I set Autofit propierty for all columns???.

Thank you for this lib!

ALL about EXCEL formats in:

http://sc.openoffice.org/excelfileformat.pdf

JOAQUIN

I search how I can open an existing file and read it whitout use ODBC
Is it possible JOAQUIN ?

Bernard

Yes but it's difficult, here is a small example which obtains a few items from the xls file.
It was a rewrite from some example i found.
It does not much but you'll need to read the PDF's toroughly before you can modify this example.

The example was written in PowerBASIC:

http://www.powerbasic.com/support/forum ... 01984.html

2Bernard
Yes, I'ts very difficult, I think.

I do not know how to do it, but I have found a library in HotBasic, who reads a BIFF8 file (Author says)

Download HotXLS from
www.angelfire.com/space/netcensus/hotbasic.html

If you could translate it to PB I will be eternally gratefull.

JOAQUIN

It seems it interprets the file 100%, the istorage part i showed you is imo safer.
The actuall record reading could be equal to the HB example though.
I have not invested this much, i find the code ackward, but maybe it isn't.

Kaiser or others, do you know how can I set Autofit propierty for all columns???.

Disculpen.. (excuse me) I would also like to know how to auto-fit columns..!
Been needing that for a long while (although its not important.. but its nice to have).

Cheers