Name | Brief | Example |
---|---|---|
get_book_sheet_names | check given string to see if in the form of [Book]Sheet1, if yes, break down and return book and sheet names | Examples |
find_col_by_name | To find column by long name, if not found then find column by short name. | Examples |
find_user_defined_label | To find the user defined label by name in Worksheet. | Examples |
is_col_all_text | check a worksheet column to see if it is really a text column | Examples |
is_column_in_bounds | Check the column if is in the bound | Examples |
make_book_sheet_name | return string in the form of [Data1]Sheet1 | Examples |
okoc_create_workbook | creating a new workbook with more controls | Examples |
out_tree_to_wks | output result from tree to worksheet. | Examples |
save_data_2_Wks | put XY or XYZ data to worksheet | Examples |
setLabelValueFromRows | Set column label value from rows value | Examples |
sheet_find_empty_dataobject | Find first DataObject of last empty range in the specified Datasheet starting with the specified DataObject. | Examples |
wks_add_show_labels | Add more labels to worksheet column lablel region, make display order according order in vnType | Examples |
wks_copy | Copy a worksheet from another worksheet | Examples |
wks_find_empty_column | Find first column of last empty range in the specified worksheet starting with the specified column. | Examples |
wks_from_book_sheet_name | Attach a worksheet by [Book]Sheet string | Examples |
wks_get_book_sheet_name | construct the [Book1]Sheet1 string from given Datasheet | Examples |
wks_has_complex_col | Checks whether worksheet has complex column | Examples |
wks_has_x | when import data, if we need not show time column and use append col import mode, we need check if wks has x column. It will return true, if wks is not empty AND has X column. | Examples |
wks_insert_column | It appends or inserts a column to worksheet at a desired position. | Examples |
wks_scroll_into_view | worksheet scroll function | Examples |
wks_sep_label | Extract units from worksheet column Long Name or other label row | Examples |
wks_set_label_text_control | Change worksheet label text style control. | Examples |
wks_set_show_labels | Configure worksheet column lablel region display options | Examples |