xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Source code related resources

Moderator: Rathinagiri

Post Reply
juanato
Posts: 20
Joined: Fri Sep 21, 2012 2:42 pm

xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Post by juanato »

Hello.

I would appreciate some help to use xmlwriter in HMG. The default demo included in HMG 3.4.4 cannot be compiled in my project... has some people a better .hbp project to see how ? Thanks.

User avatar
AUGE_OHR
Posts: 660
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 85 times
Been thanked: 161 times

Post by AUGE_OHR »

hi,
juanato wrote:
Mon Dec 09, 2019 6:39 pm
The default demo included in HMG 3.4.4 cannot be compiled in my project...
can you please tell me which Sample you try ... i can't find "xlmwriter"
have fun
Jimmy

User avatar
Anand
Posts: 458
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF
Has thanked: 160 times
Been thanked: 63 times

Post by Anand »

I think juanato means this library,
http://libxlsxwriter.github.io/
whose sample is in MiniGUI Extended
c:\MiniGUI\SAMPLES\Advanced\HbXlsxWriter\

Regards,

Anand
Image

User avatar
bpd2000
Posts: 1124
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 224 times
Been thanked: 116 times

Post by bpd2000 »

BPD
Convert Dream into Reality through HMG

User avatar
AUGE_OHR
Posts: 660
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 85 times
Been thanked: 161 times

Post by AUGE_OHR »

hi,
I think juanato means this library,
http://libxlsxwriter.github.io/
whose sample is in MiniGUI Extended
c:\MiniGUI\SAMPLES\Advanced\HbXlsxWriter\
Also visit for XLSXClass.prg
ok, thx
... seems i need to use Extendet Version to reach next level
have fun
Jimmy

jparada
Posts: 298
Joined: Fri Jan 23, 2009 5:18 pm
Been thanked: 5 times

Post by jparada »

Hi,
Here is the xlsxwriter wrapper for Harbour
https://github.com/riztan/hbxlsxwriter

Regards,
Javier

User avatar
mol
Posts: 3273
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 240 times
Been thanked: 143 times
Contact:

Post by mol »

About year ago I had a problem with this solution - excel files created with this library had caused excel crashes - I'm wondering if it works ok now, but, I don't have any excel installed in my machines.
Someone can test it?

jparada
Posts: 298
Joined: Fri Jan 23, 2009 5:18 pm
Been thanked: 5 times

Post by jparada »

mol wrote:
Wed Dec 11, 2019 9:38 pm
About year ago I had a problem with this solution - excel files created with this library had caused excel crashes - I'm wondering if it works ok now, but, I don't have any excel installed in my machines.
Someone can test it?
Hi Marek,
Which of them?, there are two different libs,
hbxlsxml are wrappers of Fausto at https://github.com/FTrautwein/hbxlsxml
hbxlsxwriter are wrappers of Riztan at https://github.com/riztan/hbxlsxwriter

I can personally confirm that hbxlsxml works correctly (create xml files
fully compatible with Excel), I have been deeply this lib making reports.

On the other hand, I have not tested much hbxlsxwriter, but I also confirm that it works, in fact it creates real Excel xlsx files and the file sizes are much smaller compared to those created by hbxlsxml.

Regards,
Javier

User avatar
apais
Posts: 324
Joined: Fri Aug 01, 2008 6:03 pm
Location: uruguay
Has thanked: 55 times
Been thanked: 33 times
Contact:

Post by apais »

I use Fausto's library in Alaska xbase++ without problems since a couple years on excel, libeoffice, wps office
Not tested on HMG though.

Post Reply