表格(Sheet) #

async function example() {
  await instance.ready()

  const app = instance.Application

  // 新建数据表
  await app.ActiveDBSheet.Sheet.AddSheet()
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 删除当前数据表（Sheet）
  await app.ActiveDBSheet.Sheet.DeleteSheet()
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 返回当前 Sheet 的索引
  const index = await app.ActiveDBSheet.Sheet.GetActiveSheetIndex()
  console.log(index)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 获取日期格式
  const info = await app.ActiveDBSheet.Sheet.GetDateFormat()
  console.log(info)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 获取数字格式
  const info = await app.ActiveDBSheet.Sheet.GetNumberFormat()
  console.log(info)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 获取时间格式
  const info = await app.ActiveDBSheet.Sheet.GetTimeFormat()
  console.log(info)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 根据传入的 Name，重命名数据表（Sheet）
  // 重命名数据表为 'WebOffice'
  await app.ActiveDBSheet.Sheet.RenameSheet({
    SheetIndex: 1,
    Name: 'WebOffice'
  })
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 根据传入 SheetIndex，切换数据表（Sheet）
  // 切换到第 2 个数据表
  await app.ActiveDBSheet.Sheet.SetActiveSheet({ SheetIndex: 2 })
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 设置默认背景色
  await app.ActiveDBSheet.Sheet.SetRenderDefBgColor({
    Color: '#fff'
  })
}