介绍
项目中常用的导入导出Excel文件方法封装,希望各位多提意见和补充。
一、导入文件
// 导入接口
import requestUpload from 'umi-request';
export async function importFile(params: any) {
return requestUpload(`${globalData.url}/api/importFile`, {
method: 'POST',
...params,
});
}
// 使用
<Upload
name="file"
accept=".csv,.xls,.xlsx, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel"
headers={
{
authorization: 'authorization-text',
}}
showUploadList={false}
customRequest={(options) => {
const formData = new FormData();
formData.append('file', options.file);
// 调用上传接口
importFile({
data: formData,
}).catch((e) => console.log(e));
}}
onChange={(info) => {
if (info.file.status === 'done') {
message.success(info.file.res