xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Source code related resources

Moderator: Rathinagiri

Post Reply
juanato
Posts: 44
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: 2060
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

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: 595
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

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
Regards,

Anand

Image
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Post by bpd2000 »

BPD
Convert Dream into Reality through HMG
User avatar
AUGE_OHR
Posts: 2060
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

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: 430
Joined: Fri Jan 23, 2009 5:18 pm

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Post by jparada »

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

Regards,
Javier
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

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: 430
Joined: Fri Jan 23, 2009 5:18 pm

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

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: 440
Joined: Fri Aug 01, 2008 6:03 pm
DBs Used: DBF
Location: uruguay
Contact:

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

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.
Angel Pais
Web Apps consultant/architect/developer.
HW_apache (webserver modules) co-developer.
HbTron (Html GUI for harbour desktop hybrid apps) co-developer.
https://www.hbtron.com
Georg_BA
Posts: 106
Joined: Fri Apr 07, 2017 5:31 pm
DBs Used: DBF

Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed

Post by Georg_BA »

Hello everyone
Does anyone use XLSX Class - Harbor XLSX library by Srdjan Dragojlovic?
https://groups.google.com/g/harbour-users/c/OtxRtLzf_1E
I would need help setting the column width.
By default, all columns have the same width. Is it possible to change it?
Thanks for help.

Georg
Post Reply