The Excel Library for scripting Excel with LiveCode is actualy released in open beta. Our testers have started to send us suggestions for improving the library.
We have at this moment a library of 174 commands and functions for Mac and Windows. If you are interested in financing the project in a way or other, for example by pre-ordering the library, feel free to drop us a note.
Last available version is ß0.67.
The Library is released!
List of the functions or commands we are working on before the release:
Name | Description | Mac statut | Windows statut | Documented | Version |
XCEL_Sheet_LastFilledCell | returns the extents address of the last filled cell in a sheet, i.e.: D54 | Done | Done | Done | ß0.63 |
XCEL_Range_Columns_Count | returns the number of columns in a range | Done | Done | Done | ß0.63 |
XCEL_Range_Rows_Count | returns the number of rows in a range | Done | Done | Done | ß0.63 |
XCEL_Range_Copy | copies a range to another range location | Done | Done | Done | ß0.65 |
XCEL_Sheet_Find | returns the cells addresses of the find value. Can find in comments, values or formulas | Done | Done | Done | ß0.65 |
XCEL_Range_Property_Get | returns the value of a range property (is range has formula?, is locked?, etc) | Done | Done | Done | ß0.64 |
XCEL_Range_Property_Set | sets the value of a range property | Done | Done | Done | ß0.64 |
XCEL_Cell_Address_Get | returns the address of the specified cell in a range | ||||
XCEL_Cell_Reference_Get | returns a Library's reference of the cell in a range | ||||
XCEL_Range_Select | selects a range | Done | Done | Done | ß0.65 |
XCEL_Cell_Value_Get | returns the value of a cell | Done | Done | Done | ß0.64 |
XCEL_Cell_Value_Set | sets the value of a cell | Done | Done | Done | ß0.64 |
XCEL_CellRef |
returns a cell reference from col and row number. ie 1,3 -> "A3" | Done | Done | Done | ß0.64 |
XCEL_RangeRef |
returns a range reference from col and row number. ie 1,3,4,3 -> "A3:D3" | Done | Done | Done | ß0.64 |
XCEL_CellRefToNum |
returns a the col and row num from a cell ref. ie "C10" -> 3,10 | Done | Done | Done | ß0.64 |
XCEL_PrintSetUp_Property_Get |
returns print setup properties | Done | Done | Done | ß0.66 |
XCEL_PrintSetUp_Property_Set |
sets print setup properties | Done | Done | Done | ß0.66 |
XCEL_PrintSetup_Picture_Get |
returns properties of a footer or header picture | Done | Done | Done | ß0.66 |
XCEL_PrintSetup_Picture_Set | sets a picture to the footers or headers areas. Several image properties available | Done | Done | Done | ß0.66 |
XCEL_PrintSetup_PageOrientation_Get | returns the page orientation (landscape or portrait) | Done | Done | Done | ß0.66 |
XCEL_PrintSetup_PageOrientation_Set | sets the page orientation (landscape or portrait) | Done | Done | Done | ß0.66 |
XCEL_Column_LastFilledCell_Get | returns the last filled cell of a column | Done | Done | Done | ß0.67 |
XCEL_Column_Visible_Get | returns the visibility of a column | Done | Done | Done | ß0.67 |
XCEL_Column_Visible_Set | sets the visibility of a column | Done | Done | Done | ß0.67 |
XCEL_Row_LastFilledCell_Get | returns the last filled cell of a row | Done | Done | Done | ß0.67 |
XCEL_Row_Visible_Get | returns the visibility of a row | Done | Done | Done | ß0.67 |
XCEL_Row_Visible_Set | sets the visibility of a row | Done | Done | Done | ß0.67 |
List of commands and functions with the need to be improved:
Name | Description | Mac statut | Windows statut | Version |
XCEL_Range_Value_Get |
addition of a new parameter for specifying the value type: |
Done | Done |
ß0.65 |
XCEL_Range_Values_Get | addition of a new parameter for specifying the value type: standard, formatted | Done | Done |
ß0.65 |
XCEL_PrintSetup_Property_Set | Windows - Headers or footers in several lines. Easiest way to have more than one line | / | Done |
ß0.68 |
Color index commands | Addition of 2 new special indexes : 0 for setting the color to empty and - 1 for the automatic color | Done | ß0.68 | |
List of commands and functions not working properly:
Name | Description | Note | Version |
XCEL_Workbook_Open |
Returns the error: object required on Excel97 (windows) |
Fixed | ß0.64 |
XCEL_Range_Name_Get | On Windows, returns the range address instead of the name | Fixed | ß0.65 |
XCEL_Workbook_SaveFileAs | On Mac the command was broken | Fixed | ß0.67 |
XCEL_Window_Rect_Get | On Mac the rect returned was not correct | Fixed | ß0.67 |
XCEL_Application_WindowRect_Get | On Windows the rect returned was not correct | Fixed | ß0.67 |
XCEL_Range_Values_Get | On Mac - Excel 2011 -The function was not working | Fixed | ß0.68 |
XCEL_Range_Value_Get | On Mac - Excel 2011 -The function was not working | Fixed | ß0.68 |
XCEL_Range_BorderColorIndex_Get | On Mac - The function was returning a special value when none color | Fixed | ß0.68 |
Changes:
- The Library Error has been improved to return a specific message when the specified workbook, worksheet, shape or chart is missing. (ß0.67)
- XCEL_Sheet_Column_Insert and XCEL_Sheet_Column_Delete have been renamed in XCEL_Column_Insert and XCEL_Column_Delete (ß0.67)
- XCEL_Sheet_Row_Insert and XCEL_Sheet_Row_Delete have been renamed in XCEL_Row_Insert and XCEL_Row_Delete (ß0.67)
- XCEL_Range_BorderLineStyle_Set. For removing a border we can now pass empty to the line style parameter. This new keyword is equivalent to the "line style none" style. (ß0.68)
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) |