PureBasic Forums - English

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

1. Won't happen.
2. Maybe will happen.

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.

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?

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

+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.