工作表 #

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

  const app = instance.Application

  // 工作簿（Workbook）中所有工作表（Sheet）的集合
  const sheets = await app.ActiveWorkbook.Sheets
}

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

  const app = instance.Application

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

  // 工作表数量
  const count = await sheets.Count
  console.log(count)
}

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

  const app = instance.Application

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

  // 默认新工作表名
  const defaultNewSheetName = await sheets.DefaultNewSheetName
  console.log(defaultNewSheetName)
}

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

  const app = instance.Application

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

  // 添加工作表
  await sheets.Add(null, null, 1, app.Enum.XlSheetType.xlWorksheet, '新工作表')
}

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

  const app = instance.Application

  // 工作表对象
  const sheet = await app.ActiveWorkbook.Sheets.Item(1)
}

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

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveWorkbook.Sheets.Item(1)

  // 单元格对象
  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 activeSheet = await app.ActiveWorkbook.Sheets.Item(1)

  const chartObjects = await activeSheet.Columns
}

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

  const app = instance.Application

  const id = await app.ActiveWorkbook.Sheets.Item(1).Id
  console.log(id)
}

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

  const app = instance.Application

  const index = await app.ActiveWorkbook.Sheets.Item(1).Index
  console.log(index)
}

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

  const app = instance.Application

  const name = await app.ActiveWorkbook.Sheets.Item(1).Name
  console.log(name)

  app.ActiveWorkbook.Sheets.Item(1).Name = 'WPS WebOffice'
}

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

  const app = instance.Application

  const activeSheet = await app.ActiveWorkbook.Sheets.Item(1)

  const names = await activeSheet.Names
}

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

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveWorkbook.Sheets.Item(1)

  // 一个单元格或单元格区域
  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.ActiveWorkbook.Sheets.Item(1)

  // 行对象
  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

  const activeSheet = await app.ActiveWorkbook.Sheets.Item(1)

  const shapes = await activeSheet.Shapes
}

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

  const app = instance.Application

  // 工作表对象
  const sheetIndex = 2 // Sheets 序号，从 1 开始
  const sheet = await app.ActiveWorkbook.Sheets.Item(sheetIndex)

  // 工作表类型
  const Type = await sheet.Type
  console.log(Type)
}

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

  const app = instance.Application

  // 工作表对象
  const Sheet = await app.ActiveWorkbook.Sheets.Item(1)

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

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

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

  const app = instance.Application

  const visible = await app.ActiveWorkbook.Sheets.Item(1).Visible
  console.log(visible)

  app.ActiveWorkbook.Sheets.Item(1).Visible = false
}

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

  const activeSheet = await app.ActiveWorkbook.Sheets.Item(1)

  await activeSheet.Delete()
}

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

  const app = instance.Application

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

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

  const app = instance.Application

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

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

  const app = instance.Application

  await app.ActiveWorkbook.Sheets(1).Move({
    Before: null,
    After: await app.ActiveWorkbook.Sheets(2).Id
  })
}

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

  const app = instance.Application

  const activeSheet = await app.ActiveWorkbook.Sheets.Item(1)

  activeSheet.Protect('123456')
}

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

  const app = instance.Application

  const activeSheet = await app.ActiveWorkbook.Sheets.Item(1)

  activeSheet.Unprotect('123456')
}