表格组件页面操作相关 API #

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

  const app = instance.Application

  // 导出整个表格
  const workbookPdfUrl = await app.ActiveWorkbook.ExportAsFixedFormat()
  console.log(workbookPdfUrl)
}

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

  const app = instance.Application

  // 导出整个表格
  const workbookPdfUrl = await app.ActiveWorkbook.ExportAsFixedFormat({
    Type: app.Enum.XlFixedFormatType.xlTypeIMG
  })
  console.log(workbookPdfUrl)
}

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

  const app = instance.Application

  // 导出整个表格
  const workbookPdfUrl =
    await app.ActiveWorkbook.ActiveSheet.ExportAsFixedFormat()
  console.log(workbookPdfUrl)
}

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

  const app = instance.Application

  // 导出整个表格
  const workbookPdfUrl =
    await app.ActiveWorkbook.ActiveSheet.ExportAsFixedFormat({
      Type: app.Enum.XlFixedFormatType.xlTypeIMG
    })
  console.log(workbookPdfUrl)
}

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

  const app = instance.Application

  // 获取所有工作表名称
  const Names = []
  await app.For(1, app.Sheets.Count, 1, async Index => {
    Names.push(await app.Sheets.Item(Index).Name)
  })
  console.log(Names)
}

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

  const app = instance.Application

  // 获取当前工作表名称
  const name = await app.ActiveWorkbook.ActiveSheet.Name
  console.log(name)
}

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

  const app = instance.Application

  // 切换到指定工作表
  const sheetIndex = 2 // Sheets 序号，从 1 开始
  app.ActiveWorkbook.Sheets.Item(sheetIndex).Activate()
}

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

  const app = instance.Application

  // 切换到指定工作表
  const sheetIndex = 2 // Sheets 序号，从 1 开始
  app.Sheets(sheetIndex).Activate()
}

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

  const app = instance.Application

  // 监听工作表的切换
  app.Sub.Worksheet_Activate = async () => {
    console.log('ActiveSheet：', await app.ActiveSheet.Name)
  }
}

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

  const app = instance.Application

  // 获取当前登录操作者信息
  const operatorsInfo = await app.ActiveWorkbook.GetOperatorsInfo()
  console.log(operatorsInfo)
}

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

  const app = instance.Application

  // 获取剪切板回调事件
  app.Sub.Clipboard_Copy = e => {
    console.log(e)
  }
}

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

//@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 saveResult = await app.ActiveWorkbook.Save()
  console.log(saveResult)
}

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

  const app = instance.Application

  // 切换卡片视图面板-打开
  await app.ActiveWorkbook.SwitchCardView(true)
}