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

zryip theSlug zryip.theslug at gmail.com
Thu Oct 9 18:10:13 EDT 2014

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:

You can purchase a copy of the Excel Lib commercial version in your
favorite store:

Best Regards,
Zryip TheSlug

More information about the use-livecode mailing list