活动窗口 #

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

  const app = instance.Application

  // 活动的窗口
  const activeWindow = await app.ActiveWindow
}

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

  const app = instance.Application

  // 隐藏网格线
  app.ActiveWindow.DisplayGridlines = false
}

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

  const app = instance.Application

  // 隐藏行标题和列标题
  app.ActiveWindow.DisplayHeadings = false
}

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

  const app = instance.Application

  const value = await app.ActiveWindow.HorzIndex
  console.log(value)

  app.ActiveWindow.HorzIndex = 300
}

//@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
}

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

  const app = instance.Application

  const value = await app.ActiveWindow.VertIndex
  console.log(value)

  app.ActiveWindow.VertIndex = 300
}

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

  const app = instance.Application

  // 获取窗口缩放比例
  const zoom = await app.ActiveWindow.Zoom
  console.log(zoom)

  // 操作窗口缩放比例
  app.ActiveWindow.Zoom = 10
}