Page 2 of 3

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Sat Apr 11, 2020 9:18 am
by Tiger
Hi BPD,
Do you have the libxlsxwriter.dll (64 bit) ?? Thanks.

And I found,it can be compiled with HMG IDE wirh following steps:

1. copy libhblibxlsxwriter.a to \hmg.3.4.4\HARBOUR\lib\win\mingw
2. copy hblibxlsxwriter.ch to \hmg.3.4.4\HARBOUR\include
3. copy libxlsxwriter.dll to the folder of demo.prg
4. add libs=hblibxlsxwriter to demo.hbc
5. add demo.prg to demo.hbp

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Sat Apr 11, 2020 4:11 pm
by bpd2000
Tiger wrote: Sat Apr 11, 2020 9:18 am Hi BPD,
Do you have the libxlsxwriter.dll (64 bit) ?? Thanks.
My OS is win-10 64 bit
I am not facing any problem with 32 bit libxlsxwriter.dll

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Sun Apr 12, 2020 3:48 am
by Tiger
Thanks. Yes, I also can run it with my win10 64.

Because I can't use ole to insert a chart to excel workshhet, I try to use this tool to do it and I just try to complie it with HMG 64.

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Wed Apr 15, 2020 9:38 am
by RPC
Hi bpd2000
bpd2000 wrote: Sat Apr 11, 2020 8:27 am set required path for harbour and mingw compiler
go example and run test.cmd
Can you please tell where to set required path ?
On compiling libxlw.hbp I am getting error 'can't open #include file CStruch.ch'

Pls help
Thanks

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Wed Apr 15, 2020 10:10 am
by AUGE_OHR
RPC wrote: Wed Apr 15, 2020 9:38 am On compiling libxlw.hbp I am getting error 'can't open #include file CStruch.ch'
have you download required_ch_files.rar from 1st Page of this Thread ...

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Wed Apr 15, 2020 11:45 am
by mol
Copy all files to your project folder and then try to compile it

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Thu Apr 16, 2020 7:05 am
by RPC
Hi
@Jimmy - Yes I have downloaded all files and have stored *.ch files at place mentioned in 1st page.
@mol - I have copied all *.ch files also at project folder.
Now I get blank error message box with "Error List" written on top portion of box and nothing else.
Thanks to both of you

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Thu Apr 16, 2020 7:38 am
by AUGE_OHR
hi,
RPC wrote: Thu Apr 16, 2020 7:05 am Now I get blank error message box with "Error List" written on top portion of box and nothing else.
look into your Build.log for more Information

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Thu Apr 16, 2020 2:57 pm
by RPC
AUGE_OHR wrote: Thu Apr 16, 2020 7:38 am look into your Build.log for more Information
H jimmy
This is my build.log

Harbour 3.2.0dev (r1703241902)
Copyright (c) 1999-2016, http://harbour-project.org/
C:\hblibxlsxwriter\hblibxlsxwriter.prg:4893:75: fatal error: C:\Users\Apollo1\Downloads\hblibxlsxwriter-master\xlsxwriter.h: No such file or directory
compilation terminated.
hbmk2[libxlw]: Error: Running C/C++ compiler. 1
gcc.exe -c -O3 -march=i586 -mtune=pentiumpro -fomit-frame-pointer -W -Wall -pipe -IC:/hmg.3.4.4/harbour/include -I../../../../../../hblibxlsxwriter -IC:/hmg.3.4.4/include C:/Users/rpcch/AppData/Local/Temp/hbmk_2q9p6b.dir/hblibxlsxwriter.c C:/Users/rpcch/AppData/Local/Temp/hbmk_5ngmnn.c


Apollo1 subdir mentioned on third line is not my subdir. What subdir should I mention there ?
Thanks

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Posted: Thu Apr 16, 2020 3:11 pm
by bpd2000
RPC wrote: Thu Apr 16, 2020 2:57 pm
AUGE_OHR wrote: Thu Apr 16, 2020 7:38 am look into your Build.log for more Information
H jimmy
This is my build.log

Harbour 3.2.0dev (r1703241902)
Copyright (c) 1999-2016, http://harbour-project.org/
C:\hblibxlsxwriter\hblibxlsxwriter.prg:4893:75: fatal error: C:\Users\Apollo1\Downloads\hblibxlsxwriter-master\xlsxwriter.h: No such file or directory
compilation terminated.
hbmk2[libxlw]: Error: Running C/C++ compiler. 1
gcc.exe -c -O3 -march=i586 -mtune=pentiumpro -fomit-frame-pointer -W -Wall -pipe -IC:/hmg.3.4.4/harbour/include -I../../../../../../hblibxlsxwriter -IC:/hmg.3.4.4/include C:/Users/rpcch/AppData/Local/Temp/hbmk_2q9p6b.dir/hblibxlsxwriter.c C:/Users/rpcch/AppData/Local/Temp/hbmk_5ngmnn.c


Apollo1 subdir mentioned on third line is not my subdir. What subdir should I mention there ?
Thanks
Replace line no 4893 of hblibxlsxwriter.prg as #include "xlsxwriter.h"