Class WorkSheet

constructor

• new WorkSheet(
      name: string,
      blocks: DataBlock[],
      styles?: Styles,
      options?: SheetOptions,
  ): WorkSheet

  构造函数

  Parameters

  • name: string

    工作表名称
  • blocks: DataBlock[]

    数据块
  • styles: Styles = {}

    工作表样式
  • options: SheetOptions = {}

    工作表选项

  Returns WorkSheet

  Example

  1. 生成一个只有数据，不带任何样式的工作表

  const block = {
    origin: 'A1',
    data: [['hello', 'world']]
  }
  const ws = new WorkSheet('Sheet1', [block]);
  Copy

  2. 生成一个带样式的工作表（hello 被加粗）

  const block = {
    origin: 'A1',
    data: [[{value: 'hello', style: 'bold'}, 'world']]
  }
  cost styles = {
    bold: {
      font: {
        b: true
      }
    }
  }
  const ws = new WorkSheet('Sheet2', [block], styles);
  Copy

  3. 生成一个配置了列宽的工作表

  const block = {
    origin: 'A1',
    data: [['hello', 'world']]
  };
  const options = {
    colWidths: {min: 1, max: 2, size: 40}
  };
  const ws = new WorkSheet('Sheet3', [block], {}, options);
  Copy

  Since

  1.0.0