{"id":8585,"date":"2021-12-11T09:20:34","date_gmt":"2021-12-11T01:20:34","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=8585"},"modified":"2021-12-11T09:20:34","modified_gmt":"2021-12-11T01:20:34","slug":"tiptop-t100%e5%af%bc%e5%87%baexcel%e5%8a%a0%e8%b6%85%e9%93%be%e6%8e%a5","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=8585","title":{"rendered":"TIPTOP T100\u5bfc\u51faEXCEL\u52a0\u8d85\u94fe\u63a5"},"content":{"rendered":"<p><strong>&#8212;T100 POI\u5bfc\u51faEXCEL\u6dfb\u52a0\u8d85\u94fe\u63a5<\/strong><\/p>\n<p><strong>1.\u5f15\u5165jar\u5305\u91cc\u9762\u7684\u65b9\u6cd5<\/strong><\/p>\n<p><strong>IMPORT<\/strong>\u00a0<strong>JAVA<\/strong>\u00a0org.apache.poi.hssf.usermodel.HSSFHyperlink<br \/>\n<strong>IMPORT<\/strong>\u00a0<strong>JAVA<\/strong>\u00a0org.apache.poi.ss.usermodel.CreationHelper<br \/>\n<strong>IMPORT<\/strong>\u00a0<strong>JAVA<\/strong>\u00a0org.apache.poi.ss.usermodel.Hyperlink<br \/>\n<strong>IMPORT<\/strong>\u00a0<strong>JAVA<\/strong>\u00a0org.apache.poi.hssf.usermodel.HSSFCreationHelper<\/p>\n<p><strong>2.\u5b9a\u4e49\u53d8\u91cf2\u4e2a<\/strong><\/p>\n<p><strong>DEFINE<\/strong>\u00a0link\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0HSSFHyperlink<\/p>\n<p><strong>DEFINE<\/strong>\u00a0createHelper\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0HSSFCreationHelper<\/p>\n<p><strong>3\u5b57\u6bb5\u4e0a\u9762\u8d85\u94fe\u63a5<\/strong><\/p>\n<p><strong>LET<\/strong>\u00a0cell\u00a0<strong>=<\/strong>\u00a0<strong>row.createCell(<\/strong>0<strong>)<\/strong><\/p>\n<p><strong>LET<\/strong>\u00a0createHelper\u00a0<strong>=<\/strong>\u00a0workbook<strong>.getCreationHelper()<\/strong><br \/>\n<strong>LET<\/strong>\u00a0link\u00a0<strong>=<\/strong>createHelper<strong>.createHyperlink(<\/strong>Hyperlink.LINK_URL<strong>)<\/strong><br \/>\n<strong>call<\/strong>\u00a0link<strong>.setAddress(<\/strong>&#8220;http:\/\/ www.baidu.com&#8221;<strong>)<\/strong><br \/>\n<strong>CALL<\/strong>\u00a0cell<strong>.setHyperlink(<\/strong>link<strong>)<\/strong><br \/>\n<strong>CALL<\/strong>\u00a0cell<strong>.setCellValue(<\/strong>&#8220;\u7a0e\u524d\u91d1\u989d&#8221;<strong>)<\/strong><br \/>\n<strong>CALL<\/strong>\u00a0cell<strong>.setCellStyle(<\/strong>style_cell<strong>) #\u53ef\u4ee5\u5728\u5355\u72ec\u505a\u4e00\u4e2astyle \u8fd9\u4e2a\u8d85\u94fe\u63a5\u6ca1\u6709\u81ea\u5e26\u989c\u8272<\/strong><\/p>\n<p><strong>&#8212;POI\u5bfc\u51faexcel\u9501\u5b9a\u8868\u5934 <\/strong><\/p>\n<p><strong>CALL<\/strong>\u00a0sheet<strong>.createFreezePane(<\/strong>6<strong>,<\/strong>2<strong>) \/\/\u4ece\u7b2c\u516d\u5217\u7b2c\u4e8c\u884c\u5f00\u59cb\u9501\u5b9a<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.hefeiyu.com\">\u8d6b\u975e\u57df<\/a> &raquo; <a href=\"https:\/\/www.hefeiyu.com\/?p=8585\">TIPTOP T100\u5bfc\u51faEXCEL\u52a0\u8d85\u94fe\u63a5<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>&#8212;T100 POI\u5bfc\u51faEXCEL\u6dfb\u52a0\u8d85\u94fe\u63a5 1.\u5f15\u5165jar\u5305\u91cc\u9762\u7684\u65b9\u6cd5 IMPORT\u00a0JAVA\u00a0org.apache.poi.hssf.usermodel.HSSFHyperlink IMPORT\u00a0JAVA\u00a0org.apache.poi. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[490,26],"tags":[76,77,1063],"class_list":["post-8585","post","type-post","status-publish","format-standard","hentry","category-490","category-4gl","tag-import","tag-java","tag-poi"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8585"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8585\/revisions"}],"predecessor-version":[{"id":8586,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8585\/revisions\/8586"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}