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 |
See also
Overview Excel Files excel_open, excel_sheet_open, excel_sheet_get_rows, excel_sheet_get_row_type, ExcelRead3
id-490150