[FEATURE] 请问 MaProTable 工具栏插件有没有内置导出表格数据功能？

[nighon]

请问 MaProTable 工具栏插件（ToolbarPlugin）有没有内置导出表格数据功能？比如导出为 .csv, .xlsx 等格式。🙏

[kanyxmo]

目前没有，可以自己添加，或者等后面官方开发插件

[Darknesser]

用到了导出xlsx，简单实现了一下，使用xlswriter

• 在删除按钮旁边增加一个导出按钮

<template #toolbarLeft>
  <el-button
    v-auth="['trademark:order:delete']"
    type="danger"
    plain
    :disabled="selections.length < 1"
    @click="handleDelete"
  >
    {{ t('crud.delete') }}
  </el-button>
  <el-button
    v-auth="['trademark:order:export']"
    type="primary"
    plain
    @click="handleExport"
  >
    {{ t('biz.field.export') }}
  </el-button>
</template>

• 搜索参数

// 搜索参数
const searchFormValues = ref({})

// 给MaProTable加一个search-submit
<MaProTable ref="proTableRef" :options="options" :schema="schema" @search-submit="handleSearchSubmit">

// 搜索参数赋值
function handleSearchSubmit(form: Record<string, any>): void {
  searchFormValues.value = form
}

• 点击事件处理

function handleExport() {
  const response = exportFile(searchFormValues.value)
  response.then((res) => {
    if (!res || !(res instanceof Blob)) {
      msg.alertError('Export response invalid')
      return
    }
    const url = window.URL.createObjectURL(new Blob([res]))
    const link = document.createElement('a')
    link.href = url
    link.setAttribute('download', 'order.xlsx')
    document.body.appendChild(link)
    link.click()
    document.body.removeChild(link)
  }, err => msg.alertError(err),
  ).catch((err) => {
    msg.alertError(err)
  })
}

• 调用接口

export function exportFile(data: TrademarkOrderSearchVo) {
  return useHttp().post('/admin/trademark-order/export', data, {
    responseType: 'blob',
    timeout: 3600,
  })
}

• 接口实现，xlswriter使用就不展示了

#[Post(
    path: '/admin/trademark-order/export',
    operationId: 'trademarkOrderExport',
    summary: 'Export Trademark Order',
    security: [['Bearer' => [], 'ApiKey' => []]],
    tags: ['Trademark Manage']
)]
#[Permission(code: 'trademark:order:export')]
public function export(Request $request, Response $response): ResponseInterface
{
    [$filePath, $fileName] = $this->trademarkOrderService->export($request->all());
    return $response->download($filePath, $fileName);
}