Initialize SpreadScript.
Parameters:pLicenseFile - the SpreadScript license fileReturns:none
Gets the version information for SpreadScript.
Parameters:noneReturns:a string containing the version information
Determines whether warnings generated when reading or writing Excel files are only printed to standard error or throw exceptions. The features of Excel that are not supported by SpreadScript are normally reported (by default) as exceptions. However, if you know that the unsupported features are not required for the files you are using, you may wish to change this setting to false so that the warnings are only printed. Carefully check the results to make sure that data integrity is not adversely affected.
Parameters:stopOnExcelWarning - when set to false, warnings generated when reading or writing Excel files are printed to standard error; when true, the warnings throw an exception (the default is true)Returns:none
Sets the global default to use Excel compatibility mode with all newly created Workbook objects. Turning on Excel compatibility mode results in the range syntax using : (e.g., A1:B3) rather than .. (e.g., A1..B3) to specify ranges. Also, the Excel-compatible functions that are normally prefixed with XL, such as XLCHOOSE, are not prefixed with XL. When dealing with Excel files, this mode is best.
Parameters:useExcelMode - if true, Excel compatibility mode is turned onReturns:none
Converts a cell type constant to a string.
Parameters:type - the cell type to convert to a stringReturns:cell type as a string: ``Empty'', ``Overflow'', ``Number'', ``Text'', ``Formula'', ``Chart''
Retrieves a reference to the currently active Workbook. Set the active Workbook using Workbook.activate().
Parameters:noneReturns:the active Workbook
Converts from a cell name to two integers representing a row and column. For example, textToRC(``A1'') results in (1, 1).
Parameters:pText - the text cell name to convertReturns:a two-element list/array containing the row and column
Converts two integers representing a row and column to cell name. For example, rcToText(1, 1) returns ``A1''.
Parameters:row - the rowcolumn - the columnReturns:the text cell name