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:
- standard (the cell value = value property)
- formatted (the cell formatted string value = string value property)

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)