[ANN] MS Excel Library 1.1 - First commands about Pivot Tables and More

zryip theSlug zryip.theslug at gmail.com
Sun Feb 2 16:48:51 EST 2014


Dear LiveCode and MS Excel Users,


The Excel Library 1.1 is now available for our Registred Users.


What we have for you in this version?


1. Pivot Table commands

As announced in a previous RevUp article, we have added our first
commands for supporting the MS Excel's Pivot Table object.
In this version we have 7 commands and 1 function for controlling the
Pivot Table object:

- XCEL_PivotTable_New: creates a new Pivot Table
- XCEL_PivotTable_Exists: returns true if the Pivot Table exists
- XCEL_PivotTable_Delete: deletes a Pivot Table
- XCEL_PivotTable_Refresh: refreshes a Pivot Table
- XCEL_PivotTable_Style_Set: defines the style of the Pivot Table report
- XCEL_PivotTable_Fld_Define: defines a Pivot Table field category
among the following categories: filter, row, column or value
- XCEL_PivotTable_Fld_Position_Set: defines the order of a Pivot Table
field among a category
- XCEL_PivotTable_Item_Visible_Set: shows or hides a Pivot Table item
in a category

All these commands are described in the Library documentation. Plus, a
dedicated section allows to experiment the main new commands.
http://www.aslugontheroad.com/images/Preview/Excel_Lib_Preview/pivottable_doc_preview.png


2 Two new functions are also available:

- XCEL_Worbook_Exists
- XCEL_Sheet_Exists


3. And two bugs have been fixed:

- A bug with commands using 2 similar kinds of object (2 ranges, 2
sheets, etc). The second object was using the same definition than the
first object. Example with 2 ranges: if the first range was defined to
be in sheet 1 and a second range was defined to be in sheet 2, the
second range was declared to be in sheet 1 (the sheet defined for the
first range).
- XCEL_Sheet_New (Macintosh) is now returning the new sheet name without quotes.


The Commercial version of the Library contains now more than 190
commands compatible with Windows and Macintosh. All the vocabulary is
fully detailed in the Library Documentation.


If you want to support the development and have interest in the
Library, please consider to purchase the Commercial version in the
LiveCode Store:
http://livecode.com/store/marketplace/excel-library


Depending of the number of copies sold, we will decide to explore the
possibility of a MS Word and MS Powerpoint library.



As we have nothing to hide, the Open Source version 1.0 of our Library
is still available in our webiste under GPL license, by following this
link:
http://www.aslugontheroad.com/download/category/5-open-sources

You can freely evaluate our work and / or use the library in your
non-commercial projects.



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




More information about the use-livecode mailing list