工作簿(Workbook) #

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

  const app = instance.Application

  // 活动工作簿
  const activeWorkbook = await app.ActiveWorkbook

  // 活动工作表
  const activeSheet = await activeWorkbook.ActiveSheet
}

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

  const app = instance.Application

  // 活动工作簿
  const activeWorkbook = await app.ActiveWorkbook

  // 工作簿名称集合
  const names = await activeWorkbook.Names
}

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

  const app = instance.Application

  const ReadOnly = await app.ActiveWorkbook.ReadOnly
}

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

  const app = instance.Application

  const ReadOnlyComment = await app.ActiveWorkbook.ReadOnlyComment
}

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

  const app = instance.Application

  // 工作表对象
  const sheets = await app.ActiveWorkbook.Sheets
}

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

  const app = instance.Application

  const SupportReadOnlyComment = await app.ActiveWorkbook.SupportReadOnlyComment
}

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

  const app = instance.Application

  const title = await app.ActiveWorkbook.BuiltinDocumentProperties('Title')
    .Value
  console.log('title: ', title)
}

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

  const app = instance.Application

  await app.ActiveWorkbook.SetCustomDocumentProperties({
    Name: 'selfName',
    Type: 'date',
    Value: '2024-3-25'
  })
}

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

  const app = instance.Application

  const txt = await app.ActiveWorkbook.CustomDocumentProperties('selfName').Value
  console.log('txt: ', txt)
}

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

  const app = instance.Application

  // 清除撤销记录
  await app.ActiveWorkbook.ClearTransactions()
}

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

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

//@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 activeWorkbook = await app.ActiveWorkbook

  // 复制 ID 为 100161090439 命名为 “工作簿” 的工作表中的 Sheet1，到当前工作簿的 Sheet6 工作表上
  const result = await activeWorkbook.CopySheetFromBook(
    '100161090439',
    '工作簿',
    'Sheet1',
    'Sheet6'
  )
  console.log(result)
}

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

  // 获取整个 Workbook 的评论
  const comments = await app.ActiveWorkbook.GetComments()
  console.log(comments)
}

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

  const app = instance.Application

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

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

  const app = instance.Application

  await app.ActiveWorkbook.SetWatermark({
    Type: 1,
    Value: 'WPS WebOffice \n 测试水印测试水印测试水印',
    FillStyle: 'rgba(192, 192, 192, 0.6)',
    Font: 'bold 20px Serif',
    Rotate: (-45 * Math.PI) / 180,
    Horizontal: 50,
    Vertical: 100
  })
}

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

  const app = instance.Application

  await app.ActiveWorkbook.GetWatermark()
}

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

  const app = instance.Application

  // 判断是否含有撤销记录
  await app.ActiveWorkbook.HasTransactions()
}

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

  // 保存文件的改动
  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.SetCalcOptions({
    EnableIterate: false,
    IterateCount: 300,
    IterateDelta: 0.1,
    FullPrecision: false,
    CalcMode: 'automatic',
    Callback: res => console.error('回调函数', res)
  })
}

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

  const app = instance.Application

  // 活动工作簿
  const activeWorkbook = await app.ActiveWorkbook

  // 开启多人同步筛选
  const result = await activeWorkbook.SetFilterShared(true)
}

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

  const app = instance.Application

  // 跳转到@所在单元格
  await app.ActiveWorkbook.SkipAtCell(AtId)
}

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

  const app = instance.Application

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