{"id":36952,"date":"2023-06-28T19:16:19","date_gmt":"2023-04-09T14:30:56","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/"},"modified":"2024-04-30T11:08:08","modified_gmt":"2024-04-30T03:08:08","slug":"%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/","title":{"rendered":"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427"},"content":{"rendered":"

\u80cc\u666f-
\n\u80cc\u666f<\/h1>\n

\u4f60\u7528\u8fc7POI\u5417\uff1f\u5982\u679c\u4f60\u611f\u5230\u9047\u5230\u4e86\u201c\u8d28\u91cf\u5dee\u7684\u96be\u4ee5\u7406\u89e3\u7684\u5b9e\u73b0\uff08Poor Obfuscation Implementation\uff09\u201d\uff0c\u90a3\u5c31\u53ef\u4ee5\u8bf4\u4f60\u6293\u4f4f\u4e86\u672c\u8d28^_^\u3002<\/p>\n

\u4ed4\u7ec6\u8003\u8651\u5bf9Excel\u6587\u4ef6\u7684\u64cd\u4f5c\uff0c\u53ef\u4ee5\u5206\u4e3a\u4e09\u79cd\u7c7b\u578b\uff1a
\n1. \u521b\u5efa\u6570\u636e\u8868
\n2. \u7f8e\u5316\u6570\u636e\u8868
\n3. \u6dfb\u52a0\u6c14\u6ce1\u3001\u6846\u7b49\u52a8\u4f5c<\/p>\n

\u6362\u53e5\u8bdd\u8bf4\uff0c\u6709\u4e09\u79cd\u5de5\u4f5c\uff0c\u5206\u522b\u662f”\u6570\u636e\u64cd\u4f5c”\u3001”\u683c\u5f0f\u64cd\u4f5c”\u548c”\u56fe\u5f62\u64cd\u4f5c”\u3002”\u6570\u636e\u64cd\u4f5c”\u76f8\u5bf9\u8f83\u7b80\u5355\uff0c\u53ea\u9700\u8fdb\u884cget\u6216set\u64cd\u4f5c\u3002\u800c”\u683c\u5f0f\u64cd\u4f5c”\u548c”\u56fe\u5f62\u64cd\u4f5c”\u5219\u6bd4\u8f83\u7e41\u7410\uff0c\u9700\u8981\u8bbe\u7f6e\u5404\u79cd\u7ebf\u6761\u989c\u8272\u3001\u6837\u5f0f\u3001\u9634\u5f71\u7b49\uff0c\u5982\u679c\u7528POI\u5b9e\u73b0\u7684\u8bdd\uff0c\u4ee3\u7801\u4f1a\u53d8\u5f97\u975e\u5e38\u5197\u957f\u3002<\/p>\n

\u7136\u800c\uff0c\u5982\u679c\u6211\u4eec\u624b\u52a8\u64cd\u4f5cExcel\uff0c\u5e94\u8be5\u6ca1\u6709\u4eba\u4f1a\u89c9\u5f97\u9ebb\u70e6\u3002\u56e0\u4e3a\u53ea\u8981\u590d\u5236\u7c98\u8d34\uff0c\u5c31\u53ef\u4ee5\u5c06\u6240\u6709\u4e1c\u897f\u6574\u9f50\u5730\u6392\u5217\u597d\u3002\u5982\u679c\u4f7f\u7528\u5237\u5b50\uff0c\u8fd8\u53ef\u4ee5\u66f4\u65b9\u4fbf\u3002\u5982\u679c\u80fd\u5c06\u8fd9\u79cd\u65b9\u6cd5\u6574\u5408\u5230API\u4e2d\uff0c\u90a3\u5c06\u4f1a\u53d8\u6210\u4e00\u79cd\u6613\u4e8e\u4f7f\u7528\u7684\u65b9\u6cd5\u5427\uff1f<\/p>\n

\u4ecb\u7d39 efw \u7684 Excel API<\/h1>\n

\u6574\u4f53\u5f62\u8c61<\/h2>\n
\n
\u7a2e\u985eAPI\u30d5\u30a1\u30a4\u30eb\u64cd\u4f5cnew<\/a>save<\/a>close<\/a>getSheetNames<\/a>
\n\u30b7\u30fc\u30c8\u64cd\u4f5ccreateSheet<\/a>removeSheet<\/a>setSheetOrder<\/a>setActiveSheet<\/a><\/p>\n

getMaxRow<\/a>setPrintArea<\/a>showSheet<\/a>hideSheet<\/a>
\n\u884c\u5217\u64cd\u4f5caddRow<\/a>delRow<\/a>showRow<\/a>hideRow<\/a><\/p>\n

showCol<\/a>hideCol<\/a><\/p>\n

getArray<\/a>getSingle<\/a>getValue<\/a>setCell<\/a>setLink<\/a>\u56f3\u5f62\u64cd\u4f5cisEncircled<\/a>encircle<\/a>addShape<\/a>addShapeInRange<\/a>replacePicture<\/a><\/div>\n<\/div>\n

\u6837\u672c<\/h1>\n

\u6211\u63d0\u4f9b\u4ee5\u4e0b\u4e09\u79cd\u6837\u672c\u3002<\/p>\n

efw \u7684 JavaScript \u4e8b\u4ef6\u793a\u4f8b<\/h2>\n
var<\/span> helloExcel_submit<\/span>=<\/span>{};<\/span>\r\nhelloExcel_submit<\/span>.<\/span>paramsFormat<\/span>=<\/span>{};<\/span>\r\nhelloExcel_submit<\/span>.<\/span>fire<\/span>=<\/span>function<\/span>(<\/span>params<\/span>){<\/span>\r\n\t\/\/\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\u6642\u3001\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\u4f5c\u6210<\/span>\r\n\tnew<\/span> Excel<\/span>(<\/span>\"<\/span>excel\/IamExcelTemplate.xlsx<\/span>\"<\/span>)<\/span>\r\n\t\/\/\u30b7\u30fc\u30c8\u4f5c\u6210\u6642\u3001\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\u4f5c\u6210<\/span>\r\n\t.<\/span>createSheet<\/span>(<\/span>\"<\/span>newSheet<\/span>\"<\/span>,<\/span>\"<\/span>templateSheet<\/span>\"<\/span>)<\/span>\r\n\t\/\/\u30bb\u30eb\u306b\u5024\u3092\u4ee3\u5165\u3068\u3068\u3082\u306b\u3001\u66f8\u5f0f\u306e\u30b3\u30d4\u30fc\u5143\u3092\u6307\u5b9a<\/span>\r\n\t.<\/span>setCell<\/span>(<\/span>\"<\/span>newSheet<\/span>\"<\/span>,<\/span>\"<\/span>B2<\/span>\"<\/span>,<\/span>\"<\/span>helloworld<\/span>\"<\/span>,<\/span>\"<\/span>templateSheet<\/span>\"<\/span>,<\/span>\"<\/span>A1<\/span>\"<\/span>)<\/span>\r\n\t\/\/\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u56f3\u5f62\u3092\u30b3\u30d4\u30fc\u3057\u3066\u3001\u65b0\u3057\u3044\u5834\u6240\u306b\u8cbc\u308a\u4ed8\u3051\u308b<\/span>\r\n\t.<\/span>addShape<\/span>(<\/span>\"<\/span>newSheet<\/span>\"<\/span>,<\/span>\"<\/span>C2<\/span>\"<\/span>,<\/span>\"<\/span>templateSheet<\/span>\"<\/span>,<\/span>\"<\/span>myCircle<\/span>\"<\/span>)<\/span>\r\n\t\/\/\u4fdd\u5b58\u3059\u308b<\/span>\r\n\t.<\/span>save<\/span>(<\/span>\"<\/span>myExcel.xlsx<\/span>\"<\/span>)<\/span>\r\n\t\/\/\u9589\u3058\u308b<\/span>\r\n\t.<\/span>close<\/span>();<\/span>\r\n\treturn<\/span> new<\/span> Result<\/span>().<\/span>attach<\/span>(<\/span>\"<\/span>myExcel.xlsx<\/span>\"<\/span>).<\/span>deleteAfterDownload<\/span>();<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u4f7f\u7528Java\u4e2d\u7684EFW\u7684Excel API\u793a\u4f8b\u3002<\/h2>\n
<%@ page <\/span>language=<\/span>\"java\"<\/span> contentType=<\/span>\"text\/html; charset=UTF-8\"<\/span> pageEncoding=<\/span>\"UTF-8\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"efw.excel.ExcelManager\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"efw.excel.Excel\"<\/span>%><\/span>\r\n<%<\/span>\r\n\/\/\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\u6642\u3001\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\u4f5c\u6210<\/span>\r\nExcel<\/span> excel<\/span>=<\/span>ExcelManager<\/span>.<\/span>open<\/span>(<\/span>\"excel\/IamExcelTemplate.xlsx\"<\/span>,<\/span> false<\/span>);<\/span>\r\n\/\/\u30b7\u30fc\u30c8\u4f5c\u6210\u6642\u3001\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\u4f5c\u6210<\/span>\r\nexcel<\/span>.<\/span>createSheet<\/span>(<\/span>\"newSheet\"<\/span>,<\/span>\"templateSheet\"<\/span>);<\/span>\r\n\/\/\u30bb\u30eb\u306b\u5024\u3092\u4ee3\u5165\u3068\u3068\u3082\u306b\u3001\u66f8\u5f0f\u306e\u30b3\u30d4\u30fc\u5143\u3092\u6307\u5b9a<\/span>\r\nexcel<\/span>.<\/span>setCellStringValue<\/span>(<\/span>\"newSheet\"<\/span>,<\/span>\"B2\"<\/span>,<\/span>\"helloworld\"<\/span>);<\/span>\r\nexcel<\/span>.<\/span>setCellStyle<\/span>(<\/span>\"newSheet\"<\/span>,<\/span>\"B2\"<\/span>,<\/span>\"templateSheet\"<\/span>,<\/span>\"A1\"<\/span>);<\/span>\r\n\/\/\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u56f3\u5f62\u3092\u30b3\u30d4\u30fc\u3057\u3066\u3001\u65b0\u3057\u3044\u5834\u6240\u306b\u8cbc\u308a\u4ed8\u3051\u308b<\/span>\r\nexcel<\/span>.<\/span>addShapeInCell<\/span>(<\/span>\"newSheet\"<\/span>,<\/span>\"C2\"<\/span>,<\/span> \"templateSheet\"<\/span>,<\/span>\"myCircle\"<\/span>,<\/span> \"\"<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>);<\/span>\r\n\/\/\u4fdd\u5b58\u3059\u308b<\/span>\r\nexcel<\/span>.<\/span>save<\/span>(<\/span>\"myExcel.xlsx\"<\/span>,<\/span> null<\/span>);<\/span>\r\n\/\/\u9589\u3058\u308b<\/span>\r\nExcelManager<\/span>.<\/span>close<\/span>(<\/span>excel<\/span>.<\/span>getKey<\/span>());<\/span>\r\n%><\/span>\r\n<\/code><\/pre>\n
\u539f\u59cb\u7684POI\u6837\u672c<\/h2>\n
\u4f60\u8ba4\u4e3a\u8fd9\u4e2a\u5b9e\u73b0\u5f88\u7cdf\u7cd5\u4e14\u96be\u4ee5\u9605\u8bfb\u5417\uff1f<\/p>\n
<%@ page <\/span>language=<\/span>\"java\"<\/span> contentType=<\/span>\"text\/html; charset=UTF-8\"<\/span> pageEncoding=<\/span>\"UTF-8\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"efw.file.FileManager\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"java.io.File\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"java.io.FileOutputStream\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"java.io.IOException\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.EncryptedDocumentException\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.Cell\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.PrintSetup\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.Row\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.Sheet\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.Workbook\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.WorkbookFactory\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.util.CellReference\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFDrawing\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFShape\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFSheet\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFClientAnchor\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFSimpleShape\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFTextParagraph\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFTextRun\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFPicture\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.xssf.usermodel.XSSFPictureData\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.openxml4j.opc.PackagePart\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"org.apache.poi.ss.usermodel.Font\"<\/span>%><\/span>\r\n<%@ page <\/span>import=<\/span>\"java.util.List\"<\/span>%><\/span>\r\n\r\n\r\n\r\n<%<\/span>\r\n\/\/\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u4e00\u6642\u30d5\u30a1\u30a4\u30eb\u306b\u30b3\u30d4\u30fc\u3059\u308b<\/span>\r\nFile<\/span> file<\/span>=<\/span>FileManager<\/span>.<\/span>get<\/span>(<\/span>\"excel\/IamExcelTemplate.xlsx\"<\/span>);<\/span>\r\nFile<\/span> tempFile<\/span>=<\/span>File<\/span>.<\/span>createTempFile<\/span>(<\/span>\"efw\"<\/span>,<\/span> \"\"<\/span>);<\/span>\r\nFileManager<\/span>.<\/span>duplicate<\/span>(<\/span>file<\/span>,<\/span> tempFile<\/span>);<\/span>\r\nWorkbook<\/span> workbook<\/span>=<\/span>WorkbookFactory<\/span>.<\/span>create<\/span>(<\/span>tempFile<\/span>);<\/span>\r\n\/\/\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b<\/span>\r\nSheet<\/span> sheet<\/span> =<\/span> workbook<\/span>.<\/span>cloneSheet<\/span>(<\/span>workbook<\/span>.<\/span>getSheetIndex<\/span>(<\/span>\"templateSheet\"<\/span>));<\/span>\r\nworkbook<\/span>.<\/span>setSheetName<\/span>(<\/span>workbook<\/span>.<\/span>getSheetIndex<\/span>(<\/span>sheet<\/span>.<\/span>getSheetName<\/span>()),<\/span> \"newSheet\"<\/span>);<\/span>\r\nSheet<\/span> tempSheet<\/span> =<\/span> workbook<\/span>.<\/span>getSheet<\/span>(<\/span>\"templateSheet\"<\/span>);<\/span>\r\n\/\/B2\u30bb\u30eb\u306b\u5024\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nCellReference<\/span> reference<\/span> =<\/span> new<\/span> CellReference<\/span>(<\/span>\"B2\"<\/span>);<\/span>\r\nRow<\/span> row<\/span> =<\/span> sheet<\/span>.<\/span>getRow<\/span>(<\/span>reference<\/span>.<\/span>getRow<\/span>());<\/span>\r\nCell<\/span> cell<\/span> =<\/span> null<\/span>;<\/span>\r\nif<\/span> (<\/span>row<\/span> ==<\/span> null<\/span>)<\/span> {<\/span>\r\n\trow<\/span> =<\/span> sheet<\/span>.<\/span>createRow<\/span>(<\/span>reference<\/span>.<\/span>getRow<\/span>());<\/span>\r\n\trow<\/span>.<\/span>setHeightInPoints<\/span>(<\/span>sheet<\/span>.<\/span>getDefaultRowHeightInPoints<\/span>());<\/span>\/\/\u521d\u671f\u9ad8\u3055\u3092\u8a2d\u5b9a<\/span>\r\n}<\/span>\r\ncell<\/span> =<\/span> row<\/span>.<\/span>getCell<\/span>(<\/span>reference<\/span>.<\/span>getCol<\/span>());<\/span>\r\nif<\/span> (<\/span>cell<\/span>==<\/span>null<\/span>){<\/span>\r\n\tcell<\/span>=<\/span>row<\/span>.<\/span>createCell<\/span>(<\/span>reference<\/span>.<\/span>getCol<\/span>());<\/span>\r\n}<\/span>\r\ncell<\/span>.<\/span>setCellValue<\/span>(<\/span>\"helloworld\"<\/span>);<\/span>\r\n\/\/B2\u30bb\u30eb\u306bA1\u306e\u66f8\u5f0f\u3092\u5229\u7528\u3059\u308b<\/span>\r\nCellReference<\/span> templateReference<\/span> =<\/span> new<\/span> CellReference<\/span>(<\/span>\"A1\"<\/span>);<\/span>\r\nRow<\/span> templateRow<\/span> =<\/span> tempSheet<\/span>.<\/span>getRow<\/span>(<\/span>templateReference<\/span>.<\/span>getRow<\/span>());<\/span>\r\nif<\/span> (<\/span>templateRow<\/span> !=<\/span> null<\/span>)<\/span> {<\/span>\r\n\tCell<\/span> templateCell<\/span>=<\/span>templateRow<\/span>.<\/span>getCell<\/span>(<\/span>templateReference<\/span>.<\/span>getCol<\/span>());<\/span>\r\n\tcell<\/span>.<\/span>setCellStyle<\/span>(<\/span>templateCell<\/span>.<\/span>getCellStyle<\/span>());<\/span>\r\n}<\/span>\r\n\/\/\u56f3\u5f62\u3092\u4f5c\u6210\u3059\u308b<\/span>\r\nCellReference<\/span> shapeReference<\/span> =<\/span> new<\/span> CellReference<\/span>(<\/span>\"C2\"<\/span>);<\/span>\r\nint<\/span> cellrow<\/span>=<\/span>shapeReference<\/span>.<\/span>getRow<\/span>();<\/span>\r\nint<\/span> cellcol<\/span>=<\/span>shapeReference<\/span>.<\/span>getCol<\/span>();<\/span>\r\n\r\nXSSFSheet<\/span> xsheet<\/span> =<\/span> (<\/span>XSSFSheet<\/span>)<\/span> workbook<\/span>.<\/span>getSheet<\/span>(<\/span>\"newSheet\"<\/span>);<\/span>\r\nXSSFSheet<\/span> xtemplateSheet<\/span>=(<\/span>XSSFSheet<\/span>)<\/span> workbook<\/span>.<\/span>getSheet<\/span>(<\/span>\"templateSheet\"<\/span>);<\/span>\r\n\r\nList<\/span><<\/span>XSSFShape<\/span>><\/span> templateShapes<\/span>=((<\/span>XSSFDrawing<\/span>)<\/span> xtemplateSheet<\/span>.<\/span>getDrawingPatriarch<\/span>()).<\/span>getShapes<\/span>();<\/span>\r\nfor<\/span> (<\/span>XSSFShape<\/span> templateShape<\/span> :<\/span> templateShapes<\/span>)<\/span> {<\/span>\r\n\tif<\/span> (<\/span>\"myCircle\"<\/span>.<\/span>equals<\/span>(<\/span>templateShape<\/span>.<\/span>getShapeName<\/span>()))<\/span> {<\/span>\r\n\t\tXSSFDrawing<\/span> patriarch<\/span>=<\/span>xsheet<\/span>.<\/span>getDrawingPatriarch<\/span>();<\/span>\r\n\t\tif<\/span>(<\/span>patriarch<\/span>==<\/span>null<\/span>)<\/span> patriarch<\/span> =<\/span> xsheet<\/span>.<\/span>createDrawingPatriarch<\/span>();<\/span>\r\n\t\tXSSFShape<\/span> shape<\/span>=<\/span>cloneShape<\/span>(<\/span>workbook<\/span>,<\/span>patriarch<\/span>,<\/span>templateShape<\/span>,<\/span>\"\"<\/span>);<\/span>\r\n\t\tXSSFClientAnchor<\/span> anchor<\/span>=(<\/span>XSSFClientAnchor<\/span>)(<\/span>shape<\/span>.<\/span>getAnchor<\/span>());<\/span>\r\n\t\tint<\/span> x<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> y<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> dx1<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> dy1<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> dx2<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> dy2<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> width<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tint<\/span> height<\/span>=<\/span>0<\/span>;<\/span>\r\n\t\tif<\/span>(<\/span>x<\/span>==<\/span>0<\/span>){<\/span>\r\n\t\t\tdx1<\/span>=<\/span>anchor<\/span>.<\/span>getDx1<\/span>();<\/span>\r\n\t\t}<\/span>\r\n\t\tif<\/span>(<\/span>y<\/span>==<\/span>0<\/span>){<\/span>\r\n\t\t\tdy1<\/span>=<\/span>anchor<\/span>.<\/span>getDy1<\/span>();<\/span>\r\n\t\t}<\/span>\r\n\t\tif<\/span>(<\/span>width<\/span>==<\/span>0<\/span>){<\/span>\r\n\t\t\twidth<\/span>=<\/span>anchor<\/span>.<\/span>getDx2<\/span>()-<\/span>anchor<\/span>.<\/span>getDx1<\/span>();<\/span>\r\n\t\t}<\/span>\r\n\t\tif<\/span>(<\/span>height<\/span>==<\/span>0<\/span>){<\/span>\r\n\t\t\theight<\/span>=<\/span>anchor<\/span>.<\/span>getDy2<\/span>()-<\/span>anchor<\/span>.<\/span>getDy1<\/span>();<\/span>\r\n\t\t}<\/span>\r\n\t\tdx2<\/span>=<\/span>width<\/span>+<\/span>dx1<\/span>;<\/span>\r\n\t\tdy2<\/span>=<\/span>height<\/span>+<\/span>dy1<\/span>;<\/span>\r\n\t\tanchor<\/span>.<\/span>setRow1<\/span>(<\/span>cellrow<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setRow2<\/span>(<\/span>cellrow<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setCol1<\/span>(<\/span>cellcol<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setCol2<\/span>(<\/span>cellcol<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setDx1<\/span>(<\/span>dx1<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setDy1<\/span>(<\/span>dy1<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setDx2<\/span>(<\/span>dx2<\/span>);<\/span>\r\n\t\tanchor<\/span>.<\/span>setDy2<\/span>(<\/span>dy2<\/span>);<\/span>\r\n\t\tbreak<\/span>;<\/span>\r\n\t}<\/span>\r\n}<\/span>\r\n\/\/\u76ee\u7684\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u4fdd\u5b58\u3059\u308b<\/span>\r\nFileOutputStream<\/span> fileOutputStream<\/span> =<\/span> new<\/span> FileOutputStream<\/span>(<\/span>FileManager<\/span>.<\/span>get<\/span>(<\/span>\"myExcel.xlsx\"<\/span>));<\/span>\r\nworkbook<\/span>.<\/span>setForceFormulaRecalculation<\/span>(<\/span>true<\/span>);<\/span>\r\nworkbook<\/span>.<\/span>write<\/span>(<\/span>fileOutputStream<\/span>);<\/span>\r\nfileOutputStream<\/span>.<\/span>close<\/span>();<\/span>\r\nworkbook<\/span>.<\/span>close<\/span>();<\/span>\r\n\/\/\u4e00\u6642\u30d5\u30a1\u30a4\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3059\u308b<\/span>\r\ntempFile<\/span>.<\/span>delete<\/span>();<\/span>\r\n%><\/span>\r\n<!-- \u4ee5\u4e0b\u306fclone\u95a2\u6570 --><\/span>\r\n<%!<\/span>\r\n\t\/**\r\n\t * XSSF\u306eShape\u3092\u30b3\u30d4\u30fc\u3059\u308b\r\n\t * @param patriarch\r\n\t * @param templateShape\r\n\t * @param value\r\n\t * @return\u3000\u4f5c\u6210\u3055\u308c\u305fshape\r\n\t *\/<\/span>\r\n\tXSSFShape<\/span> cloneShape<\/span>(<\/span>Workbook<\/span> workbook<\/span>,<\/span>XSSFDrawing<\/span> patriarch<\/span>,<\/span>XSSFShape<\/span> templateShape<\/span>,<\/span>String<\/span> value<\/span>){<\/span>\r\n\t\tString<\/span> clsNm<\/span>=<\/span>templateShape<\/span>.<\/span>getClass<\/span>().<\/span>getSimpleName<\/span>();<\/span>\r\n\t\tif<\/span> (<\/span>\"XSSFSimpleShape\"<\/span>.<\/span>equals<\/span>(<\/span>clsNm<\/span>))<\/span> {<\/span>\r\n\t\t\tXSSFSimpleShape<\/span> orgSimpleShape<\/span>=(<\/span>XSSFSimpleShape<\/span>)<\/span>templateShape<\/span>;<\/span>\r\n\t\t\tXSSFSimpleShape<\/span> simpleShape<\/span> =<\/span> patriarch<\/span>.<\/span>createSimpleShape<\/span>((<\/span>XSSFClientAnchor<\/span>)<\/span>orgSimpleShape<\/span>.<\/span>getAnchor<\/span>());<\/span>\r\n\t\t\tsimpleShape<\/span>.<\/span>getCTShape<\/span>().<\/span>set<\/span>(<\/span>orgSimpleShape<\/span>.<\/span>getCTShape<\/span>().<\/span>copy<\/span>());<\/span>\r\n\t\t\tif<\/span>(<\/span>orgSimpleShape<\/span>.<\/span>getTextParagraphs<\/span>().<\/span>size<\/span>()<\/span>><\/span>0<\/span>){<\/span>\r\n\t\t\t\tXSSFTextParagraph<\/span> tempParagraph<\/span>=<\/span>orgSimpleShape<\/span>.<\/span>getTextParagraphs<\/span>().<\/span>get<\/span>(<\/span>0<\/span>);<\/span>\r\n\t\t\t\tif<\/span>(<\/span>tempParagraph<\/span>.<\/span>getTextRuns<\/span>().<\/span>size<\/span>()<\/span>><\/span>0<\/span>){<\/span>\r\n\t\t\t\t\tXSSFTextRun<\/span> tempRun<\/span>=<\/span>tempParagraph<\/span>.<\/span>getTextRuns<\/span>().<\/span>get<\/span>(<\/span>0<\/span>);<\/span>\r\n\t\t\t\t\tsimpleShape<\/span>.<\/span>setText<\/span>(<\/span>tempRun<\/span>.<\/span>getText<\/span>());<\/span>\r\n\t\t\t\t\tif<\/span>(<\/span>simpleShape<\/span>.<\/span>getTextParagraphs<\/span>().<\/span>size<\/span>()<\/span>><\/span>0<\/span>){<\/span>\r\n\t\t\t\t\t\tXSSFTextParagraph<\/span> paragraph<\/span>=<\/span>simpleShape<\/span>.<\/span>getTextParagraphs<\/span>().<\/span>get<\/span>(<\/span>0<\/span>);<\/span>\r\n\t\t\t\t\t\tif<\/span>(<\/span>paragraph<\/span>.<\/span>getTextRuns<\/span>().<\/span>size<\/span>()<\/span>><\/span>0<\/span>){<\/span>\r\n\t\t\t\t\t\t\tXSSFTextRun<\/span> textRun<\/span>=<\/span> paragraph<\/span>.<\/span>getTextRuns<\/span>().<\/span>get<\/span>(<\/span>0<\/span>);<\/span>\r\n\t\t\t\t\t\t\tif<\/span> (<\/span>value<\/span>!=<\/span>null<\/span>)<\/span> {<\/span>\r\n\t\t\t\t\t\t\t\ttextRun<\/span>.<\/span>setText<\/span>(<\/span>value<\/span>);<\/span>\r\n\t\t\t\t\t\t\t}<\/span>else<\/span> {<\/span>\r\n\t\t\t\t\t\t\t\ttextRun<\/span>.<\/span>setText<\/span>(<\/span>tempRun<\/span>.<\/span>getText<\/span>());<\/span>\r\n\t\t\t\t\t\t\t}<\/span>\r\n\t\t\t\t\t\t\ttextRun<\/span>.<\/span>setFontSize<\/span>(<\/span>tempRun<\/span>.<\/span>getFontSize<\/span>());<\/span>\r\n\t\t\t\t\t\t\ttextRun<\/span>.<\/span>setCharacterSpacing<\/span>(<\/span>tempRun<\/span>.<\/span>getCharacterSpacing<\/span>());<\/span>\r\n\t\t\t\t\t\t\ttextRun<\/span>.<\/span>setFontColor<\/span>(<\/span>tempRun<\/span>.<\/span>getFontColor<\/span>());<\/span>\r\n\t\t\t\t\t\t\ttextRun<\/span>.<\/span>setFontFamily<\/span>(<\/span>tempRun<\/span>.<\/span>getFontFamily<\/span>(),<\/span> Font<\/span>.<\/span>DEFAULT_CHARSET<\/span>,<\/span> tempRun<\/span>.<\/span>getPitchAndFamily<\/span>(),<\/span> false<\/span>);<\/span>\r\n\t\t\t\t\t\t\tparagraph<\/span>.<\/span>setTextAlign<\/span>(<\/span>tempParagraph<\/span>.<\/span>getTextAlign<\/span>());<\/span>\r\n\t\t\t\t\t\t\tparagraph<\/span>.<\/span>setTextFontAlign<\/span>(<\/span>tempParagraph<\/span>.<\/span>getTextFontAlign<\/span>());<\/span>\r\n\t\t\t\t\t\t}<\/span>\r\n\t\t\t\t\t}<\/span>\r\n\t\t\t\t}<\/span>\r\n\t\t\t}<\/span>\r\n\t\t\treturn<\/span> (<\/span>XSSFShape<\/span>)<\/span>simpleShape<\/span>;<\/span>\r\n\t\t}<\/span>else<\/span> if<\/span> (<\/span>\"XSSFPicture\"<\/span>.<\/span>equals<\/span>(<\/span>clsNm<\/span>))<\/span> {<\/span>\r\n\t\t\tXSSFPicture<\/span> orgPicture<\/span>=(<\/span>XSSFPicture<\/span>)<\/span>templateShape<\/span>;<\/span>\r\n\t\t\tPackagePart<\/span> orgPackagePart<\/span>=<\/span> orgPicture<\/span>.<\/span>getPictureData<\/span>().<\/span>getPackagePart<\/span>();<\/span>\r\n\t\t\t@SuppressWarnings<\/span>(<\/span>\"unchecked\"<\/span>)<\/span>\r\n\t\t\tList<\/span><<\/span>XSSFPictureData<\/span>><\/span> allpictures<\/span>=(<\/span>List<\/span><<\/span>XSSFPictureData<\/span>><\/span>)<\/span> workbook<\/span>.<\/span>getAllPictures<\/span>();<\/span>\r\n\t\t\tint<\/span> pictureIndex<\/span>=-<\/span>1<\/span>;<\/span>\r\n\t\t\tfor<\/span>(<\/span>int<\/span> index<\/span>=<\/span>0<\/span>;<\/span>index<\/span><<\/span>allpictures<\/span>.<\/span>size<\/span>();<\/span>index<\/span>++)<\/span> {<\/span>\r\n\t\t\t\tPackagePart<\/span> packagePart<\/span>=<\/span>allpictures<\/span>.<\/span>get<\/span>(<\/span>index<\/span>).<\/span>getPackagePart<\/span>();<\/span>\r\n\t\t\t\tif<\/span> (<\/span>packagePart<\/span>.<\/span>equals<\/span>(<\/span>orgPackagePart<\/span>))<\/span> {<\/span>\r\n\t\t\t\t\tpictureIndex<\/span>=<\/span>index<\/span>;<\/span>\r\n\t\t\t\t\tbreak<\/span>;<\/span>\r\n\t\t\t\t}<\/span>\r\n\t\t\t}<\/span>\r\n\t\t\tXSSFPicture<\/span> picture<\/span> =<\/span> patriarch<\/span>.<\/span>createPicture<\/span>((<\/span>XSSFClientAnchor<\/span>)<\/span>orgPicture<\/span>.<\/span>getAnchor<\/span>(),<\/span>pictureIndex<\/span>);<\/span>\r\n\t\t\treturn<\/span> (<\/span>XSSFShape<\/span>)<\/span>picture<\/span>;<\/span>\r\n\t\t}<\/span>\r\n\t\treturn<\/span> null<\/span>;<\/span>\r\n\t}<\/span>\r\n%><\/span>\r\n<\/code><\/pre>\n
\"image.png\"<\/div>\n
\u83b7\u53d6\u73bb\u7483\u7f50<\/h1>\n
<dependency><\/span>\r\n    <groupId><\/span>io.github.efwgrp<\/groupId><\/span>\r\n    <artifactId><\/span>efw<\/artifactId><\/span>\r\n    <version><\/span>4.07.000<\/version><\/span>\r\n<\/dependency><\/span>\r\n<\/code><\/pre>\n
\u5982\u679c\u4f7f\u7528JDK15\u53ca\u4ee5\u4e0a\u7248\u672c\uff0c\u5219\u9700\u8981\u76f8\u5173\u7684jar\u6587\u4ef6\u3002<\/p>\n
<dependency><\/span>\r\n    <groupId><\/span>org.openjdk.nashorn<\/groupId><\/span>\r\n    <artifactId><\/span>nashorn-core<\/artifactId><\/span>\r\n    <version><\/span>15.4<\/version><\/span>\r\n<\/dependency><\/span>\r\n<\/code><\/pre>\n
\u8fd9\u662f\u6700\u5173\u952e\u7684\u5174\u8da3\u70b9\u4e86\u3002<\/p>\n
<dependency><\/span>\r\n    <groupId><\/span>org.apache.poi<\/groupId><\/span>\r\n    <artifactId><\/span>poi<\/artifactId><\/span>\r\n    <version><\/span>5.2.3<\/version><\/span>\r\n<\/dependency><\/span>\r\n<\/code><\/pre>\n
<dependency><\/span>\r\n    <groupId><\/span>org.apache.poi<\/groupId><\/span>\r\n    <artifactId><\/span>poi-ooxml<\/artifactId><\/span>\r\n    <version><\/span>5.2.3<\/version><\/span>\r\n<\/dependency><\/span>\r\n<\/code><\/pre>\n
\u8fd9\u6b21\u7684\u6837\u672c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u94fe\u63a5\u8fdb\u884c\u4e0b\u8f7d\u3002\u540c\u65f6\uff0c\u5b83\u5305\u542b\u4e86efw\u7684Excel\u64cd\u4f5cAPI\u7684\u6240\u6709\u6d4b\u8bd5\u3002\u5982\u679c\u4f60\u6709\u5174\u8da3\uff0c\u53ef\u4ee5\u53c2\u8003\u4e00\u4e0b\u3002<\/p>\n
 <\/p>\n
\"image.png\"<\/div>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u80cc\u666f- \u80cc\u666f \u4f60\u7528\u8fc7POI\u5417\uff1f\u5982\u679c\u4f60\u611f\u5230\u9047\u5230\u4e86\u201c\u8d28\u91cf\u5dee\u7684\u96be\u4ee5\u7406\u89e3\u7684\u5b9e\u73b0\uff08Poor Obfuscation Im […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-36952","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427 - Blog - Silicon Cloud<\/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.silicloud.com\/zh\/blog\/\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecepoi\u6bd5\u4e1a\u5427\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427\" \/>\n<meta property=\"og:description\" content=\"\u80cc\u666f- \u80cc\u666f \u4f60\u7528\u8fc7POI\u5417\uff1f\u5982\u679c\u4f60\u611f\u5230\u9047\u5230\u4e86\u201c\u8d28\u91cf\u5dee\u7684\u96be\u4ee5\u7406\u89e3\u7684\u5b9e\u73b0\uff08Poor Obfuscation Im […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecepoi\u6bd5\u4e1a\u5427\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-09T14:30:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T03:08:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d2be637434c4406c4bd08\/17-0.png\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/\",\"name\":\"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-09T14:30:56+00:00\",\"dateModified\":\"2024-04-30T03:08:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427 - Blog - Silicon Cloud","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.silicloud.com\/zh\/blog\/\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecepoi\u6bd5\u4e1a\u5427\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427","og_description":"\u80cc\u666f- \u80cc\u666f \u4f60\u7528\u8fc7POI\u5417\uff1f\u5982\u679c\u4f60\u611f\u5230\u9047\u5230\u4e86\u201c\u8d28\u91cf\u5dee\u7684\u96be\u4ee5\u7406\u89e3\u7684\u5b9e\u73b0\uff08Poor Obfuscation Im […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecepoi\u6bd5\u4e1a\u5427\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-09T14:30:56+00:00","article_modified_time":"2024-04-30T03:08:08+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d2be637434c4406c4bd08\/17-0.png"}],"author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/","name":"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-09T14:30:56+00:00","dateModified":"2024-04-30T03:08:08+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010\u7b80\u5316\u3011\u8ba9\u6211\u4eec\u4ecePOI\u6bd5\u4e1a\u5427"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e7%ae%80%e5%8c%96%e3%80%91%e8%ae%a9%e6%88%91%e4%bb%ac%e4%bb%8epoi%e6%af%95%e4%b8%9a%e5%90%a7\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/36952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=36952"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/36952\/revisions"}],"predecessor-version":[{"id":91542,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/36952\/revisions\/91542"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=36952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=36952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=36952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}