Date of update: 15.05.2011

XTRA for work with Microsoft Excel files

write us
Novelties
Web feeds
Links of Interest
List of methods
Download of all functions (pdf)
XTRA initialisation.
Registration of dmmXLS.x32.
Function of cell locking.
Transformation of cell in Col and Row format to Ref format.
The function deletes columns in the actual sheet in the xls document.
The function deletes rows in the actual sheet in the xls document.
A preselection giving choice to show the dialogue window with error statement.
A preselection giving choice to save errors to log file.
The function gives information about an error occured while working with the XTRA.
The function gives number of the first column containing data used in a sheet.
The function gives number of the first row containing data used in a sheet.
The function loads the contents of the cell in the xls file, whose format is UNICODE. It is returned as a value of the ANSI string type.
The function gives contents of a cell in boolean format.
The function calculates the formula saved in the cell and it returns the result in the boolean format.
The function returns contents of the cell in the format DateTime as a propertyList.
The function gives contents of a cell in double format.
The function calculates the formula saved in the cell and it returns the result in the double format.
The function returns the cell contents in Html format.
The function returns the cell contents in Html format.
The function gives contents of a cell in integer format.
The function calculates the formula saved in the cell and it returns the result in the integer format.
The function returns the cell contents in Rtf format.
The function returns the cell contents in Rtf format.
The function gives contents of a cell in string format.
The function calculates the formula saved in the cell and it returns the result in the string format.
The function gives contents of a cell in UTF-8 string format.
The function returns contents of the cell according to the type of variable.
The function returns contents of the cell according to the type of variable.
The function returns name of the actual sheet, set by the function setActiveSheet.
The function adds columns to the actual sheet in the xls document.
The function adds rows to the actual sheet in the xls document.
Test made to show whether an error occured during work with the XTRA.
The function gives number of the last column containing data used in a sheet.
The function gives number of the last row containing data used in a sheet.
Reading of an xls file.
Loading of the xls file from the http.
Reading of xls documents saved in a zip archive.
Transformation of cell in Ref format to Col and Row format.
Xls file saving.
Setting of the actual sheet in xls,which we want to work with.
The function saves the contents in the boolean format to a cell in xls document.
The function saves contents of the propertyList to a cell in the xls document in the format DateTime.
The function saves the contents in the double format to a cell in xls document.
The function sets colour of the text for the chosen cell.
The function sets font for the chosen cell.
The function sets size of font for the chosen cell.
The function sets a text style for a cell.
The function saves the calculation formula in xls document.
The function sets text alignment in cell in the horizontal shape.
The function saves the contents in the integer format to a cell in xls document.
The function rotates a text in cell by a certain angle.
The function saves the contents in the string format to a cell in xls document.
The function saves the contents in the UTF-8 string format to a cell in xls document.
The function sets text alignment in cell in the vertical shape.
Function of sheet locking.
Finding out of version of XTRA dmmXLS.x32.
List of events
The event monitores the downloading of the xls file from the http.
This event is invoked in case an error occurred during work with the XTRA.



© 1992-2010 Studio dmm, all rights reserved