NC Clone

[danielmaximiliano]

Jimmy:
Download Libxlsxwriter from the GitHub repositories.
install msys64
in windows run CMD

2020-07-09 23_22_52-Libxlsxwriter.png (20.17 KiB) Viewed 4402 times

DLL and .a were generated

2020-07-09 23_32_33-lib.png (4.97 KiB) Viewed 4402 times

libxlsxwriter.rar

(889.57 KiB) Downloaded 223 times

[AUGE_OHR]

hi

DLL and .a were generated

aha ...
i thought it only build LIB

i include LIB and try to compile / link

hbmk2: Compiling...
hbmk2: Linking... HBFM64.exe
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xbb0): undefined reference to `HB_FUN_LXW_INIT'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xbd0): undefined reference to `HB_FUN_LXW_WORKBOOK_NEW'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xbf0): undefined reference to `HB_FUN_LXW_WORKBOOK_ADD_WORKSHEET'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xc10): undefined reference to `HB_FUN_LXW_WORKBOOK_ADD_FORMAT'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xc30): undefined reference to `HB_FUN_LXW_FORMAT_SET_NUM_FORMAT'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xc50): undefined reference to `HB_FUN_LXW_WORKSHEET_WRITE_STRING'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xc70): undefined reference to `HB_FUN_LXW_WORKSHEET_WRITE_NUMBER'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xc90): undefined reference to `HB_FUN_LXW_WORKSHEET_WRITE_BOOLEAN'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xcb0): undefined reference to `HB_FUN_LXW_WORKSHEET_WRITE_DATETIME'
.hbmk/win/mingw64/EXPORT.o:EXPORT.c:(.data+0xcd0): undefined reference to `HB_FUN_LXW_WORKBOOK_CLOSE'
collect2.exe: error: ld returned 1 exit status
hbmk2[HBFM64]: Error: Running linker. 1

we have 64 Bit DLL / LIB but now we need 64 Bit "Wrapper" of hblibxlsxwriter -> libhblibxlsxwriter.a

---

so i try build Wrapper for 64 Bit with Make_Lib.cmd

Generating C source output to 'R:\Temp\hbmk_135yd0.dir\hblibxlsxwriter.c'... Done.
hblibxlsxwriter.prg:4894:25: fatal error: xlsxwriter.h: No such file or directory
...
gcc.exe -c -O3 -W -Wall -pipe -I"C:/hmg.3.4.4/harbour-64/include"

hm ... now i copy all *.h from c:\hmg.3.4.4\1\XLSX\xlsxwriter\ to C:\hmg.3.4.4\harbour-64\include

R:/Temp/hbmk_0ialz8.dir/hblibxlsxwriter.o:hblibxlsxwriter.c:(.data+0x130): undefined reference to `HB_FUN_HB_CSTRUCTURE'

R:/Temp/hbmk_0ialz8.dir/hblibxlsxwriter.o:hblibxlsxwriter.c:(.data+0x1a70): undefined reference to `HB_FUN_HB_CSTRUCTURE
CSYNTAX'
R:/Temp/hbmk_0ialz8.dir/hblibxlsxwriter.o:hblibxlsxwriter.c:(.data+0x1ab0): undefined reference to `HB_FUN___ACTIVESTRUC
TURE'

... hm

[AUGE_OHR]

hi,

i have now include hblibxlsxwriter.prg and CStruct.ch, hbctypes.ch, Wintypes.ch, hblibxlsxwriter.ch into HBFM64

now when try to load libxlsxwriter.dll and look into debugger

Code: Select all

FUNCTION lxw_init() 
nHDll := hb_libLoad( "libxlsxwriter.dll" )
ALTD()
nHDll := HMG_CallDLL( "Kernel32.dll",, "LoadLibrary", "libxlsxwriter.dll" )
RETURN nHDll

both time it is 0

it this a 64 Bit Problem of libxlsxwriter.dll
how to load 64 Bit DLL

[danielmaximiliano]

Hi Jimmy
Look here : http://www.kresin.ru/en/hrbfaq.html
Search hb_libLoad

[danielmaximiliano]

2020-07-10 16_51_02-Window.png (14.81 KiB) Viewed 4151 times

[AUGE_OHR]

hi

try

Code: Select all

del %APPDATA%\HMG\FMSETUP.*

[danielmaximiliano]

Code: Select all

del %APPDATA%\HMG\FMSETUP.*

Run !!!

[AUGE_OHR]

hi,

to "read" XLSx with HBMF64 it need 64 Bit ADO

follow Link but this time download 64 Bit Version.
https://www.microsoft.com/en-us/downloa ... n&id=13255

---

when have 32 Bit Office installed you get a Error when try to install 64 Bit ADO.

https://knowledge.autodesk.com/support/ ... ffice.html

Workaround to install the 64-bit Access Database Engine 2010 on a computer with 32-bit Microsoft Office 2007, 2010, or 2013:

Before you begin, open the Registry Editory (type "regedit" in the Windows search box under the Start menu and select regedit.exe) and check the following registry key for the value "mso.dll" is NOT present in: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths"
This registry key value would be present if Microsoft Office 64-bit was installed on the computer, in which case you should be able to install the 64-bit Access Database Engine without using this workaround.

Workaround:
1. Open the Command Prompt by typing "cmd" in the Windows search box under the Start menu and selecting cmd.exe

2. Type the file path and file name of the 64-bit Access Database Engine 2010 install file, followed by a space and "/passive" (this runs the installation without showing any error messages).

For example:


3. Open the Registry Editor by typing "regedit" in the Windows search box under the Start menu and selecting regedit.exe

4. Delete or rename the "mso.dll" registry value in the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths"

NOTES:
If you do not delete the "mso.dll" registry value, you will get a "Reconfiguring" message every time you open up an Office application.
You will need to use this same workaround to install Service Pack 1 for Access Database Engine 2010 for 64-bit

[AUGE_OHR]

hi

here lates 32 Bit Version 1.07 (64 Bit Version under construction)

HBFM107.zip

(2.12 MiB) Downloaded 305 times

it include FTP (not sFTP)

HBFM107_FTP.jpg (293.25 KiB) Viewed 4839 times

i also use FreeImage.DLL again for Thumbs

FreeImage32.zip

(2.02 MiB) Downloaded 283 times

when display Thumbs you can rotate Image (right-Mouse Menu)

// v.1.07 10.07.2020 include HbFTP (incl 64 Bit)
// v.1.06 07.07.2020 cleanup HB_FUNC for 64 Bit
// v.1.05 01.07.2020 FreeImage -> Thumbs -> Pop-Up Menu -> rotate
// v.1.04 20.06.2020 try using FreeImage.DLL without Import LIB

known Problem :
when call Thumbs 1st Time it fail and display no Thumbs.
FTP :
i have used Extended Version c:\MiniGUI\SAMPLES\Advanced\FtpClient\demo.prg and re-write for HMG
i had a lot of Problem with 2nd GRID which show on right side when connect to FTP Server.
Directory Structure do not match "my" FTP site so i wrote new Version.
so you have to test if it work with "your" FTP site Directory Structure

FTP Client is not full integrate into HBFM. it does not work in Thread yet.

have fun

[AUGE_OHR]

hi,

when install ADO ActiveX you might get missing VCOMP1xx.DLL

it are Runtime DLL from Visual C++ Redistributable for Visual Studio
https://www.microsoft.com/de-DE/downloa ... x?id=48145