excel from harbour

[momo]

Dear friends, I need read a excel file from harbour, can you help me??
TIA
Oscar

[Jan Sperling]

Hi Momo:

 

I´m using LIBXL (www.libxl.com).

 

You can read and write XLS files.

Has many features, and  works very well for me.

It's not shareware, you need to buy it.

 

For Harbour, you can access it via DLL or write your own C functions, accesing the LIB.

 

Hope this helps,

 

Jan

[Massimo Belgrano]

Hi oscar

 you can using ole in hbwin
please read   C:\harbour\contrib\hbwin\tests\testole.prg 

you can do untested
oExcel := win_oleCREATEOBJECT( "Excel.Application" )
oExcel:Open()

 oAS := oExcel:ActiveSheet()

 ?    oAS:Cells( 1, 1 ):Value 

oExcel:Close()

please post here your final sample

2010/11/12 momo <o...@bvconline.com.ar>

>
> Dear friends, I need read a excel file from harbour, can you help me??
> TIA
> Oscar

--
Massimo Belgrano

[Qatan]

Hello Oscar,

Try to compile and execute the testole.prg example that is under
contrib\hbwin\tests folder.
I use it and it works.

Qatan

> --
> You received this message because you are subscribed to the Google
> Groups "Harbour Users" group.
> Unsubscribe: harbour-user...@googlegroups.com
> Web: http://groups.google.com/group/harbour-users

[Bopdji Shah]

I have need to use Excel to compose a table which is part English and part Indic language composed using Google tranliteration (IME) facilities.
I now want to bring it under Harbour/xHarbour as a .dbf file as a Unicode file.
What else do I need to do?
Many thanks in advance

Bopdji

[Karl]

Hi All,

I know it is a old question but it took me a while to figure it out, so the proper syntax may help others in future:

   IF ( oExcel := win_oleCreateObject( "Excel.Application" ) ) != NIL

     oWorkBook := oExcel:WorkBooks:open( "c:/MyProg/foo.xls")

     oAS := oExcel:ActiveSheet()

     ?    oAS:Cells( 1, 1 ):Value 

     oExcel:WorkBooks:Close()

     oExcel:Quit()

   endif

Happy Hacking

 Karl

 

PS: Sorry if there is 2 postings, the close part was still wrong.  Is correct now. 

[Qatan]

Hello Karl,

 

Thanks for sharing. It’s always useful.

 

Qatan

 

[Dragan Cizmarevic]

This is the actual question, use existing Excel table

Do you have a solution for Open Office Calc table?

[Karl]

Hi Dragan,

sorry I don't. As of now the customers have been asking for M$ Excel only. 

Maybe someone else can jump in?

BR
 Karl

[Jarosław Kądzioła]

W dniu 2014-01-28 07:45, Dragan Cizmarevic pisze:

> This is the actual question, use existing Excel table
>
> Do you have a solution for Open Office Calc table?
>

see here :

\harbour\contrib\hbwin\tests\testole.prg

--
Regards
Jarosław Kadziola

[Nenad Batocanin]

Yes. I made a simple class that supports both Excel and Calc. For instance:

 

oDoc := OLE_Calc ("OO", "test")      // or OLE_Calc ("MS", "test")

x := oDoc:GetCell ("A1")

oDoc:PutCell ("A7", 123)

oDoc:PutCellXY (1, 1, "Some value")

oDoc:CloseTable()

 

regards, NB

--

--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-user...@googlegroups.com
Web: http://groups.google.com/group/harbour-users
 

---

You received this message because you are subscribed to the Google Groups "Harbour Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[amnaples]

Very good.........but Nenad.ch ??
Rgds
Arcangelo

[Nenad Batocanin]

Sorry, here's the correct version.

 

Regards, NB

[e.sf]

Hi Nenad,

 

How Do You Get Value Date and Timestamps from oo calc cell

 

.and.

 

if you see my other post, you can add OO methods GetUsedArea and Set/GetDataArray(i,j,x,y) tested ok

In Fact in LibreOffice, not verified in OO

 

from https://wiki.documentfoundation.org/Macros/Calc/fr

 

ESF