{"id":8293,"date":"2025-04-18T16:29:47","date_gmt":"2025-04-18T08:29:47","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/8293.html"},"modified":"2025-04-18T16:29:47","modified_gmt":"2025-04-18T08:29:47","slug":"%e8%8b%a5%e4%be%9d%e6%a1%86%e6%9e%b6%e7%af%87-%e8%8b%a5%e4%be%9d%e9%9b%86%e6%88%90-x-file-storage-%e6%a1%86%e6%9e%b6%ef%bc%88%e5%ae%9e%e7%8e%b0%e5%9b%be%e7%89%87%e4%b8%8a%e4%bc%a0%e9%98%bf%e9%87%8c","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/8293.html","title":{"rendered":"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09"},"content":{"rendered":"

🔥\u535a\u5ba2\u4e3b\u9875：\u00a0\u3010\u5c0f\u6273_-CSDN\u535a\u5ba2\u3011 \u2764\u611f\u8c22\u5927\u5bb6\u70b9\u8d5e👍\u6536\u85cf\u2b50\u8bc4\u8bba\u270d<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u6587\u7ae0\u76ee\u5f55<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.0 \u5b9e\u73b0\u4f7f\u7528 Excel \u6587\u4ef6\u6279\u91cf\u5bfc\u5165<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.1 \u5bfc\u5165\u529f\u80fd\u7684\u524d\u7aef\u5177\u4f53\u5b9e\u73b0<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.2 \u5bfc\u5165\u529f\u80fd\u7684\u540e\u7aef\u5177\u4f53\u5b9e\u73b0<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.3 \u4f7f\u7528 EasyExcel \u6846\u67b6\u5b9e\u73b0 Excel \u8bfb\u3001\u5199\u529f\u80fd<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.4 \u5c06 Easy Excel \u96c6\u6210\u5230\u82e5\u4f9d\u6846\u67b6\u4e2d<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02.0 \u963f\u91cc\u4e91 OSS \u6982\u8ff0<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2.1 \u4f7f\u7528\u963f\u91cc\u4e91 OSS \u5177\u4f53\u8fc7\u7a0b<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2.2 \u5c06 X-File-Storage \u96c6\u6210\u5230\u82e5\u4f9d\u6846\u67b6\u4e2d<\/p>\n

\n

\u00a0 \u00a0 \u00a0 \u00a0 1.0 \u5b9e\u73b0\u4f7f\u7528 Excel \u6587\u4ef6\u6279\u91cf\u5bfc\u5165<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4f7f\u7528\u82e5\u4f9d\u6846\u67b6\u5b9e\u73b0\u4e86 CRUD \u4e4b\u540e，\u82e5\u4f9d\u4f1a\u81ea\u52a8\u5b9e\u73b0\u5bfc\u51fa\u529f\u80fd：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u5c06\u5f53\u524d\u9875\u9762\u6240\u5c55\u793a\u7684\u4fe1\u606f，\u4ee5 Excel \u7684\u5f62\u5f0f\u5bfc\u5165\u5230\u672c\u5730\u4e2d：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u5bfc\u51fa\u529f\u80fd\u82e5\u4f9d\u7531\u82e5\u4f9d\u6846\u67b6\u5b9e\u73b0\u7684，\u5bf9\u4e8e\u5bfc\u5165\u529f\u80fd，\u82e5\u4f9d\u6846\u67b6\u6ca1\u6709\u5b9e\u73b0\u8be5\u529f\u80fd\u3002<\/p>\n

\u82e5\u4f9d\u6846\u67b6\u5b9e\u73b0\u5bfc\u51fa\u529f\u80fd：<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1）\u524d\u7aef\u4ee3\u7801：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u9996\u5148\u5b9a\u4e49\u4e86\u4e00\u4e2a\u6309\u94ae，\u5173\u8054\u7740 handleExport \u65b9\u6cd5：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2）\u540e\u7aef\u4ee3\u7801：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u5728 Controller \u5c42\u4e2d，\u8c03\u7528\u63a5\u53e3\u83b7\u53d6\u5230 list \u9700\u8981\u5bfc\u51fa\u7684\u6570\u636e，\u901a\u8fc7 ExcelUtil \u5de5\u5177\u7c7b，\u8c03\u7528\u8be5\u5de5\u5177\u7c7b\u7684 exportExcel() \u65b9\u6cd5，\u6765\u5c06\u6570\u636e\u8fdb\u884c\u5bfc\u51fa\u3002<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Sku \u662f\u4e00\u4e2a\u6839\u636e\u4e1a\u52a1\u9700\u8981\u751f\u6210\u7684\u4e00\u4e2a\u5b9e\u4f53\u7c7b：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u901a\u8fc7 @Excel \u6ce8\u89e3\u6765\u5b9e\u73b0\u5b9e\u4f53\u7c7b\u4e0e Excel \u8868\u683c\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u6620\u5c04\u3002<\/p>\n<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.1 \u5bfc\u5165\u529f\u80fd\u7684\u524d\u7aef\u5177\u4f53\u5b9e\u73b0<\/h3>\n

\u6839\u636e\u4e1a\u52a1\u9700\u8981\u5b9e\u73b0：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1）\u9996\u5148\u9700\u8981\u5b9a\u4e49\u4e00\u4e2a\u6309\u94ae，\u70b9\u51fb\u4e4b\u540e，\u5f39\u51fa\u5bf9\u8bdd\u6846：<\/p>\n

<el-col :span="1.5">
\n <el-button
\n type="warning"
\n plain
\n icon="upload"
\n @click="handleImport"
\n v-hasPermi="['manage:sku:add']"
\n >\u5bfc\u5165<\/el-button>
\n <\/el-col> <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u8be5\u6309\u94ae\u5173\u8054\u7740 handleImport \u7684\u65b9\u6cd5，\u5f53\u89e6\u53d1\u70b9\u51fb\u4e8b\u4ef6\u4e4b\u4e4b\u540e，\u5f39\u51fa\u5bf9\u8bdd\u6846：<\/p>\n

const excelOpen = ref(false);
\nfunction handleImport(){
\n excelOpen.value = true;<\/p>\n

} <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2）\u5bf9\u8bdd\u6846\u7684\u5185\u5bb9：<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u6839\u636e Element \u5b98\u7f51\u53c2\u8003\u5b9e\u73b0\u6587\u4ef6\u4e0a\u4f20\u529f\u80fd：Upload \u4e0a\u4f20 | Element Plus<\/p>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5728\u5bf9\u8bdd\u6846\u4e2d\u63d2\u5165\u6587\u4ef6\u4e0a\u4f20\u7684\u529f\u80fd：<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4f7f\u7528\u4e86 el-dialog \u7ec4\u4ef6\u6765\u521b\u5efa\u4e00\u4e2a\u5bf9\u8bdd\u6846，\u7528\u4e8e\u5bfc\u5165\u6570\u636e\u3002\u5bf9\u8bdd\u6846\u5185\u5d4c\u4e86\u4e00\u4e2a el-upload \u7ec4\u4ef6，\u7528\u4e8e\u6587\u4ef6\u4e0a\u4f20\u3002<\/p>\n

<!– \u6570\u636e\u5bfc\u5165\u5bf9\u8bdd\u6846 –>
\n <el-dialog title="\u5bfc\u5165\u6570\u636e" v-model="excelOpen" width="400px" append-to-body>
\n <el-upload
\n ref="uploadRef"
\n class="upload-demo"
\n :action="uploadExcelUrl"
\n :headers="headers"
\n :on-success="handleUploadSuccess"
\n :on-error="handleUploadError"
\n :before-upload="handleBeforeUpload"
\n :limit="1"
\n :auto-upload="false"
\n >
\n <template #trigger>
\n <el-button type="primary">\u4e0a\u4f20\u6587\u4ef6<\/el-button>
\n <\/template><\/p>\n

<el-button class="ml-3" type="success" @click="submitUpload">
\n \u4e0a\u4f20
\n <\/el-button><\/p>\n

<template #tip>
\n <div class="el-upload__tip">
\n \u4e0a\u4f20\u6587\u4ef6\u4ec5\u652f\u6301，xls\/xlsx\u683c\u5f0f，\u6587\u4ef6\u5927\u5c0f\u4e0d\u5f97\u8d85\u8fc71M
\n <\/div>
\n <\/template>
\n <\/el-upload>
\n <\/el-dialog> <\/p>\n

\u5bf9\u5e94\u7684 JS \u4ee3\u7801：\u00a0<\/p>\n

const uploadRef = ref({});
\nfunction submitUpload(){
\n uploadRef.value.submit();
\n} <\/p>\n

\u6807\u7b7e\u4e2d\u5c5e\u6027\u89e3\u6790：<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0– v-model="excelOpen": \u63a7\u5236\u5bf9\u8bdd\u6846\u7684\u663e\u793a\u4e0e\u9690\u85cf\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :action="uploadExcelUrl": \u6587\u4ef6\u4e0a\u4f20\u7684\u76ee\u6807 URL\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :headers="headers": \u4e0a\u4f20\u8bf7\u6c42\u7684\u5934\u90e8\u4fe1\u606f\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :on-success="handleUploadSuccess": \u6587\u4ef6\u4e0a\u4f20\u6210\u529f\u540e\u7684\u56de\u8c03\u51fd\u6570\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :on-error="handleUploadError": \u6587\u4ef6\u4e0a\u4f20\u5931\u8d25\u540e\u7684\u56de\u8c03\u51fd\u6570\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :before-upload="handleBeforeUpload": \u6587\u4ef6\u4e0a\u4f20\u524d\u7684\u94a9\u5b50\u51fd\u6570，\u53ef\u4ee5\u7528\u6765\u505a\u6587\u4ef6\u6821\u9a8c\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :limit="1": \u9650\u5236\u4e00\u6b21\u53ea\u80fd\u4e0a\u4f20\u4e00\u4e2a\u6587\u4ef6\u3002 \u00a0 \u00a0 \u00a0 \u00a0 – :auto-upload="false": \u7981\u7528\u81ea\u52a8\u4e0a\u4f20，\u9700\u8981\u624b\u52a8\u89e6\u53d1\u4e0a\u4f20\u3002<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 3）\u524d\u7aef\u5b9e\u73b0\u5bfc\u5165\u529f\u80fd\u7684\u5b8c\u6574\u4ee3\u7801<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u57fa\u4e8e\u82e5\u4f9d\u6846\u67b6\u5b9e\u73b0\u7684\u524d\u7aef\u4ee3\u7801：<\/p>\n

<!– \u5bfc\u5165\u6309\u94ae–>
\n<el-col :span="1.5">
\n <el-button type="warning" plain icon="Upload" @click="handleExcelImport" v-hasPermi="['manage:sku:add']">\u5bfc\u5165<\/el-button>
\n<\/el-col><\/p>\n

<!– \u6570\u636e\u5bfc\u5165\u5bf9\u8bdd\u6846 –>
\n<el-dialog title="\u6570\u636e\u5bfc\u5165" v-model="excelOpen" width="400px" append-to-body>
\n <el-upload ref="uploadRef" class="upload-demo"
\n :action="uploadExcelUrl"
\n :headers="headers"
\n :on-success="handleUploadSuccess"
\n :on-error="handleUploadError"
\n :before-upload="handleBeforeUpload"
\n :limit="1"
\n :auto-upload="false">
\n <template #trigger>
\n <el-button type="primary">\u4e0a\u4f20\u6587\u4ef6<\/el-button>
\n <\/template>
\n <el-button class="ml-3" type="success" @click="submitUpload">
\n \u4e0a\u4f20
\n <\/el-button>
\n <template #tip>
\n <div class="el-upload__tip">
\n \u4e0a\u4f20\u6587\u4ef6\u4ec5\u652f\u6301，xls\/xlsx\u683c\u5f0f，\u6587\u4ef6\u5927\u5c0f\u4e0d\u5f97\u8d85\u8fc71M
\n <\/div>
\n <\/template>
\n <\/el-upload>
\n<\/el-dialog><\/p>\n

<script setup name="Sku">
\nimport { getToken } from "@\/utils\/auth";<\/p>\n

\/* \u6253\u5f00\u6570\u636e\u5bfc\u5165\u5bf9\u8bdd\u6846 *\/
\nconst excelOpen = ref(false);
\nfunction handleExcelImport() {
\n excelOpen.value = true;
\n}<\/p>\n

\/* \u4e0a\u4f20\u5730\u5740 *\/
\nconst uploadExcelUrl = ref(import.meta.env.VITE_APP_BASE_API + "\/manage\/sku\/import"); \/\/ \u4e0a\u4f20excel\u6587\u4ef6\u5730\u5740
\n\/* \u4e0a\u4f20\u8bf7\u6c42\u5934 *\/
\nconst headers = ref({ Authorization: "Bearer " + getToken() });<\/p>\n

\/* \u4e0a\u4f20excel *\/
\nconst uploadRef = ref({});
\nfunction submitUpload() {
\n uploadRef.value.submit()
\n}<\/p>\n

const props = defineProps({
\n modelValue: [String, Object, Array],
\n \/\/ \u5927\u5c0f\u9650\u5236(MB)
\n fileSize: {
\n type: Number,
\n default: 1,
\n },
\n \/\/ \u6587\u4ef6\u7c7b\u578b, \u4f8b\u5982["xls", "xlsx"]
\n fileType: {
\n type: Array,
\n default: () => ["xls", "xlsx"],
\n },
\n});<\/p>\n

\/\/ \u4e0a\u4f20\u524dloading\u52a0\u8f7d
\nfunction handleBeforeUpload(file) {
\n let isExcel = false;
\n if (props.fileType.length) {
\n let fileExtension = "";
\n if (file.name.lastIndexOf(".") > -1) {
\n fileExtension = file.name.slice(file.name.lastIndexOf(".") + 1);
\n }
\n isExcel = props.fileType.some(type => {
\n if (file.type.indexOf(type) > -1) return true;
\n if (fileExtension && fileExtension.indexOf(type) > -1) return true;
\n return false;
\n });
\n }
\n if (!isExcel) {
\n proxy.$modal.msgError(
\n `\u6587\u4ef6\u683c\u5f0f\u4e0d\u6b63\u786e, \u8bf7\u4e0a\u4f20${props.fileType.join("\/")}\u683c\u5f0f\u6587\u4ef6!`
\n );
\n return false;
\n }
\n if (props.fileSize) {
\n const isLt = file.size \/ 1024 \/ 1024 < props.fileSize;
\n if (!isLt) {
\n proxy.$modal.msgError(`\u4e0a\u4f20excel\u5927\u5c0f\u4e0d\u80fd\u8d85\u8fc7 ${props.fileSize} MB!`);
\n return false;
\n }
\n }
\n proxy.$modal.loading("\u6b63\u5728\u4e0a\u4f20excel，\u8bf7\u7a0d\u5019…");
\n}<\/p>\n

\/\/ \u4e0a\u4f20\u5931\u8d25
\nfunction handleUploadError() {
\n proxy.$modal.msgError("\u4e0a\u4f20excel\u5931\u8d25");
\n uploadRef.value.clearFiles();
\n proxy.$modal.closeLoading();
\n}<\/p>\n

\/\/ \u4e0a\u4f20\u6210\u529f\u56de\u8c03
\nfunction handleUploadSuccess(res, file) {
\n if (res.code === 200) {
\n proxy.$modal.msgSuccess("\u4e0a\u4f20excel\u6210\u529f");
\n excelOpen.value = false;
\n getList();
\n }else{
\n proxy.$modal.msgError("res.msg");
\n }
\n uploadRef.value.clearFiles();
\n proxy.$modal.closeLoading();
\n}
\n<\/script> <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.2 \u5bfc\u5165\u529f\u80fd\u7684\u540e\u7aef\u5177\u4f53\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u4e0e\u5bfc\u51fa Excel \u529f\u80fd\u4e00\u6837，\u521b\u5efa\u4e86 ExcelUtil \u5bf9\u8c61，\u4f7f\u7528\u8be5\u5bf9\u8c61\u7684 importExcel() \u65b9\u6cd5，\u5c06\u6587\u4ef6\u6d41\u8fdb\u884c\u5bfc\u5165，\u8fd4\u56de\u7684\u7ed3\u679c\u662f\u4e00\u4e2a List \u96c6\u5408\u6570\u636e，\u63a5\u4e0b\u6765\u53ef\u4ee5\u8fdb\u884c\u6279\u91cf\u63d2\u5165\u6570\u636e\u4e86\u3002<\/p>\n<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.3 \u4f7f\u7528 EasyExcel \u6846\u67b6\u5b9e\u73b0 Excel \u8bfb\u3001\u5199\u529f\u80fd<\/h3>\n

\u00a0 \u00a0 \u00a0 \u00a0 EasyExcel \u5b98\u7f51：EasyExcel\u5b98\u65b9\u6587\u6863 – \u57fa\u4e8eJava\u7684Excel\u5904\u7406\u5de5\u5177 | Easy Excel \u5b98\u7f51<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u963f\u91cc\u5df4\u5df4\u5f00\u6e90\u7684\u6846\u67b6，\u5b83\u4ee5\u4f7f\u7528\u7b80\u5355\u3001\u529f\u80fd\u5f3a\u5927\u548c\u8282\u7701\u5185\u5b58\u800c\u8457\u79f0，\u7279\u522b\u9002\u5408\u4e8e\u9700\u8981\u8fdb\u884c\u5927\u91cf\u6570\u636e\u5bfc\u5165\u548c\u5bfc\u51fa\u7684\u573a\u666f\u3002<\/p>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Java \u89e3\u6790\u3001\u751f\u6210 Excel \u6bd4\u8f83\u6709\u540d\u7684\u6846\u67b6\u6709 Apache poi\u3001jxl\u3002\u4f46\u4ed6\u4eec\u90fd\u5b58\u5728\u4e00\u4e2a\u4e25\u91cd\u7684\u95ee\u9898\u5c31\u662f\u975e\u5e38\u7684\u8017\u5185\u5b58，poi \u6709\u4e00\u5957 SAX \u6a21\u5f0f\u7684 API \u53ef\u4ee5\u4e00\u5b9a\u7a0b\u5ea6\u7684\u89e3\u51b3\u4e00\u4e9b\u5185\u5b58\u6ea2\u51fa\u7684\u95ee\u9898，\u4f46 POI \u8fd8\u662f\u6709\u4e00\u4e9b\u7f3a\u9677，\u6bd4\u5982 07 \u7248 Excel \u89e3\u538b\u7f29\u4ee5\u53ca\u89e3\u538b\u540e\u5b58\u50a8\u90fd\u662f\u5728\u5185\u5b58\u4e2d\u5b8c\u6210\u7684，\u5185\u5b58\u6d88\u8017\u4f9d\u7136\u5f88\u5927\u3002 easyexcel \u91cd\u5199\u4e86 poi \u5bf9 07 \u7248 Excel \u7684\u89e3\u6790，\u4e00\u4e2a 3M \u7684 excel \u7528 POI sax \u89e3\u6790\u4f9d\u7136\u9700\u8981 100M \u5de6\u53f3\u5185\u5b58，\u6539\u7528 easyexcel \u53ef\u4ee5\u964d\u4f4e\u5230 \u51e0M，\u5e76\u4e14\u518d\u5927\u7684 excel \u4e5f\u4e0d\u4f1a\u51fa\u73b0\u5185\u5b58\u6ea2\u51fa；03 \u7248\u4f9d\u8d56 POI \u7684 sax \u6a21\u5f0f，\u5728\u4e0a\u5c42\u505a\u4e86\u6a21\u578b\u8f6c\u6362\u7684\u5c01\u88c5，\u8ba9\u4f7f\u7528\u8005\u66f4\u52a0\u7b80\u5355\u65b9\u4fbf\u3002<\/p>\n<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1.4 \u5c06 Easy Excel \u96c6\u6210\u5230\u82e5\u4f9d\u6846\u67b6\u4e2d<\/h3>\n

\u00a0 \u00a0 \u00a0 \u00a0 1）dkd-common\\\\pom.xml \u6a21\u5757\u6dfb\u52a0\u6574\u5408\u4f9d\u8d56：<\/p>\n

<!– excel\u5904\u7406\u5de5\u5177–>
\n<dependency>
\n <groupId>com.alibaba<\/groupId>
\n <artifactId>easyexcel<\/artifactId>
\n <version>4.0.1<\/version>
\n<\/dependency> <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2）\u5728 dkd-common\\\\ \u6a21\u5757\u7684 ExcelUtil.java \u65b0\u589e easyexcel \u5bfc\u51fa\u5bfc\u5165\u65b9\u6cd5：<\/p>\n

\/**
\n * \u5bf9excel\u8868\u5355\u9ed8\u8ba4\u7b2c\u4e00\u4e2a\u7d22\u5f15\u540d\u8f6c\u6362\u6210list（EasyExcel）
\n *
\n * @param is \u8f93\u5165\u6d41
\n * @return \u8f6c\u6362\u540e\u96c6\u5408
\n *\/
\npublic List<T> importEasyExcel(InputStream is) throws Exception
\n{
\nreturn EasyExcel.read(is).head(clazz).sheet().doReadSync();
\n}<\/p>\n

\/**
\n * \u5bf9list\u6570\u636e\u6e90\u5c06\u5176\u91cc\u9762\u7684\u6570\u636e\u5bfc\u5165\u5230excel\u8868\u5355（EasyExcel）
\n *
\n * @param list \u5bfc\u51fa\u6570\u636e\u96c6\u5408
\n * @param sheetName \u5de5\u4f5c\u8868\u7684\u540d\u79f0
\n * @return \u7ed3\u679c
\n *\/
\npublic void exportEasyExcel(HttpServletResponse response, List<T> list, String sheetName)
\n{
\ntry
\n{
\nEasyExcel.write(response.getOutputStream(), clazz).sheet(sheetName).doWrite(list);
\n}
\ncatch (IOException e)
\n{
\nlog.error("\u5bfc\u51faEasyExcel\u5f02\u5e38{}", e.getMessage());
\n}
\n} <\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 3）\u5b9e\u4f53\u7c7b\u7684\u5c5e\u6027\u4e0a\u6dfb\u52a0\u00a0@ExcelProperty \u6ce8\u89e3：<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u6dfb\u52a0\u5b8c @ExcelPropety \u6ce8\u89e3\u4e4b\u540e，\u5b9e\u73b0\u5b9e\u4f53\u7c7b\u7684\u5c5e\u6027\u4e0e Excel \u8868\u683c\u5b57\u6bb5\u6620\u5c04\u3002\u8fd8\u9700\u8981\u5728\u5b9e\u4f53\u7c7b\u4e0a\u6dfb\u52a0\u6ce8\u89e3：<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 – @ExcelIgnoreUnannotated\/\/ \u6ce8\u89e3\u8868\u793a\u5728\u5bfc\u51faExcel\u65f6，\u5ffd\u7565\u6ca1\u6709\u88ab\u4efb\u4f55\u6ce8\u89e3\u6807\u8bb0\u7684\u5b57\u6bb5 \u00a0 \u00a0 \u00a0 \u00a0 – @ColumnWidth(16)\/\/ \u6ce8\u89e3\u7528\u4e8e\u8bbe\u7f6e\u5217\u7684\u5bbd\u5ea6 \u00a0 \u00a0 \u00a0 \u00a0 – @HeadRowHeight(14)\/\/ \u6ce8\u89e3\u7528\u4e8e\u8bbe\u7f6e\u8868\u5934\u884c\u7684\u9ad8\u5ea6 \u00a0 \u00a0 \u00a0 \u00a0 – @HeadFontStyle(fontHeightInPoints = 11)\/\/ \u6ce8\u89e3\u7528\u4e8e\u8bbe\u7f6e\u8868\u5934\u7684\u5b57\u4f53\u6837\u5f0f<\/p>\n

\u4e3e\u4e2a\u4f8b\u5b50：<\/p>\n

package com.dkd.manage.domain;<\/p>\n

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
\nimport com.alibaba.excel.annotation.ExcelProperty;
\nimport com.alibaba.excel.annotation.write.style.ColumnWidth;
\nimport com.alibaba.excel.annotation.write.style.HeadFontStyle;
\nimport com.alibaba.excel.annotation.write.style.HeadRowHeight;
\nimport com.dkd.common.annotation.Excel;
\nimport com.dkd.common.core.domain.BaseEntity;
\nimport org.apache.commons.lang3.builder.ToStringBuilder;
\nimport org.apache.commons.lang3.builder.ToStringStyle;<\/p>\n

\/**
\n * \u5546\u54c1\u7ba1\u7406\u5bf9\u8c61 tb_sku
\n *
\n * @author itheima
\n * @date 2024-07-15
\n *\/
\n@ExcelIgnoreUnannotated\/\/ \u6ce8\u89e3\u8868\u793a\u5728\u5bfc\u51faExcel\u65f6，\u5ffd\u7565\u6ca1\u6709\u88ab\u4efb\u4f55\u6ce8\u89e3\u6807\u8bb0\u7684\u5b57\u6bb5
\n@ColumnWidth(16)\/\/ \u6ce8\u89e3\u7528\u4e8e\u8bbe\u7f6e\u5217\u7684\u5bbd\u5ea6
\n@HeadRowHeight(14)\/\/ \u6ce8\u89e3\u7528\u4e8e\u8bbe\u7f6e\u8868\u5934\u884c\u7684\u9ad8\u5ea6
\n@HeadFontStyle(fontHeightInPoints = 11)\/\/ \u6ce8\u89e3\u7528\u4e8e\u8bbe\u7f6e\u8868\u5934\u7684\u5b57\u4f53\u6837\u5f0f
\npublic class Sku extends BaseEntity
\n{
\n private static final long serialVersionUID = 1L;<\/p>\n

\/** \u4e3b\u952e *\/
\n private Long skuId;<\/p>\n

\/** \u5546\u54c1\u540d\u79f0 *\/
\n @Excel(name = "\u5546\u54c1\u540d\u79f0")
\n @ExcelProperty("\u5546\u54c1\u540d\u79f0")
\n private String skuName;<\/p>\n

\/** \u5546\u54c1\u56fe\u7247 *\/
\n @Excel(name = "\u5546\u54c1\u56fe\u7247")
\n @ExcelProperty("\u5546\u54c1\u56fe\u7247")
\n private String skuImage;<\/p>\n

\/** \u54c1\u724c *\/
\n @Excel(name = "\u54c1\u724c")
\n @ExcelProperty("\u54c1\u724c")
\n private String brandName;<\/p>\n

\/** \u89c4\u683c(\u51c0\u542b\u91cf) *\/
\n @Excel(name = "\u89c4\u683c(\u51c0\u542b\u91cf)")
\n @ExcelProperty("\u89c4\u683c(\u51c0\u542b\u91cf)")
\n private String unit;<\/p>\n

\/** \u5546\u54c1\u4ef7\u683c *\/
\n @Excel(name = "\u5546\u54c1\u4ef7\u683c")
\n @ExcelProperty("\u5546\u54c1\u4ef7\u683c")
\n private Long price;<\/p>\n

\/** \u5546\u54c1\u7c7b\u578bId *\/
\n @Excel(name = "\u5546\u54c1\u7c7b\u578bId")
\n @ExcelProperty("\u5546\u54c1\u7c7b\u578bId")
\n private Long classId;<\/p>\n

\/** \u662f\u5426\u6253\u6298\u4fc3\u9500 *\/
\n private Integer isDiscount;<\/p>\n

\/\/ \u5176\u4ed6\u7565…
\n} <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u5b8c\u6210\u4e4b\u540e，\u5c31\u53ef\u4ee5\u4f7f\u7528\u4e86，\u901a\u8fc7\u521b\u5efa ExcelUtil \u5bf9\u8c61，\u8c03\u7528\u00a0importEasyExcel() \u65b9\u6cd5\u5b9e\u73b0\u5bfc\u5165\u529f\u80fd，\u8c03\u7528\u00a0exportEasyExcel() \u65b9\u6cd5\u5b9e\u73b0\u5bfc\u51fa\u529f\u80fd\u3002<\/p>\n

\u4e3e\u4e2a\u4f8b\u5b50：<\/p>\n

\"\"<\/p>\n

\u5bfc\u51fa\u7ed3\u679c：<\/p>\n

\"\"<\/p>\n<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02.0 \u963f\u91cc\u4e91 OSS \u6982\u8ff0<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u963f\u91cc\u4e91\u5bf9\u8c61\u5b58\u50a8 OSS（Object Storage Service），\u662f\u4e00\u6b3e\u6d77\u91cf\u3001\u5b89\u5168\u3001\u4f4e\u6210\u672c\u3001\u9ad8\u53ef\u9760\u7684\u4e91\u5b58\u50a8\u670d\u52a1\u3002\u4f7f\u7528 OSS，\u60a8\u53ef\u4ee5\u901a\u8fc7\u7f51\u7edc\u968f\u65f6\u5b58\u50a8\u548c\u8c03\u7528\u5305\u62ec\u6587\u672c\u3001\u56fe\u7247\u3001\u97f3\u9891\u548c\u89c6\u9891\u7b49\u5728\u5185\u7684\u5404\u79cd\u6587\u4ef6\u3002<\/p>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4f7f\u7528\u4e86\u963f\u91cc\u4e91 OSS \u5bf9\u8c61\u5b58\u50a8\u670d\u52a1\u4e4b\u540e，\u6211\u4eec\u7684\u9879\u76ee\u5f53\u4e2d\u5982\u679c\u6d89\u53ca\u5230\u6587\u4ef6\u4e0a\u4f20\u8fd9\u6837\u7684\u4e1a\u52a1，\u5728\u524d\u7aef\u8fdb\u884c\u6587\u4ef6\u4e0a\u4f20\u5e76\u8bf7\u6c42\u5230\u670d\u52a1\u7aef\u65f6，\u5728\u670d\u52a1\u5668\u672c\u5730\u78c1\u76d8\u5f53\u4e2d\u5c31\u4e0d\u9700\u8981\u518d\u6765\u5b58\u50a8\u6587\u4ef6\u4e86\u3002\u6211\u4eec\u76f4\u63a5\u5c06\u63a5\u6536\u5230\u7684\u6587\u4ef6\u4e0a\u4f20\u5230 oss，\u7531 oss \u5e2e\u6211\u4eec\u5b58\u50a8\u548c\u7ba1\u7406，\u540c\u65f6\u963f\u91cc\u4e91\u7684 oss \u5b58\u50a8\u670d\u52a1\u8fd8\u4fdd\u969c\u4e86\u6211\u4eec\u6240\u5b58\u50a8\u5185\u5bb9\u7684\u5b89\u5168\u53ef\u9760\u3002<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2.1 \u4f7f\u7528\u963f\u91cc\u4e91 OSS \u5177\u4f53\u8fc7\u7a0b<\/h3>\n

\u00a0 \u00a0 \u00a0 \u00a0 1）\u6ce8\u518c\u963f\u91cc\u4e91\u8d26\u6237（\u6ce8\u518c\u5b8c\u6210\u540e\u9700\u8981\u5b9e\u540d\u8ba4\u8bc1）<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2）\u6ce8\u518c\u5b8c\u8d26\u53f7\u4e4b\u540e，\u5c31\u53ef\u4ee5\u767b\u5f55\u963f\u91cc\u4e91<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 3）\u901a\u8fc7\u63a7\u5236\u53f0\u627e\u5230\u5bf9\u8c61\u5b58\u50a8 OSS \u670d\u52a1<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 4）\u5982\u679c\u662f\u7b2c\u4e00\u6b21\u8bbf\u95ee，\u8fd8\u9700\u8981\u5f00\u901a\u5bf9\u8c61\u5b58\u50a8\u670d\u52a1 OSS<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 5）\u5f00\u901a OSS \u670d\u52a1\u4e4b\u540e，\u5c31\u53ef\u4ee5\u8fdb\u5165\u5230\u963f\u91cc\u4e91\u5bf9\u8c61\u5b58\u50a8\u7684\u63a7\u5236\u53f0<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 6）\u70b9\u51fb\u5de6\u4fa7\u7684 "Bucket\u5217\u8868"，\u521b\u5efa\u4e00\u4e2aBucket<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 7）\u70b9\u51fb "AccessKey\u7ba1\u7406"，\u8fdb\u5165\u5230\u7ba1\u7406\u9875\u9762<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 8）\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u6253\u5f00CMD\u547d\u4ee4\u884c，\u6267\u884c\u5982\u4e0b\u547d\u4ee4，\u914d\u7f6e\u7cfb\u7edf\u7684\u73af\u5883\u53d8\u91cf<\/p>\n

set OSS_ACCESS_KEY_ID=LTAI5tXXXXXXXXXXXXXXXXXXXXM8TP
\nset OSS_ACCESS_KEY_SECRET=UzMcJXXXXXXXXXXXXXXXXXXXXdabTNafi <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5c06\u4e0a\u8ff0\u7684ACCESS_KEY_ID \u4e0e ACCESS_KEY_SECRET \u7684\u503c\u4e00\u5b9a\u8981\u66ff\u6362\u6210\u81ea\u5df1\u7684 \u3002<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u6267\u884c\u5982\u4e0b\u547d\u4ee4，\u8ba9\u66f4\u6539\u751f\u6548：<\/p>\n

setx OSS_ACCESS_KEY_ID "%OSS_ACCESS_KEY_ID%"
\nsetx OSS_ACCESS_KEY_SECRET "%OSS_ACCESS_KEY_SECRET%" <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u6267\u884c\u5982\u4e0b\u547d\u4ee4，\u9a8c\u8bc1\u73af\u5883\u53d8\u91cf\u662f\u5426\u751f\u6548：<\/p>\n

echo %OSS_ACCESS_KEY_ID%
\necho %OSS_ACCESS_KEY_SECRET% <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u963f\u91cc\u4e91oss \u5bf9\u8c61\u5b58\u50a8\u670d\u52a1\u7684\u51c6\u5907\u5de5\u4f5c\u6211\u4eec\u5df2\u7ecf\u5b8c\u6210\u4e86，\u63a5\u4e0b\u6765\u6211\u4eec\u5c31\u6765\u5b8c\u6210\u7b2c\u4e8c\u6b65\u64cd\u4f5c：\u53c2\u7167\u5b98\u65b9\u6240\u63d0\u4f9b\u7684sdk\u793a\u4f8b\u6765\u7f16\u5199\u5165\u95e8\u7a0b\u5e8f\u3002<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1）\u9996\u5148\u6211\u4eec\u9700\u8981\u6765\u6253\u5f00\u963f\u91cc\u4e91OSS\u7684\u5b98\u65b9\u6587\u6863，\u5728\u5b98\u65b9\u6587\u6863\u4e2d\u627e\u5230 SDK \u7684\u793a\u4f8b\u4ee3\u7801：<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2）\u6587\u6863\u9605\u8bfb：<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 3）\u53c2\u7167\u5b98\u65b9\u63d0\u4f9b\u7684SDK，\u6539\u9020\u4e00\u4e0b，\u5373\u53ef\u5b9e\u73b0\u6587\u4ef6\u4e0a\u4f20\u529f\u80fd：<\/p>\n

package com.dkd.common.test;<\/p>\n

import com.aliyun.oss.ClientException;
\nimport com.aliyun.oss.OSS;
\nimport com.aliyun.oss.common.auth.*;
\nimport com.aliyun.oss.OSSClientBuilder;
\nimport com.aliyun.oss.OSSException;
\nimport com.aliyun.oss.model.PutObjectRequest;
\nimport com.aliyun.oss.model.PutObjectResult;
\nimport java.io.FileInputStream;
\nimport java.io.InputStream;<\/p>\n

public class Demo {<\/p>\n

public static void main(String[] args) throws Exception {
\n \/\/ Endpoint\u4ee5\u534e\u4e1c1（\u676d\u5dde）\u4e3a\u4f8b，\u5176\u5b83Region\u8bf7\u6309\u5b9e\u9645\u60c5\u51b5\u586b\u5199\u3002
\n String endpoint = "https:\/\/oss-cn-beijing.aliyuncs.com";
\n \/\/ \u4ece\u73af\u5883\u53d8\u91cf\u4e2d\u83b7\u53d6\u8bbf\u95ee\u51ed\u8bc1\u3002\u8fd0\u884c\u672c\u4ee3\u7801\u793a\u4f8b\u4e4b\u524d，\u8bf7\u786e\u4fdd\u5df2\u8bbe\u7f6e\u73af\u5883\u53d8\u91cfOSS_ACCESS_KEY_ID\u548cOSS_ACCESS_KEY_SECRET\u3002
\n EnvironmentVariableCredentialsProvider credentialsProvider = CredentialsProviderFactory.newEnvironmentVariableCredentialsProvider();
\n \/\/ \u586b\u5199Bucket\u540d\u79f0，\u4f8b\u5982examplebucket\u3002
\n String bucketName = "dkd-itheima";
\n \/\/ \u586b\u5199Object\u5b8c\u6574\u8def\u5f84，\u5b8c\u6574\u8def\u5f84\u4e2d\u4e0d\u80fd\u5305\u542bBucket\u540d\u79f0，\u4f8b\u5982exampledir\/exampleobject.txt\u3002
\n String objectName = "gao.png";
\n \/\/ \u586b\u5199\u672c\u5730\u6587\u4ef6\u7684\u5b8c\u6574\u8def\u5f84，\u4f8b\u5982D:\\\\\\\\localpath\\\\\\\\examplefile.txt\u3002
\n \/\/ \u5982\u679c\u672a\u6307\u5b9a\u672c\u5730\u8def\u5f84，\u5219\u9ed8\u8ba4\u4ece\u793a\u4f8b\u7a0b\u5e8f\u6240\u5c5e\u9879\u76ee\u5bf9\u5e94\u672c\u5730\u8def\u5f84\u4e2d\u4e0a\u4f20\u6587\u4ef6\u6d41\u3002
\n String filePath= "E:\\\\\\\\temp\\\\\\\\upload\\\\\\\\gao.png";<\/p>\n

\/\/ \u521b\u5efaOSSClient\u5b9e\u4f8b\u3002
\n OSS ossClient = new OSSClientBuilder().build(endpoint, credentialsProvider);<\/p>\n

try {
\n InputStream inputStream = new FileInputStream(filePath);
\n \/\/ \u521b\u5efaPutObjectRequest\u5bf9\u8c61\u3002
\n PutObjectRequest putObjectRequest = new PutObjectRequest(bucketName, objectName, inputStream);
\n \/\/ \u521b\u5efaPutObject\u8bf7\u6c42\u3002
\n PutObjectResult result = ossClient.putObject(putObjectRequest);
\n } catch (OSSException oe) {
\n System.out.println("Caught an OSSException, which means your request made it to OSS, "
\n + "but was rejected with an error response for some reason.");
\n System.out.println("Error Message:" + oe.getErrorMessage());
\n System.out.println("Error Code:" + oe.getErrorCode());
\n System.out.println("Request ID:" + oe.getRequestId());
\n System.out.println("Host ID:" + oe.getHostId());
\n } catch (ClientException ce) {
\n System.out.println("Caught an ClientException, which means the client encountered "
\n + "a serious internal problem while trying to communicate with OSS, "
\n + "such as not being able to access the network.");
\n System.out.println("Error Message:" + ce.getMessage());
\n } finally {
\n if (ossClient != null) {
\n ossClient.shutdown();
\n }
\n }
\n }
\n} <\/p>\n

\u5728\u4ee5\u4e0a\u4ee3\u7801\u4e2d，\u9700\u8981\u66ff\u6362\u7684\u5185\u5bb9\u4e3a：<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 – endpoint：\u963f\u91cc\u4e91OSS\u4e2d\u7684bucket\u5bf9\u5e94\u7684\u57df\u540d<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 – bucketName：Bucket\u540d\u79f0<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 – objectName：\u5bf9\u8c61\u540d\u79f0，\u5728Bucket\u4e2d\u5b58\u50a8\u7684\u5bf9\u8c61\u7684\u540d\u79f0<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 – filePath：\u6587\u4ef6\u8def\u5f84<\/span><\/p>\n

\u8fd0\u884c\u4ee5\u4e0a\u7a0b\u5e8f\u540e，\u4f1a\u628a\u672c\u5730\u7684\u6587\u4ef6\u4e0a\u4f20\u5230\u963f\u91cc\u4e91OSS\u670d\u52a1\u5668\u4e0a\u3002<\/p>\n<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2.2 \u5c06 X-File-Storage \u96c6\u6210\u5230\u82e5\u4f9d\u6846\u67b6\u4e2d<\/h3>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u76f8\u6bd4\u76f4\u63a5\u4f7f\u7528\u963f\u91cc\u4e91 OSS，\u4f7f\u7528 X-File-Storage \u4e0a\u4f20\u56fe\u7247\u5230\u4e91\u670d\u52a1\u5668\u7684\u64cd\u4f5c\u4f1a\u66f4\u52a0\u5bb9\u6613，\u4f7f\u7528 X-File-Storage \u53ef\u4ee5\u7b80\u5316\u56fe\u7247\u4e0a\u4f20\u5230\u4e91\u670d\u52a1\u5668\u7684\u8fc7\u7a0b，\u7279\u522b\u662f\u5bf9\u4e8e\u90a3\u4e9b\u4e0d\u719f\u6089\u963f\u91cc\u4e91 OSS API \u6216\u8005\u5e0c\u671b\u51cf\u5c11\u5f00\u53d1\u5de5\u4f5c\u91cf\u7684\u5f00\u53d1\u8005\u6765\u8bf4\u3002X-File-Storage \u662f\u4e00\u4e2a\u62bd\u8c61\u5c42，\u5b83\u5c01\u88c5\u4e86\u5e95\u5c42\u5b58\u50a8\u670d\u52a1\u7684\u590d\u6742\u6027，\u63d0\u4f9b\u4e86\u66f4\u7b80\u5355\u3001\u66f4\u7edf\u4e00\u7684\u63a5\u53e3\u3002\u00a0<\/p>\n

\u5c06\u00a0X-File-Storage \u96c6\u6210\u5230\u82e5\u4f9d\u6846\u67b6\u4e2d\u7684\u6b65\u9aa4：<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 1）\u5728 dkd-common \u7684 pom.xml \u4e2d\u5f15\u5165\u4f9d\u8d56：<\/p>\n

<!– \u6587\u4ef6\u4e0a\u4f20–>
\n<dependency>
\n <groupId>org.dromara.x-file-storage<\/groupId>
\n <artifactId>x-file-storage-spring<\/artifactId>
\n <version>2.1.0<\/version>
\n<\/dependency>
\n<!– \u963f\u91cc\u4e91oss–>
\n<dependency>
\n <groupId>com.aliyun.oss<\/groupId>
\n <artifactId>aliyun-sdk-oss<\/artifactId>
\n <version>3.16.1<\/version>
\n<\/dependency> <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02）\u5728 dkd-admin \u7684 application.yml \u914d\u7f6e\u6587\u4ef6\u4e2d\u5148\u6dfb\u52a0\u4ee5\u4e0b\u57fa\u7840\u914d\u7f6e，\u518d\u6dfb\u52a0\u5bf9\u5e94\u5e73\u53f0\u7684\u914d\u7f6e：<\/p>\n

# \u6587\u4ef6\u4e0a\u4f20
\ndromara:
\n x-file-storage: #\u6587\u4ef6\u5b58\u50a8\u914d\u7f6e
\n default-platform: aliyun-oss-1 #\u9ed8\u8ba4\u4f7f\u7528\u7684\u5b58\u50a8\u5e73\u53f0
\n thumbnail-suffix: ".min.jpg" #\u7f29\u7565\u56fe\u540e\u7f00，\u4f8b\u5982\u3010.min.jpg\u3011\u3010.png\u3011
\n #\u5bf9\u5e94\u5e73\u53f0\u7684\u914d\u7f6e\u5199\u5728\u8fd9\u91cc，\u6ce8\u610f\u7f29\u8fdb\u8981\u5bf9\u9f50
\n aliyun-oss:
\n – platform: aliyun-oss-1 # \u5b58\u50a8\u5e73\u53f0\u6807\u8bc6
\n enable-storage: true # \u542f\u7528\u5b58\u50a8
\n access-key: ??
\n secret-key: ??
\n end-point: oss-cn-qingdao.aliyuncs.com
\n bucket-name: itheima-007
\n domain: https:\/\/itheima-007.oss-cn-qingdao.aliyuncs.com\/ # \u8bbf\u95ee\u57df\u540d，\u6ce8\u610f\u201c\/\u201d\u7ed3\u5c3e，\u4f8b\u5982：https:\/\/abc.oss-cn-shanghai.aliyuncs.com\/
\n base-path: dkd-images\/ # \u57fa\u7840\u8def\u5f84 <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03）\u5728 dkd-admin \u7684\u542f\u52a8\u7c7b\u4e0a\u52a0\u4e0a @EnableFileStorage \u6ce8\u89e3：<\/p>\n

@EnableFileStorage
\n@SpringBootApplication(exclude = { DataSourceAutoConfiguration.class })
\npublic class DkdApplication
\n{
\n public static void main(String[] args)
\n {
\n \/\/ System.setProperty("spring.devtools.restart.enabled", "false");
\n SpringApplication.run(DkdApplication.class, args);
\n System.out.println("(\u2665\u25e0\u203f\u25e0)ﾉﾞ \u5e1d\u53ef\u5f97\u542f\u52a8\u6210\u529f \u10da(\u00b4\u06a1`\u10da)ﾞ");
\n }
\n} <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 4）\u4fee\u6539\u82e5\u4f9d\u9ed8\u8ba4\u4e0a\u4f20\u56fe\u7247\u4ee3\u7801<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u627e\u5230 ruoyi-admin \u6a21\u5757\u4e2d\u7684 com.ruoyi.web.controller.common.CommonController \u7c7b，\u4fee\u6539\u5355\u4e2a\u6587\u4ef6\u4e0a\u4f20\u7684\u65b9\u6cd5：<\/p>\n

@Autowired
\nprivate FileStorageService fileStorageService;\/\/\u6ce8\u5165\u5b9e\u5217<\/p>\n

\/**
\n * \u901a\u7528\u4e0a\u4f20\u8bf7\u6c42（\u5355\u4e2a）
\n*\/
\n@PostMapping("\/upload")
\npublic AjaxResult uploadFile(MultipartFile file) throws Exception {<\/p>\n

try {
\n \/\/ \u6307\u5b9aoss\u4fdd\u5b58\u6587\u4ef6\u8def\u5f84
\n String objectName = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyy\/MM\/dd")) + "\/";
\n \/\/ \u4e0a\u4f20\u56fe\u7247，\u6210\u529f\u8fd4\u56de\u6587\u4ef6\u4fe1\u606f
\n FileInfo fileInfo = fileStorageService.of(file).setPath(objectName).upload();
\n \/\/ \u8bbe\u7f6e\u8fd4\u56de\u7ed3\u679c
\n AjaxResult ajax = AjaxResult.success();
\n ajax.put("url", fileInfo.getUrl());
\n ajax.put("fileName", fileInfo.getUrl()); \/\/\u6ce8\u610f：\u8fd9\u91cc\u7684\u503c\u8981\u6539\u4e3aurl，\u524d\u7aef\u8bbf\u95ee\u7684\u5730\u5740,\u9700\u8981\u6587\u4ef6\u7684\u5730\u5740 \u800c\u4e0d\u662f\u6587\u4ef6\u540d\u79f0
\n ajax.put("newFileName", fileInfo.getUrl());
\n ajax.put("originalFilename", file.getOriginalFilename());
\n return ajax;
\n } catch (Exception e) {
\n return AjaxResult.error(e.getMessage());
\n }
\n} <\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb8.4k\u6b21\uff0c\u70b9\u8d5e136\u6b21\uff0c\u6536\u85cf164\u6b21\u3002\u963f\u91cc\u4e91\u5bf9\u8c61\u5b58\u50a8 OSS\uff08Object Storage Service\uff09\uff0c\u662f\u4e00\u6b3e\u6d77\u91cf\u3001\u5b89\u5168\u3001\u4f4e\u6210\u672c\u3001\u9ad8\u53ef\u9760\u7684\u4e91\u5b58\u50a8\u670d\u52a1\u3002\u4f7f\u7528 OSS\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7\u7f51\u7edc\u968f\u65f6\u5b58\u50a8\u548c\u8c03\u7528\u5305\u62ec\u6587\u672c\u3001\u56fe\u7247\u3001\u97f3\u9891\u548c\u89c6\u9891\u7b49\u5728\u5185\u7684\u5404\u79cd\u6587\u4ef6\u3002\u4f7f\u7528\u4e86\u963f\u91cc\u4e91 OSS \u5bf9\u8c61\u5b58\u50a8\u670d\u52a1\u4e4b\u540e\uff0c\u6211\u4eec\u7684\u9879\u76ee\u5f53\u4e2d\u5982\u679c\u6d89\u53ca\u5230\u6587\u4ef6\u4e0a\u4f20\u8fd9\u6837\u7684\u4e1a\u52a1\uff0c\u5728\u524d\u7aef\u8fdb\u884c\u6587\u4ef6\u4e0a\u4f20\u5e76\u8bf7\u6c42\u5230\u670d\u52a1\u7aef\u65f6\uff0c\u5728\u670d\u52a1\u5668\u672c\u5730\u78c1\u76d8\u5f53\u4e2d\u5c31\u4e0d\u9700\u8981\u518d\u6765\u5b58\u50a8\u6587\u4ef6\u4e86\u3002\u6211\u4eec\u76f4\u63a5\u5c06\u63a5\u6536\u5230\u7684\u6587\u4ef6\u4e0a\u4f20\u5230 oss\uff0c\u7531 oss \u5e2e\u6211\u4eec\u5b58\u50a8\u548c\u7ba1\u7406\uff0c\u540c\u65f6\u963f\u91cc\u4e91\u7684 oss \u5b58\u50a8\u670d\u52a1\u8fd8\u4fdd\u969c\u4e86\u6211\u4eec\u6240\u5b58\u50a8\u5185\u5bb9\u7684\u5b89\u5168\u53ef\u9760\u3002<\/p>\n","protected":false},"author":2,"featured_media":8273,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,101,98,97,100,95,96],"topic":[],"class_list":["post-8293","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-java","tag-spring","tag-spring-boot","tag-97","tag-100","tag-95","tag-96"],"yoast_head":"\n\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/8293.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb8.4k\u6b21\uff0c\u70b9\u8d5e136\u6b21\uff0c\u6536\u85cf164\u6b21\u3002\u963f\u91cc\u4e91\u5bf9\u8c61\u5b58\u50a8 OSS\uff08Object Storage Service\uff09\uff0c\u662f\u4e00\u6b3e\u6d77\u91cf\u3001\u5b89\u5168\u3001\u4f4e\u6210\u672c\u3001\u9ad8\u53ef\u9760\u7684\u4e91\u5b58\u50a8\u670d\u52a1\u3002\u4f7f\u7528 OSS\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7\u7f51\u7edc\u968f\u65f6\u5b58\u50a8\u548c\u8c03\u7528\u5305\u62ec\u6587\u672c\u3001\u56fe\u7247\u3001\u97f3\u9891\u548c\u89c6\u9891\u7b49\u5728\u5185\u7684\u5404\u79cd\u6587\u4ef6\u3002\u4f7f\u7528\u4e86\u963f\u91cc\u4e91 OSS \u5bf9\u8c61\u5b58\u50a8\u670d\u52a1\u4e4b\u540e\uff0c\u6211\u4eec\u7684\u9879\u76ee\u5f53\u4e2d\u5982\u679c\u6d89\u53ca\u5230\u6587\u4ef6\u4e0a\u4f20\u8fd9\u6837\u7684\u4e1a\u52a1\uff0c\u5728\u524d\u7aef\u8fdb\u884c\u6587\u4ef6\u4e0a\u4f20\u5e76\u8bf7\u6c42\u5230\u670d\u52a1\u7aef\u65f6\uff0c\u5728\u670d\u52a1\u5668\u672c\u5730\u78c1\u76d8\u5f53\u4e2d\u5c31\u4e0d\u9700\u8981\u518d\u6765\u5b58\u50a8\u6587\u4ef6\u4e86\u3002\u6211\u4eec\u76f4\u63a5\u5c06\u63a5\u6536\u5230\u7684\u6587\u4ef6\u4e0a\u4f20\u5230 oss\uff0c\u7531 oss \u5e2e\u6211\u4eec\u5b58\u50a8\u548c\u7ba1\u7406\uff0c\u540c\u65f6\u963f\u91cc\u4e91\u7684 oss \u5b58\u50a8\u670d\u52a1\u8fd8\u4fdd\u969c\u4e86\u6211\u4eec\u6240\u5b58\u50a8\u5185\u5bb9\u7684\u5b89\u5168\u53ef\u9760\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/8293.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T08:29:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418082942-68020d76b80b1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/8293.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/8293.html\",\"name\":\"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-04-18T08:29:47+00:00\",\"dateModified\":\"2025-04-18T08:29:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/8293.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/8293.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/8293.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/8293.html","og_locale":"zh_CN","og_type":"article","og_title":"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb8.4k\u6b21\uff0c\u70b9\u8d5e136\u6b21\uff0c\u6536\u85cf164\u6b21\u3002\u963f\u91cc\u4e91\u5bf9\u8c61\u5b58\u50a8 OSS\uff08Object Storage Service\uff09\uff0c\u662f\u4e00\u6b3e\u6d77\u91cf\u3001\u5b89\u5168\u3001\u4f4e\u6210\u672c\u3001\u9ad8\u53ef\u9760\u7684\u4e91\u5b58\u50a8\u670d\u52a1\u3002\u4f7f\u7528 OSS\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7\u7f51\u7edc\u968f\u65f6\u5b58\u50a8\u548c\u8c03\u7528\u5305\u62ec\u6587\u672c\u3001\u56fe\u7247\u3001\u97f3\u9891\u548c\u89c6\u9891\u7b49\u5728\u5185\u7684\u5404\u79cd\u6587\u4ef6\u3002\u4f7f\u7528\u4e86\u963f\u91cc\u4e91 OSS \u5bf9\u8c61\u5b58\u50a8\u670d\u52a1\u4e4b\u540e\uff0c\u6211\u4eec\u7684\u9879\u76ee\u5f53\u4e2d\u5982\u679c\u6d89\u53ca\u5230\u6587\u4ef6\u4e0a\u4f20\u8fd9\u6837\u7684\u4e1a\u52a1\uff0c\u5728\u524d\u7aef\u8fdb\u884c\u6587\u4ef6\u4e0a\u4f20\u5e76\u8bf7\u6c42\u5230\u670d\u52a1\u7aef\u65f6\uff0c\u5728\u670d\u52a1\u5668\u672c\u5730\u78c1\u76d8\u5f53\u4e2d\u5c31\u4e0d\u9700\u8981\u518d\u6765\u5b58\u50a8\u6587\u4ef6\u4e86\u3002\u6211\u4eec\u76f4\u63a5\u5c06\u63a5\u6536\u5230\u7684\u6587\u4ef6\u4e0a\u4f20\u5230 oss\uff0c\u7531 oss \u5e2e\u6211\u4eec\u5b58\u50a8\u548c\u7ba1\u7406\uff0c\u540c\u65f6\u963f\u91cc\u4e91\u7684 oss \u5b58\u50a8\u670d\u52a1\u8fd8\u4fdd\u969c\u4e86\u6211\u4eec\u6240\u5b58\u50a8\u5185\u5bb9\u7684\u5b89\u5168\u53ef\u9760\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/8293.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-04-18T08:29:47+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418082942-68020d76b80b1.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/8293.html","url":"https:\/\/www.wsisp.com\/helps\/8293.html","name":"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-04-18T08:29:47+00:00","dateModified":"2025-04-18T08:29:47+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/8293.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/8293.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/8293.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u82e5\u4f9d\u6846\u67b6\u7bc7-\u82e5\u4f9d\u96c6\u6210 X-File-Storage \u6846\u67b6\uff08\u5b9e\u73b0\u56fe\u7247\u4e0a\u4f20\u963f\u91cc\u4e91 OSS \u670d\u52a1\u5668\uff09\u3001EasyExcel \u6846\u67b6\uff08\u5b9e\u73b0 Excel \u6570\u636e\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff09"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/8293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=8293"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/8293\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/8273"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=8293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=8293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=8293"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=8293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}