表格组件会议操作相关 API #

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 激活工作表的index
  const Index = await app.ActiveSheet.Index
  console.log(Index)
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 通知所有打开的下拉面板关闭
  await app.ActiveWorkbook.CloseDropdownPanels()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 通知超链接关闭
  await app.ActiveWorkbook.CloseHyperLink()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveSheet

  // 一个单元格或单元格区域
  const Range = await Sheet.Range

  // 指定单元格
  const range = await Range("D2")

  // 选中D2单元格
  await range.Select()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveSheet

  // 工作表上的所用区域
  const UsedRange = await Sheet.UsedRange

  // 选中所用区域
  UsedRange.Select()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveSheet

  // 单元格对象
  const cells = await Sheet.Cells

  // 指定单元格
  const cell = await cells.Item(1)
  // 或者 cell = await cells(1)

  // 选中第 1 个单元格
  await cell.Select()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveSheet

  // 列对象
  const Columns = await Sheet.Columns

  // 指定列
  const column = await Columns.Item(1)
  // 或者 column = await Columns(1)

  // 选中第 1 个列
  await column.Select()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 监听选区改变事件
  app.Sub.Worksheet_SelectionChange = e => {
    console.log('SelectionChange', e)
  }
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveSheet

  // 行对象
  const Rows = await Sheet.Rows

  // 指定行
  const row = await Rows.Item(1)
  // 或者 row = await Rows(1)

  // 选中第 1 行
  await row.Select()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 退出编辑
  await app.ActiveWorkbook.QuitCellEdit()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 监听强制横屏时通知
  app.Sub.Worksheet_ForceLandscape = e => {
    console.log('ForceLandscape', e)
  }
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 监听用户自己的滚动画布行为
  app.Sub.Worksheet_ScrollChange = () => {
    console.log('ScrollChange')
  }
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 关闭筛选hover提示
  await app.ActiveWorkbook.CloseFilterTips()
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 获取左侧的列号
  const ScrollColumn = await app.ActiveWindow.ScrollColumn
  console.log(ScrollColumn)

  // 设置左侧的列号
  app.ActiveWindow.ScrollColumn = 10
}

//@file=base.xlsx
async function example() {
  await instance.ready()

  const app = instance.Application

  // 获取最上面的行号
  const ScrollRow = await app.ActiveWindow.ScrollRow
  console.log(ScrollRow)

  // 设置最上面的行号
  app.ActiveWindow.ScrollRow = 10
}