The Excel Library for scripting Excel with LiveCode is now released. It is now time to improve the library with new updates. Updates will be available for all users who have purchased the Library.
Here is the list of new additions for the Library.
Current available Open Source Version is 1.0.1
Current available Commercial Version is 1.2
Name | Description | Mac statut | Windows statut | Documented | Version |
Usage of RGB colors | |||||
XCEL_Range_InteriorColorRGB_Get |
Returns the interior color of a range in RGB | Done | Done | Done | 1.0.1 |
XCEL_Range_InteriorColorRGB_Set |
Sets the interior color of a range in RGB | Done | Done | Done | 1.0.1 |
XCEL_Range_BorderColorRGB_Get |
Returns the border color of a range in RGB | Done | Done | Done |
1.0.1 |
XCEL_Range_BorderColorRGB_Set |
Sets the border color of a range in RGB | Done | Done | Done | 1.0.1 |
Returns the RGB color of a font | Done | Done | Done | 1.0.1 | |
XCEL_Range_FontColorRGB_Set |
Sets the RGB color of a font | Done | Done | Done | 1.0.1 |
XCEL_Range_InteriorPatternColorRGB_Get |
Returns the interior pattern RGB color of a range | Done | Done | Done | 1.0.1 |
XCEL_Range_InteriorPatternColorRGB_Set |
Sets the interior pattern RGB color of a range | Done | Done | Done | 1.0.1 |
Pivot Table commands and functions | |||||
XCEL_PivotTable_New | Adds a new pivot table in a worksheet linked to a range which contain data | Done | Done | Done |
1.1 |
XCEL_PivotTable_Fld_Define | Sets a pivot field to an orientation in the pivot table: row, column, page or data | Done | Done | Done | 1.1 |
XCEL_PivotTable_Delete | Deletes the referenced pivot table | Done | Done | Done | 1.1 |
XCEL_PivotTable_Style_Set | Sets the style applied to the pivot table | Done | Done | Done | 1.1 |
XCEL_PivotTable_Refresh | Refreshes the pivot table | Done | Done | Done | 1.1 |
XCEL_PivotTable_Fld_Position_Set | Sets the position of a pivot field among the fields of an orientation | Done | Done | Done | 1.1 |
XCEL_PivotTable_Item_Visible_Set | Sets the visibility of a pivot item | Done | Done | Done | 1.1 |
XCEL_PivotTable_Exists | Checks the existence of a Pivot Table in a worksheet | Done | Done | Done | 1.1 |
XCEL_PivotTable_Fld_Function_Set | Changes the function associated to a data field (sum, count, average, min, max, etc) | Done | Done | Done | 1.1.1 |
XCEL_PivotTable_Fld_NumberFormat_Set | Sets the number format of a data field | Done | Done | Done | 1.1.1 |
XCEL_PivotTable_Fld_Name_Set | Sets the name displayed in the pivot table for a field | Done | Done | Done | 1.1.1 |
XCEL_PivotTable_Total_Visible_Set | Sets the visibility of columns and rows grand total of the pivot table | Done | Done | Done | 1.1.1 |
XCEL_PivotTable_Count | Counts the number of pivot tables in a worksheet | Done | Done | Done | 1.1.1 |
Filtering and sorting | |||||
XCEL_Sheet_Sort | Sorts the selected range by 1 to 3 sort keys | Done | Done | In Progress | 1.3 |
XCEL_PivotTable_Sort | Sorts the specified pivot table by 1 pivot field | In Progress | To do | To do |
Fixed:
We 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). This is fixed in version 1.1
List of commands or functions for a future version of the library:
Description | |
Managing macros | |
Creation of UI elements and macro assignment | |
Managing sheet tab color (only for Excel more recent versions) |