Page 1 of 1
xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Mon Dec 09, 2019 6:39 pm
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.
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Mon Dec 09, 2019 7:52 pm
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"
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Tue Dec 10, 2019 9:46 am
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
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Tue Dec 10, 2019 10:22 am
by bpd2000
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Tue Dec 10, 2019 8:35 pm
by AUGE_OHR
hi,
Also visit for XLSXClass.prg
ok, thx
... seems i need to use Extendet Version to reach next level
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Wed Dec 11, 2019 5:27 pm
by jparada
Hi,
Here is the xlsxwriter wrapper for Harbour
https://github.com/riztan/hbxlsxwriter
Regards,
Javier
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Wed Dec 11, 2019 9:38 pm
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?
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Wed Dec 11, 2019 10:45 pm
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
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Thu Dec 12, 2019 3:22 pm
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.
Re: xlmwrtiter for create standalone XLSX files without Excel/Openoffice installed
Posted: Tue Feb 27, 2024 7:42 am
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