Access to excel files natively & password zip file

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
al2791
User
User
Posts: 17
Joined: Mon Oct 23, 2017 7:28 am

Access to excel files natively & password zip file

Post by al2791 »

Evolution request :

1/ Provide access to excel files natively (creation/change/read - workbook and sheets)

2/ Possibility to create zip files with a password

Thanks
User avatar
jacdelad
Addict
Addict
Posts: 1432
Joined: Wed Feb 03, 2021 12:46 pm
Location: Planet Riesa
Contact:

Re: Access to excel files natively & password zip file

Post by jacdelad »

1. Won't happen.
2. Maybe will happen.
PureBasic 6.04/XProfan X4a/Embarcadero RAD Studio 11/Perl 5.2/Python 3.10
Windows 11/Ryzen 5800X/32GB RAM/Radeon 7770 OC/3TB SSD/11TB HDD
Synology DS1821+/36GB RAM/130TB
Synology DS920+/20GB RAM/54TB
Synology DS916+ii/8GB RAM/12TB
BarryG
Addict
Addict
Posts: 3292
Joined: Thu Apr 18, 2019 8:17 am

Re: Access to excel files natively & password zip file

Post by BarryG »

Supporting Excel: This is too specific a request. It's not PureBasic's job to work with other third-party software, because then it becomes a popularity contest of which other software to include, and also brings the problem of PureBasic constantly having to keep up to date with that other software. Having said that, COMatePLUS can access Excel fields (see viewtopic.php?f=14&t=37214 and viewtopic.php?t=79147).

Password support for zip files is a long-requested feature. I too wish it would be implemented.
User avatar
blueb
Addict
Addict
Posts: 1041
Joined: Sat Apr 26, 2003 2:15 pm
Location: Cuernavaca, Mexico

Re: Access to excel files natively & password zip file

Post by blueb »

Supporting Excel... It's not a crazy request.

Here's a quote from 2021...

"There are 750 million to 2 billion people in the world who use either Google Sheets or Excel. Google Suite, which includes Google Sheets is used by approximately 2 billion users every month, while Microsoft Excel has an estimated 750 million to 1.2 billion monthly users globally."

Almost everyone in the world uses these products on a daily basis...I would think PureBasic might gain a lot of traction, if it provided even the most basic functions for Excel and Sheets.

Something to think about. :)

PS - Isn't an .XLSM file just a fancy .XLM format?
- It was too lonely at the top.

System : PB 6.10 Beta 9 (x64) and Win Pro 11 (x64)
Hardware: AMD Ryzen 9 5900X w/64 gigs Ram, AMD RX 6950 XT Graphics w/16gigs Mem
swhite
Enthusiast
Enthusiast
Posts: 726
Joined: Thu May 21, 2009 6:56 pm

Re: Access to excel files natively & password zip file

Post by swhite »

Hi

I create XMLSS files which can be opened in Excel. So it is a simple matter to create XML files that Excel can consume.

Simon
Simon White
dCipher Computing
Marc56us
Addict
Addict
Posts: 1477
Joined: Sat Feb 08, 2014 3:26 pm

Re: Access to excel files natively & password zip file

Post by Marc56us »

+1
For native functions (at least for the xlsx format (Excel >= 2007)) because generating XML is not easy at all (there are no examples of these functions in the PB help (apart from a general example)).
xlsx format widely used for statistics and automatic reports.
:wink:
Post Reply