Function exportExcel

packages/amis/src/renderers/Table/exportExcel.ts:254–619

(
  ExcelJS: any,
  props: TableProps,
  toolbar: ExportExcelToolbar,
  withoutData: boolean = false
)

 * @param withoutData 如果为 true 就不导出数据，只导出表头
 */
export async function exportExcel(
  ExcelJS: any,
  props: TableProps,
  toolbar: ExportExcelToolbar,
  withoutData: boolean = false
) {
  const {
    store,
    env,
    classnames: cx,
    translate: __,
    data,
    prefixRow,
    affixRow
  } = props;
  let columns = store.exportColumns || [];

  let rows = [];
  let tmpStore;
  let filename = 'data';
  // 支持配置 api 远程获取
  if (typeof toolbar === 'object' && toolbar.api) {
    const pageField = toolbar.pageField || 'page';
    const perPageField = toolbar.perPageField || 'perPage';
    const ctx: any = createObject(data, {
      ...props.query,
      [pageField]: data.page || 1,
      [perPageField]: data.perPage || 10
    });

    const res = await env.fetcher(toolbar.api, ctx, {
      autoAppend: true,
      pageField,
      perPageField
    });
    if (!res.data) {
      env.notify('warning', __('placeholder.noData'));
      return;
    }
    /**
     * 优先找items和rows，找不到就拿第一个值为数组的字段
     * 和CRUD中的处理逻辑保持一致，避免能渲染和导出的不一致
     */
    if (Array.isArray(res.data)) {
      rows = res.data;
    } else if (Array.isArray(res.data?.rows)) {
      rows = res.data.rows;
    } else if (Array.isArray(res.data?.items)) {
      rows = res.data.items;
    } else {
      for (const key of Object.keys(res.data)) {
        if (res.data.hasOwnProperty(key) && Array.isArray(res.data[key])) {
          rows = res.data[key];
          break;
        }
      }
    }