{"id":51,"date":"2015-06-17T16:27:59","date_gmt":"2015-06-17T08:27:59","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=51"},"modified":"2015-06-17T16:27:59","modified_gmt":"2015-06-17T08:27:59","slug":"java-excel-%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=51","title":{"rendered":"java Excel \u64cd\u4f5c"},"content":{"rendered":"<pre class=\"theme:eclipse lang:java decode:true \">try {\n\/\/ 1.1 \u521b\u5efa\u53ef\u5199\u5165\u7684 Excel\u5de5\u4f5c\u8584\nWritableWorkbook writableWorkbook = Workbook\n.createWorkbook(new File(\"test.xls\"));\n\/\/ 1.2 \u521b\u5efaExcel\u5de5\u4f5c\u8868\nWritableSheet writableSheet = writableWorkbook.createSheet(\n\"sheet1\", 0);\n\n\/\/ 2.1 \u6dfb\u52a0Label\u5bf9\u8c61\nLabel label00 = new Label(0, 0, \"\u6d4b\u8bd5\u521b\u5efa\u666e\u901a\u5355\u5143\u683clabel00\");\nwritableSheet.addCell(label00);\n\n\/\/ 2.2 \u6dfb\u52a0\u5e26\u6709\u5b57\u4f53\u548c\u8fb9\u6846\u7684Formatting\u7684\u5bf9\u8c61\n\/\/ 2.2.1 \u8bbe\u7f6e\u5b57\u4f53\u7684\u5927\u5c0f\u3001\u989c\u8272\u7b49\u6837\u5f0f\nWritableFont writableFont = new WritableFont(WritableFont.TIMES,\n10, WritableFont.BOLD, true);\nWritableCellFormat writableCellFormat = new WritableCellFormat(\nwritableFont);\n\/\/ 2.2.2 \u8bbe\u7f6e\u5355\u5143\u683c\u7684\u80cc\u666f\u989c\u8272\nwritableCellFormat.setBackground(jxl.format.Colour.GRAY_50);\n\/\/ 2.2.3 \u8bbe\u7f6e\u5355\u5143\u683c\u7684\u8fb9\u6846\nwritableCellFormat.setBorder(jxl.format.Border.ALL,\njxl.format.BorderLineStyle.THICK, jxl.format.Colour.RED);\n\/\/ 2.2.3 \u8bbe\u7f6e\u5355\u5143\u683c\u4e2d\u5143\u7d20\u7684\u5bf9\u9f50\u65b9\u5f0f\nwritableCellFormat.setAlignment(Alignment.RIGHT);\n\/\/ 2.2.4 \u6dfb\u52a0Label\u5bf9\u8c61\nLabel label01 = new Label(0, 1, \"TIMES\", writableCellFormat);\nwritableSheet.addCell(label01);\n\/\/ 2.3.1 \u6dfb\u52a0Number\u5bf9\u8c61\njxl.write.Number label02 = new jxl.write.Number(0, 2, 3.1415926);\nwritableSheet.addCell(label02);\n\/\/ 2.3.2 \u6dfb\u52a0\u5e26\u6709formatting\u7684 Number\u5bf9\u8c61\nNumberFormat numberFormat = new NumberFormat(\"#.##\");\nWritableCellFormat writableCellFormat4NumBer = new WritableCellFormat(\nnumberFormat);\njxl.write.Number label12 = new jxl.write.Number(1, 2, 3.1415926,\nwritableCellFormat4NumBer);\nwritableSheet.addCell(label12);\n\/\/ 2.4 \u6dfb\u52a0Boolean\u5bf9\u8c61\njxl.write.Boolean label03 = new jxl.write.Boolean(0, 3, false);\njxl.write.Boolean label13 = new jxl.write.Boolean(1, 3, true);\nwritableSheet.addCell(label03);\nwritableSheet.addCell(label13);\n\/\/ 2.5.1 \u6dfb\u52a0DateTime\u5bf9\u8c61\nDateTime label04 = new DateTime(0, 4, new java.util.Date());\nwritableSheet.addCell(label04);\n\/\/ 2.5.2 \u6dfb\u52a0\u5e26\u6709formatting\u7684DateFormat\u5bf9\u8c61\nDateFormat dateFormat = new DateFormat(\"dd MM yyyy hh:mm:ss\");\nWritableCellFormat writableCellFormat4DateTime = new WritableCellFormat(\ndateFormat);\nDateTime label05 = new DateTime(1, 4, new java.util.Date(),\nwritableCellFormat4DateTime);\nwritableSheet.addCell(label05);\n\/\/ 2.6 \u6dfb\u52a0WritableHyperlink\u5bf9\u8c61\nWritableHyperlink writableHyperlink = new WritableHyperlink(0, 5,\nnew URL(\"http:\/\/my.oschina.net\/wbw\/blog\"));\nwritableSheet.addHyperlink(writableHyperlink);\n\/\/ 2.7 \u6dfb\u52a0Formual\u5bf9\u8c61\nFormula formula = new Formula(0, 6, \"CONCATENATE(A1,A2,A3)\");\nwritableSheet.addCell(formula);\n\n\/\/ 3.1 \u5199\u5165Exel\u5de5\u4f5c\u8868\nwritableWorkbook.write();\n\n\/\/ 4.1 \u5173\u95edExcel\u5de5\u4f5c\u8584\u5bf9\u8c61\nwritableWorkbook.close();\n} catch (IOException e) {\ne.printStackTrace();\n} catch (RowsExceededException e) {\ne.printStackTrace();\n} catch (WriteException e) {\ne.printStackTrace();\n}<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>try { \/\/ 1.1 \u521b\u5efa\u53ef\u5199\u5165\u7684 Excel\u5de5\u4f5c\u8584 WritableWor&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=51\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-java"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=51"}],"version-history":[{"count":0,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}