excel_sheet_get_row_type2ΒΆ

excel_sheet_get_row_type2 returns a real matrix with the data types of a section of an Excel sheet.

rmType = excel_sheet_get_row_type2(oSheet)

Return Value

rmType is a real matrix. The matrix contains the data type values of the segment of a sheet. Before this function is invoked excel_sheet_get_rows must be invoked to load the data. The number of columns is identical to the number of columns of the sheet. The number of rows is identical to the return value of excel_sheet_get_rows. The elements contain the data types of the corresponding spread sheet cells:

Value Description
0 to 10 Number, value is number of decimals.
19 Number, format undefined (General).
20 Number, time format e.g. 12:17:32.
21 Number, date format e.g. 02.30.2009
22 Number, date-time format. 02.30.2009 12:17:32
100 String
101 Empty cell
999 Error occurred

Parameters

oSheet

oSheet is an object created by excel_sheet_open.

Comment

Before this function is invoked excel_sheet_get_rows must be invoked.

Example

See excel_open.

History

Version Description
R2014.4 New

id-490150