Jxl鎿嶄綔Excel璁劇疆鑳屾櫙銆佸瓧浣撻鑹層€佸榻愭柟寮忋€佸垪鐨勫搴︼紙浜岋級

2019-11-10 19:05:53

字體：大中小

來源：轉載

供稿：網友

package com.java.demo; import java.io.File; import java.io.IOException; import jxl.Workbook; import jxl.format.Alignment; import jxl.format.Border; import jxl.format.BorderLineStyle; import jxl.format.Colour; import jxl.format.UnderlineStyle; import jxl.format.VerticalAlignment; import jxl.write.Label; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; /** * 瀵煎嚭Excel瀹炰緥: * @author Administrator * */ public class ExcelDemo { /** * @param args * @throws IOException * @throws WriteException * @throws RowsExceededException */ public static void main(String[] args) throws IOException, RowsExceededException, WriteException { //鍒涘緩Excel宸ヤ綔綈? WritableWorkbook workbook = Workbook.createWorkbook(new File("C:/ExcelDemo.xls")); //鍒涘緩Excel鐢靛瓙钖? WritableSheet sheet = workbook.createSheet("絎竴涓猄heet", 0); //鍒嗗埆緇?,3,4鍒楄緗笉鍚岀殑瀹藉害; sheet.setColumnView(1, 40); sheet.setColumnView(1, 30); sheet.setColumnView(2, 50); sheet.setColumnView(3, 20); //緇檚heet鐢靛瓙鐗堜腑鎵€鏈夌殑鍒楄緗粯璁ょ殑鍒楃殑瀹藉害; sheet.getSettings().setDefaultColumnWidth(30); //璁劇疆瀛椾綋; WritableFont font1 = new WritableFont(WritableFont.ARIAL,14,WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,Colour.RED); WritableCellFormat cellFormat1 = new WritableCellFormat(font1); //璁劇疆鑳屾櫙棰滆壊; cellFormat1.setBackground(Colour.BLUE_GREY); //璁劇疆杈規; cellFormat1.setBorder(Border.ALL, BorderLineStyle.DASH_DOT); //璁劇疆鑷姩鎹㈣; cellFormat1.setWrap(true); //璁劇疆鏂囧瓧灞呬腑瀵歸綈鏂瑰紡; cellFormat1.setAlignment(Alignment.CENTRE); //璁劇疆鍨傜洿灞呬腑; cellFormat1.setVerticalAlignment(VerticalAlignment.CENTRE); //鍒涘緩鍗曞厓格 Label label1 = new Label(0, 0, "絎竴琛岀涓€涓崟鍏?#26684;(嫻嬭瘯鏄惁鑷姩鎹㈣!)",cellFormat1); Label label2 = new Label(1, 0, "絎竴琛岀浜屼釜鍗曞厓格",cellFormat1); Label label3 = new Label(2, 0, "絎竴琛岀涓変釜鍗曞厓格",cellFormat1); Label label4 = new Label(3, 0, "絎竴琛岀鍥涗釜鍗曞厓格",cellFormat1); //娣誨姞鍒拌涓? sheet.addCell(label1); sheet.addCell(label2); sheet.addCell(label3); sheet.addCell(label4); //緇欑浜岃璁劇疆鑳屾櫙銆佸瓧浣撻鑹層€佸榻愭柟寮忕瓑絳? WritableFont font2 = new WritableFont(WritableFont.ARIAL,14,WritableFont.NO_BOLD,false,UnderlineStyle.NO_UNDERLINE,Colour.BLUE2); WritableCellFormat cellFormat2 = new WritableCellFormat(font2); cellFormat2.setAlignment(Alignment.CENTRE); cellFormat2.setBackground(Colour.PINK); cellFormat2.setBorder(Border.ALL, BorderLineStyle.THIN); cellFormat2.setWrap(true); //鍒涘緩鍗曞厓格; Label label11= new Label(0, 1, "絎簩琛岀涓€涓崟鍏?#26684;(嫻嬭瘯鏄惁鑷姩鎹㈣!)",cellFormat2); Label label22 = new Label(1, 1, "絎簩琛岀浜屼釜鍗曞厓格",cellFormat2); Label label33 = new Label(2, 1, "絎簩琛岀涓変釜鍗曞厓格",cellFormat2); Label label44 = new Label(3, 1, "絎簩琛岀鍥涗釜鍗曞厓格",cellFormat2); sheet.addCell(label11); sheet.addCell(label22); sheet.addCell(label33); sheet.addCell(label44); //鍐欏叆Excel琛?#26684;涓? workbook.write(); //鍏抽棴嫻? workbook.close(); } }

緇撴灉濡備笅錛?/span>