Wrapper for LIBXL libxlsxwriter.dll for Harbour

Issues and Discussions related to Harbour

Moderator: Rathinagiri

Tiger
Posts: 70
Joined: Mon Aug 31, 2015 11:28 am
Location: Taipei

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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
BPD
Convert Dream into Reality through HMG
Tiger
Posts: 70
Joined: Mon Aug 31, 2015 11:28 am
Location: Taipei

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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.
RPC
Posts: 285
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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
User avatar
AUGE_OHR
Posts: 2062
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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 ...
have fun
Jimmy
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post by mol »

Copy all files to your project folder and then try to compile it
RPC
Posts: 285
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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
User avatar
AUGE_OHR
Posts: 2062
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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
have fun
Jimmy
RPC
Posts: 285
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour

Post 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"
BPD
Convert Dream into Reality through HMG
Post Reply