xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Source code related resources

Moderator: Rathinagiri

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

xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Post by juanato » Mon Dec 09, 2019 6:39 pm

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

Post by AUGE_OHR » Mon Dec 09, 2019 7:52 pm

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: 450
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF
Has thanked: 154 times
Been thanked: 62 times

Post by Anand » Tue Dec 10, 2019 9:46 am

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

Post by bpd2000 » Tue Dec 10, 2019 10:22 am

BPD
Convert Dream into Reality through HMG

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

Post by AUGE_OHR » Tue Dec 10, 2019 8:35 pm

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: 294
Joined: Fri Jan 23, 2009 5:18 pm
Been thanked: 4 times

Post by jparada » Wed Dec 11, 2019 5:27 pm

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

Regards,
Javier

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

Post by mol » 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?

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

Post by jparada » Wed Dec 11, 2019 10:45 pm

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: 54 times
Been thanked: 33 times
Contact:

Post by apais » Thu Dec 12, 2019 3:22 pm

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