Wrapper for LIBXL libxlsxwriter.dll for Harbour

Issues and Discussions related to Harbour

Moderator: Rathinagiri

Tiger
Posts: 64
Joined: Mon Aug 31, 2015 11:28 am
Location: Taipei
Has thanked: 16 times
Been thanked: 16 times

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: 1170
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 256 times
Been thanked: 145 times

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: 64
Joined: Mon Aug 31, 2015 11:28 am
Location: Taipei
Has thanked: 16 times
Been thanked: 16 times

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: 217
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF
Has thanked: 99 times
Been thanked: 12 times

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: 1018
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 167 times
Been thanked: 284 times

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: 3396
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 267 times
Been thanked: 170 times
Contact:

Post by mol »

Copy all files to your project folder and then try to compile it

RPC
Posts: 217
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF
Has thanked: 99 times
Been thanked: 12 times

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: 1018
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 167 times
Been thanked: 284 times

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: 217
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF
Has thanked: 99 times
Been thanked: 12 times

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: 1170
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 256 times
Been thanked: 145 times

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