{"id":31135,"date":"2023-08-03T16:00:40","date_gmt":"2023-12-09T04:01:54","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/"},"modified":"2025-08-12T22:30:23","modified_gmt":"2025-08-12T14:30:23","slug":"%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/","title":{"rendered":"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22"},"content":{"rendered":"
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\"\r\n\txmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n\txsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\r\n\t<modelVersion>4.0.0<\/modelVersion>\r\n\t<groupId>mygroup<\/groupId>\r\n\t<artifactId>excelgrep<\/artifactId>\r\n\t<version>0.0.1-SNAPSHOT<\/version>\r\n\t<properties>\r\n\t\t<maven.compiler.source>1.8<\/maven.compiler.source>\r\n\t\t<maven.compiler.target>1.8<\/maven.compiler.target>\r\n\t<\/properties>\r\n\t<dependencies>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.apache.poi<\/groupId>\r\n\t\t\t<artifactId>poi<\/artifactId>\r\n\t\t\t<version>5.2.3<\/version>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.apache.poi<\/groupId>\r\n\t\t\t<artifactId>poi-ooxml<\/artifactId>\r\n\t\t\t<version>5.2.3<\/version>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.apache.logging.log4j<\/groupId>\r\n\t\t\t<artifactId>log4j-core<\/artifactId>\r\n\t\t\t<version>2.20.0<\/version>\r\n\t\t<\/dependency>\r\n\t<\/dependencies>\r\n<\/project>\r\n<\/code><\/pre>\n
package<\/span> excelgrep<\/span>;<\/span>\r\n\r\nimport<\/span> java.io.File<\/span>;<\/span>\r\nimport<\/span> java.io.FileInputStream<\/span>;<\/span>\r\nimport<\/span> java.util.ArrayList<\/span>;<\/span>\r\nimport<\/span> java.util.Arrays<\/span>;<\/span>\r\nimport<\/span> java.util.List<\/span>;<\/span>\r\n\r\nimport<\/span> org.apache.poi.ss.usermodel.CellType<\/span>;<\/span>\r\nimport<\/span> org.apache.poi.xssf.usermodel.XSSFWorkbook<\/span>;<\/span>\r\n\r\npublic<\/span> class<\/span> Main<\/span> {<\/span>\r\n\tpublic<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[]<\/span> args<\/span>)<\/span> throws<\/span> Exception<\/span> {<\/span>\r\n\t\t\/\/ \u691c\u7d22\u958b\u59cb\u30d5\u30a9\u30eb\u30c0<\/span>\r\n\t\tString<\/span>[]<\/span> dirPaths<\/span> =<\/span> {<\/span> \"C:\\\\dir1\"<\/span>,<\/span> \"C:\\\\dir2\"<\/span> };<\/span>\r\n\t\t\/\/ \u691c\u7d22\u8a9e<\/span>\r\n\t\tString<\/span>[]<\/span> words<\/span> =<\/span> {<\/span> \"\u691c\u7d22\u8a9e1\"<\/span>,<\/span> \"\\\"\"<\/span> };<\/span>\r\n\t\t\/\/ \u9664\u5916\u30b5\u30d6\u30d5\u30a9\u30eb\u30c0\u540d<\/span>\r\n\t\tString<\/span>[]<\/span> excludeSubDirNames<\/span> =<\/span> {<\/span> \"\u9664\u5916\u30b5\u30d6\u30d5\u30a9\u30eb\u30c01\"<\/span>,<\/span> \"\u9664\u5916\u30b5\u30d6\u30d5\u30a9\u30eb\u30c02\"<\/span> };<\/span>\r\n\t\t\/\/ \u9664\u5916\u30b7\u30fc\u30c8\u540d<\/span>\r\n\t\tString<\/span>[]<\/span> excludeSheetNames<\/span> =<\/span> {<\/span> \"\u9664\u5916\u30b7\u30fc\u30c81\"<\/span>,<\/span> \"\u9664\u5916\u30b7\u30fc\u30c82\"<\/span> };<\/span>\r\n\r\n\t\tSystem<\/span>.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>\"\u958b\u59cb\u3057\u307e\u3059\u3002\"<\/span>);<\/span>\r\n\t\tSystem<\/span>.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>\"\u30d5\u30a1\u30a4\u30eb\\t\u30b7\u30fc\u30c8\\t\u30bb\u30eb\\t\u5185\u5bb9\"<\/span>);<\/span>\r\n\t\tList<\/span><<\/span>String<\/span>><\/span> wordsList<\/span> =<\/span> new<\/span> ArrayList<\/span><<\/span>String<\/span>>(<\/span>Arrays<\/span>.<\/span>asList<\/span>(<\/span>words<\/span>));<\/span>\r\n\t\tList<\/span><<\/span>String<\/span>><\/span> excludeSubDirNamesList<\/span> =<\/span> new<\/span> ArrayList<\/span><<\/span>String<\/span>>(<\/span>Arrays<\/span>.<\/span>asList<\/span>(<\/span>excludeSubDirNames<\/span>));<\/span>\r\n\t\tList<\/span><<\/span>String<\/span>><\/span> excludeSheetNamesList<\/span> =<\/span> new<\/span> ArrayList<\/span><<\/span>String<\/span>>(<\/span>Arrays<\/span>.<\/span>asList<\/span>(<\/span>excludeSheetNames<\/span>));<\/span>\r\n\t\tfor<\/span> (<\/span>String<\/span> dirPath<\/span> :<\/span> dirPaths<\/span>)<\/span> {<\/span>\r\n\t\t\tfunc<\/span>(<\/span>new<\/span> File<\/span>(<\/span>dirPath<\/span>),<\/span> wordsList<\/span>,<\/span> excludeSubDirNamesList<\/span>,<\/span> excludeSheetNamesList<\/span>);<\/span>\r\n\t\t}<\/span>\r\n\t\tSystem<\/span>.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>\"\u7d42\u4e86\u3057\u307e\u3059\u3002\"<\/span>);<\/span>\r\n\t}<\/span>\r\n\r\n\tprivate<\/span> static<\/span> void<\/span> func<\/span>(<\/span>File<\/span> dir<\/span>,<\/span> List<\/span><<\/span>String<\/span>><\/span> wordsList<\/span>,<\/span> List<\/span><<\/span>String<\/span>><\/span> excludeSubDirNamesList<\/span>,<\/span> List<\/span><<\/span>String<\/span>><\/span> excludeSheetNamesList<\/span>)<\/span> throws<\/span> Exception<\/span> {<\/span>\r\n\t\tFile<\/span>[]<\/span> fileOrSubDirs<\/span> =<\/span> dir<\/span>.<\/span>listFiles<\/span>();<\/span>\r\n\t\tif<\/span> (<\/span>fileOrSubDirs<\/span> !=<\/span> null<\/span>)<\/span> {<\/span>\r\n\t\t\tfor<\/span> (<\/span>File<\/span> fileOrSubDir<\/span> :<\/span> fileOrSubDirs<\/span>)<\/span> {<\/span>\r\n\t\t\t\t\/\/ \u9664\u5916\u30b5\u30d6\u30d5\u30a9\u30eb\u30c0\u3067\u306a\u3051\u308c\u3070\u518d\u5e30\u7684\u306b\u51e6\u7406<\/span>\r\n\t\t\t\tif<\/span> (<\/span>fileOrSubDir<\/span>.<\/span>isDirectory<\/span>()<\/span> &&<\/span> !<\/span>excludeSubDirNamesList<\/span>.<\/span>contains<\/span>(<\/span>fileOrSubDir<\/span>.<\/span>getName<\/span>()))<\/span> {<\/span>\r\n\t\t\t\t\tfunc<\/span>(<\/span>fileOrSubDir<\/span>,<\/span> wordsList<\/span>,<\/span> excludeSubDirNamesList<\/span>,<\/span> excludeSheetNamesList<\/span>);<\/span>\r\n\t\t\t\t}<\/span>\r\n\t\t\t\t\/\/ \u62e1\u5f35\u5b50\u304c.xlsx\u306a\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u691c\u7d22<\/span>\r\n\t\t\t\tif<\/span> (<\/span>fileOrSubDir<\/span>.<\/span>isFile<\/span>()<\/span> &&<\/span> fileOrSubDir<\/span>.<\/span>getName<\/span>().<\/span>endsWith<\/span>(<\/span>\".xlsx\"<\/span>))<\/span> {<\/span>\r\n\t\t\t\t\ttry<\/span> (<\/span>XSSFWorkbook<\/span> workbook<\/span> =<\/span> new<\/span> XSSFWorkbook<\/span>(<\/span>new<\/span> FileInputStream<\/span>(<\/span>fileOrSubDir<\/span>)))<\/span> {<\/span>\r\n\t\t\t\t\t\t\/\/ \u9664\u5916\u30b7\u30fc\u30c8\u4ee5\u5916\u306e\u30b7\u30fc\u30c8\u304b\u3089\u691c\u7d22<\/span>\r\n\t\t\t\t\t\tworkbook<\/span>.<\/span>forEach<\/span>(<\/span>sheet<\/span> -><\/span> {<\/span>\r\n\t\t\t\t\t\t\tif<\/span> (!<\/span>excludeSheetNamesList<\/span>.<\/span>contains<\/span>(<\/span>sheet<\/span>.<\/span>getSheetName<\/span>()))<\/span> {<\/span>\r\n\t\t\t\t\t\t\t\tsheet<\/span>.<\/span>forEach<\/span>(<\/span>row<\/span> -><\/span> row<\/span>.<\/span>forEach<\/span>(<\/span>cell<\/span> -><\/span> {<\/span>\r\n\t\t\t\t\t\t\t\t\tif<\/span> (<\/span>cell<\/span>.<\/span>getCellType<\/span>()<\/span> ==<\/span> CellType<\/span>.<\/span>STRING<\/span>)<\/span> {<\/span>\r\n\t\t\t\t\t\t\t\t\t\tString<\/span> cellValue<\/span> =<\/span> cell<\/span>.<\/span>getStringCellValue<\/span>();<\/span>\r\n\t\t\t\t\t\t\t\t\t\twordsList<\/span>.<\/span>forEach<\/span>(<\/span>word<\/span> -><\/span> {<\/span>\r\n\t\t\t\t\t\t\t\t\t\t\tif<\/span> (<\/span>cellValue<\/span>.<\/span>contains<\/span>(<\/span>word<\/span>))<\/span> {<\/span>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\/\/ \u691c\u7d22\u7d50\u679c\u306fExcel\u306b\u8cbc\u308a\u4ed8\u3051\u3084\u3059\u3044\u66f8\u5f0f\u3067\u51fa\u529b<\/span>\r\n\t\t\t\t\t\t\t\t\t\t\t\tSystem<\/span>.<\/span>out<\/span>.<\/span>printf<\/span>(<\/span>\"%s\\t%s\\t%s\\t\\\"%s\\\"%n\"<\/span>,<\/span> fileOrSubDir<\/span>.<\/span>getAbsoluteFile<\/span>(),<\/span> sheet<\/span>.<\/span>getSheetName<\/span>(),<\/span> cell<\/span>.<\/span>getAddress<\/span>().<\/span>toString<\/span>(),<\/span>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcellValue<\/span>.<\/span>replaceAll<\/span>(<\/span>\"\\\"\"<\/span>,<\/span> \"\\\"\\\"\"<\/span>));<\/span>\r\n\t\t\t\t\t\t\t\t\t\t\t}<\/span>\r\n\t\t\t\t\t\t\t\t\t\t});<\/span>\r\n\t\t\t\t\t\t\t\t\t}<\/span>\r\n\t\t\t\t\t\t\t\t\t\/\/ TODO STRING\u4ee5\u5916\u3084\u6570\u5f0f\u3084\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5185\u304b\u3089\u3082\u691c\u7d22<\/span>\r\n\t\t\t\t\t\t\t\t}));<\/span>\r\n\t\t\t\t\t\t\t}<\/span>\r\n\t\t\t\t\t\t});<\/span>\r\n\t\t\t\t\t}<\/span> catch<\/span> (<\/span>Exception<\/span> e<\/span>)<\/span> {<\/span>\r\n\t\t\t\t\t\tSystem<\/span>.<\/span>err<\/span>.<\/span>println<\/span>(<\/span>e<\/span>.<\/span>toString<\/span>());<\/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}<\/span>\r\n\t}<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u8fd9\u4e2a\u94fe\u63a5\u662f\u4ed6\u53c2\u8003\u521b\u5efaApache POI\u7684Excel Grep\u5de5\u5177\u65f6\u4f7f\u7528\u7684\u3002\u975e\u5e38\u611f\u8c22\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
<project xmlns=”http:\/\/maven.apache.org\/POM\/4.0.0″ x […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-31135","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"\n\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\u7684\u6280\u672f\u6587\u7ae0\" \/>\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\/\u7528java\u4eceexcel\u4e2d\u8fdb\u884c\u641c\u7d22\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u7528java\u4eceexcel\u4e2d\u8fdb\u884c\u641c\u7d22\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-09T04:01:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T14:30:23+00:00\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \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\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/\",\"name\":\"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-12-09T04:01:54+00:00\",\"dateModified\":\"2025-08-12T14:30:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"description\":\"\u5173\u4e8e\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\"}]},{\"@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\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22 - Blog - Silicon Cloud","description":"\u5173\u4e8e\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\u7684\u6280\u672f\u6587\u7ae0","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\/\u7528java\u4eceexcel\u4e2d\u8fdb\u884c\u641c\u7d22\/","og_locale":"zh_CN","og_type":"article","og_title":"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22","og_description":"\u5173\u4e8e\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u7528java\u4eceexcel\u4e2d\u8fdb\u884c\u641c\u7d22\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-12-09T04:01:54+00:00","article_modified_time":"2025-08-12T14:30:23+00:00","author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/","name":"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-12-09T04:01:54+00:00","dateModified":"2025-08-12T14:30:23+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"description":"\u5173\u4e8e\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u7528Java\u4eceExcel\u4e2d\u8fdb\u884c\u641c\u7d22"}]},{"@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\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8java%e4%bb%8eexcel%e4%b8%ad%e8%bf%9b%e8%a1%8c%e6%90%9c%e7%b4%a2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/31135","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=31135"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/31135\/revisions"}],"predecessor-version":[{"id":93095,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/31135\/revisions\/93095"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=31135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=31135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=31135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}