Specifies the name of the table column. TypeScript name:string; Property Value string Remarks [API set: ExcelApi 1.1 for getting the name; 1.4 for setting it.] values Represents the raw values of the specified range. The data returned could be a string, number, or boolean. Cells that con...
Overrides the JavaScripttoJSON()method in order to provide more useful output when an API object is passed toJSON.stringify(). (JSON.stringify, in turn, calls thetoJSONmethod of the object that is passed to it.) Whereas the originalExcel.TableColumnCollectionobject is an API object, thetoJS...
booldelete_my_backup_files(boolshow_dialog){ XLOPER12 xResult, xFilter; xFilter.xltype = xltypeStr; xFilter.val.str = L"\014my_data*.bak";// String length: 14 octalintcmd;if(show_dialog) cmd = xlcFileDelete | xlPrompt;elsecmd = xlcFileDelete;// xResult should be Boolean TRUE if...
行（Row）和列（Column）：行是水平方向的一组单元格，列是垂直方向的一组单元格。行用数字标识，列...
Both these functions return a Boolean value, i.e., Depending on the logical test applied to the arguments in the function, the output will be either TRUE or FALSE. AND Function: The AND function in Excel evaluates all the arguments provided and returns TRUE if all the arguments are TRUE,...
Global – 设置或返回一个Boolean值,该值指明在整个搜索字符串时模式是全部匹配还是只匹配第一个。如果搜索应用于整个字符串,Global 属性的值应该为 True,否则其值为 False。默认的设置为True。 Multiline – 返回正则表达式是否具有标志, 缺省值为False。如果指定的搜索字符串分布在多行,这个属性是要设置为True的...
IModelTableColumn IModelTableColumns IModelTableNameChange IModelTableNameChanges IModelTableNames IModelTables IModule IModules IModuleView IMultiThreadedCalculation IName INames INegativeBarFormat Interior IODBCConnection IODBCError IODBCErrors IOLEDBConnection IOLEDBError IOLEDBErrors IOLEFormat IOLEObject...
addWorksheet('My Sheet', {views: [{showGridLines: false}]}); // create a sheet with the first row and column frozen const sheet = workbook.addWorksheet('My Sheet', {views:[{state: 'frozen', xSplit: 1, ySplit:1}]}); // Create worksheets with headers and footers const sheet = ...
AutomaticStyles (Boolean) 向Excel 指示是否对提纲应用自动样式。 SummaryColumn (XlSummaryColumn) 获取或设置摘要列的位置。 XlSummaryColumn 枚举有两个可能使用的值:xlSummaryOnLeft 和xlSummaryOnRight。 SummaryRow (XlSummaryRow) 获取或设置摘要行的位置。 XlSummaryRow 枚举具有两个可能使用的值:xlSummaryAbove...
These will be the items that make up the row or column that you want to sort on. If a string is used instead of a PivotItem, the string represents the ID of the PivotItem. If there are no items other than data hierarchy on the axis you want to sort on, this can be empty. ...