Wrapper for LIBXL libxlsxwriter.dll for Harbour
Moderator: Rathinagiri
Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour
Hi bpd2000
Thanks
Changed as you suggested. It compiles now and I get libxlw.exe but what does it do ?
Should I compile demo.prg in example subdir ,but then what files need to be added to modules tab in IDE besides demo.prg,
There are many *.prg files in examples subdir.
Pls advice.
Thanks
Thanks
Changed as you suggested. It compiles now and I get libxlw.exe but what does it do ?
Should I compile demo.prg in example subdir ,but then what files need to be added to modules tab in IDE besides demo.prg,
There are many *.prg files in examples subdir.
Pls advice.
Thanks
Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour
HiRPC wrote: ↑Thu Apr 16, 2020 5:44 pm Hi bpd2000
Thanks
Changed as you suggested. It compiles now and I get libxlw.exe but what does it do ?
Should I compile demo.prg in example subdir ,but then what files need to be added to modules tab in IDE besides demo.prg,
There are many *.prg files in examples subdir.
Pls advice.
Thanks
1. This wrapper and examples are for Harbour [no gui]
2. Download Attached working folder [posted as on 11/04/2020 page-1]
3. Unzip to C drive [i.e C:\hblibxlsxwriter]
4. set required path for harbour and mingw compiler
5. open cmd window at C:\hblibxlsxwriter and run make_lib.cmd [it will create libhblibxlsxwriter.a library]
5. open cmd window at C:\hblibxlsxwriter\example and run test.cmd [it will create demo.exe]
6. now run demo.exe from cmd window [it will create demo.xlsx silently in the same folder]
If you success, then study the code, .hbp files etc. and start incorporating in HMG
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour
Hi bpd2000
Thanks for step by step guide.
I have come upto step 5 and get following error
C:\hblibxlsxwriter>hbmk2 libxlw.hbp
Harbour 3.2.0dev (r1703241902)
Copyright (c) 1999-2016, http://harbour-project.org/
Compiling 'hblibxlsxwriter.prg'...
Lines 5520, Functions/Procedures 171
Generating C source output to 'C:\Users\rpcch\AppData\Local\Temp\hbmk_conllm.dir\hblibxlsxwriter.c'... Done.
C:/Users/rpcch/AppData/Local/Temp/hbmk_conllm.dir/hblibxlsxwriter.o:hblibxlsxwriter.c:(.data+0xa8): undefined reference to `HB_FUN_HB_CSTRUCTURE'
C:/Users/rpcch/AppData/Local/Temp/hbmk_conllm.dir/hblibxlsxwriter.o:hblibxlsxwriter.c:(.data+0xd48): undefined reference to `HB_FUN_HB_CSTRUCTURECSYNTAX'
C:/Users/rpcch/AppData/Local/Temp/hbmk_conllm.dir/hblibxlsxwriter.o:hblibxlsxwriter.c:(.data+0xd68): undefined reference to `HB_FUN___ACTIVESTRUCTURE'
collect2.exe: error: ld returned 1 exit status
hbmk2[libxlw]: Error: Running linker. 1
gcc.exe C:/Users/rpcch/AppData/Local/Temp/hbmk_conllm.dir/hblibxlsxwriter.o C:/Users/rpcch/AppData/Local/Temp/hbmk_conllm.dir/hbmk_nod7j8.o -mconsole -Wl,--start-group -lhbextern -lhbdebug -lhbvm -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainstd -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -ohblibxlsxwriter.exe -Lc:/hmg.3.4.4/harbour/lib/win/mingw
hbmk2: Hint: Add option 'xhb.hbc' for missing function(s): __ActiveStructure(),
hb_CStructureCSyntax(), hb_CStructure()
It is asking to 'Add option xhp.hbc' how to do that ?
Please help
Thanks
Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour
use command as
hbmk2 libxlw.hbp xhb.hbc
or add xhb.hbc in make_lib.cmd
hbmk2 libxlw.hbp xhb.hbc
or add xhb.hbc in make_lib.cmd
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
Re: Wrapper for LIBXL libxlsxwriter.dll for Harbour
Follow this for HMG32
1. Copy hblibxlsxwriter.ch to c:\hmg\include
2. Copy libhblibxlsxwriter.a to c:\hmg\lib
3. add libs=hblibxlsxwriter at line no 52 of hmg32.hbc
4. now build example [c:\hmg\build demo.prg]
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
- AUGE_OHR
- Posts: 2061
- 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
hi,
i try to get libxlsxwriter.DLL 64 Bit, from Daniel (https://www.hmgforum.com/viewtopic.php? ... 5&start=62 ), running with Wrapper hblibxlsxwriter
https://github.com/FTrautwein/hblibxlsxwriter
i have done that way successful for 32 bit
i was able to create 64 Bit LIB of Wrapper but nothing happens ... no *.XLSx create
so i look into hblibxlsxwriter.PRG
i have modify Code to "RETURN nHDll" but under 64 Bit i got "U" ... hm
i also try "old Style"
but i got 0 under 64 Bit
hb_libLoad() / HMG_CallDLL(... "LoadLibrary") work with other DLL (32 Bit) so i´m not sure what the Problem is.
---
attach Source i use to build under 32 / 64 Bit change into \xlsxwriter and copy all *.h include xlsxwriter\third_party to c:\hmg.3.4.4\HARBOUR-64\include\
now try run Make_Lib.cmd
if Environment does not have Path to Compilier / Linker start
and than again Make_Lib.cmd
now, i hope, you got libhblibxlsxwriter.a
copy it to c:\hmg.3.4.4\LIB-64\
now try to create *.XLSx
use Source from \DEMO
no *.XLSx are create under 64 Bit ...
i try to get libxlsxwriter.DLL 64 Bit, from Daniel (https://www.hmgforum.com/viewtopic.php? ... 5&start=62 ), running with Wrapper hblibxlsxwriter
https://github.com/FTrautwein/hblibxlsxwriter
i have done that way successful for 32 bit
i was able to create 64 Bit LIB of Wrapper but nothing happens ... no *.XLSx create
so i look into hblibxlsxwriter.PRG
Code: Select all
FUNCTION lxw_init()
nHDll:= hb_libLoad( "libxlsxwriter.dll" )
*RETURN NIL
RETURN nHDll
i also try "old Style"
Code: Select all
nHDll := HMG_CallDLL( "Kernel32.dll",, "LoadLibrary", "libxlsxwriter.dll" )
hb_libLoad() / HMG_CallDLL(... "LoadLibrary") work with other DLL (32 Bit) so i´m not sure what the Problem is.
---
attach Source i use to build under 32 / 64 Bit change into \xlsxwriter and copy all *.h include xlsxwriter\third_party to c:\hmg.3.4.4\HARBOUR-64\include\
now try run Make_Lib.cmd
if Environment does not have Path to Compilier / Linker start
Code: Select all
c:\hmg.3.4.4\build64.bat
now, i hope, you got libhblibxlsxwriter.a
copy it to c:\hmg.3.4.4\LIB-64\
now try to create *.XLSx
use Source from \DEMO
no *.XLSx are create under 64 Bit ...
have fun
Jimmy
Jimmy
- AUGE_OHR
- Posts: 2061
- 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
hi,
did some get Wrapper hblibxlsxwriter under 64 Bit running
did some get Wrapper hblibxlsxwriter under 64 Bit running
have fun
Jimmy
Jimmy