Hi,

   Any people knows a Library to read XLS File directly ?

   Today I use activeX but it requires customer to have Office installed..

   Any people knows who has this component ?

   Or a example using ODBC to do this ?

   Thanks,
   Osvaldo

HI,
SqlExpress of Boris Borzic works fine but if you need to create xlsx file, 
this can be done with ActiveX and then try the sheet with SqlExpress.
This is thw url where you can found it : http://www.sqlexpress.net/menu.htm
Regards.
César.

"Osvaldo Luis Aoki" escribió en el mensaje de 
noticias:572944a3$63bb18bb$2304b@news.alaska-software.com...

Hi,

   Any people knows a Library to read XLS File directly ?

   Today I use activeX but it requires customer to have Office installed..

   Any people knows who has this component ?

   Or a example using ODBC to do this ?

   Thanks,
   Osvaldo

http://www.familie-brandel.de/dateien/dat_index_e.html



"Osvaldo Luis Aoki" escreveu na mensagem 
news:572944a3$63bb18bb$2304b@news.alaska-software.com...

Hi,

   Any people knows a Library to read XLS File directly ?

   Today I use activeX but it requires customer to have Office installed..

   Any people knows who has this component ?

   Or a example using ODBC to do this ?

   Thanks,
   Osvaldo

Hi,

  I just find a good Lib to read and write Excel file.

  Look for site:   www.libxl.com

  I already test it, and works fine !

  I recomend it.


  Thanks,
  Osvaldo



Osvaldo Luis Aoki wrote in message 
news:572944a3$63bb18bb$2304b@news.alaska-software.com...
>Hi,
>
>   Any people knows a Library to read XLS File directly ?
>
>   Today I use activeX but it requires customer to have Office 
installed..
>
>   Any people knows who has this component ?
>
>   Or a example using ODBC to do this ?
>
>   Thanks,
>   Osvaldo

Am 11.05.2015 um 15:21 schrieb "Osvaldo Luis Aoki":
> Hi,
>
>    I just find a good Lib to read and write Excel file.
>
>    Look for site:   www.libxl.com
>
>    I already test it, and works fine !
>
>    I recomend it.

I have written a class to use this dll,
you can find it on pablos site (it needs ot4xb)...

regards
Hubert

its there:

http://www.xbwin.com/forum.html
=> xfree.resources
=> HBLibXL and HBPrintPDF - new versions released

Version 3.5.4 (2014-01-10): added xltx and xltm file support
Version 3.6.0 (2014-07-14): added a possibility to create xltx and xlsm 
files

my class does not support this by now, i will add this if needed

Osvaldo,

>   I just find a good Lib to read and write Excel file.
> 
>   Look for site:   www.libxl.com
> 
>   I already test it, and works fine !

Could you post some code you used to test this lib?

Thanks,
Peter

there are examples in my code ... using ot4xb to access LibXL.dll

http://www.familie-brandel.de/dateien/dat_index_e.html
http://www.familie-brandel.de/dateien/HBLibXL-Xbase-ClassCode-1.01.zip

Hubert,

> there are examples in my code ... using ot4xb to access LibXL.dll
> 
> http://www.familie-brandel.de/dateien/dat_index_e.html
> http://www.familie-brandel.de/dateien/HBLibXL-Xbase-ClassCode-1.01.zip

I noticed I had already downloaded these examples a couple of days ago. 
Just didn't have the time to look at it yet.

Thanks,
Peter

Hi Peter,

  It is easy to use, because it already have integration with ALASKA 
XBASE, you only need to link Pablo library Ot4xb.lib.

  Look for some commands below:

      oBook := xlCreateBook( clName, clKey )
      lOK:= oBook:BookLoad( cFile )
      oBook:BooksetActiveSheet( nSheet )
      xVal:= oSheet:SheetReadStr( nLin, nCol )
      oBook:Bookrelease()




Peter Alderliesten wrote in message 
news:1bun90ziuyrj7.yongt295rlau.dlg@40tude.net...
>Osvaldo,
>
>>   I just find a good Lib to read and write Excel file.
>> 
>>   Look for site:   www.libxl.com
>> 
>>   I already test it, and works fine !
>
>Could you post some code you used to test this lib?
>
>Thanks,
>Peter