[ANN] Excel Library 1.3.3 - A new command for creating a Pivot Table from SQL and more.

[zryip theSlug]

Dear LiveCode Users,

The Excel Library 1.3.3 Commercial Version is released!


In this version we have:


6 new commands and 1 new function

- XCEL_Sheet_Visible_Set: sets the visibility of a worksheet.
- XCEL_Sheet_Visible_Get
- XCEL_PivotTable_New_FromSQL: creates a new Pivot Table linked to a
SQL query (Windows only)
- XCEL_PivotTable_Slicer_New: creates a new slicer for a Pivot Table
(Windows only)
- XCEL_PivotTable_Slicer_Activate: activates or deactives a slicer
item. (Windows only)
- XCEL_PivotTable_Slicer_Style_Set: sets the slicer style (color).
(Windows only)
- XCEL_PivotTable_Slicer_Delete: deletes a slicer. (Windows only)


Slicers are Pivot table filters introduced in MS Excel 2010.
Infortunatly the slicer object is not existing in MS Excel for Mac.


And a fix:

Command XCEL_Range_Values_Set for Windows is now properly working if
the data to inject in a range is containing quotes.


These new commands and functions are directly resulting from Excel Lib
owners requests.


The Excel Lib requires a copy of MS Excel installed on the computer for working.


You can download the open source version of the Lib (version 1.0.1) by
following this link:
http://www.aslugontheroad.com/download/category/5-open-sources

You can purchase a copy of the Excel Lib commercial version in your
favorite store:
https://livecode.com/store/marketplace/excel-library



Best Regards,
-- 
Zryip TheSlug
http://www.aslugontheroad.com