HotXLS 文档

SelectAreas 方法

在经典 XLS 工作表上选择一个或多个 A1 样式范围,需要时写入多区域 Selection 记录

语法

function SelectAreas(const Areas: array of WideString): Integer; overload;
function SelectAreas(const Areas: array of WideString; ActiveAreaIndex: Integer): Integer; overload;
    

参数

Areas One or more A1-style cell or range references, such as 'A1:B2' or 'D4'
ActiveAreaIndex 0-based index of the active area. If omitted, the first area is active

Return value

返回 1 when the selection is accepted, or -1 当区域列表为空、活动索引无效或任一 A1 引用无法解析时

示例

Workbook.Sheets[1].SelectAreas(
  ['A1:B2', 'D4'],
  1);
    

请参阅

TXLSWorksheet class
TXLSWorksheet.Selection 属性
TXLSWorksheet.Select 方法