JXL API总结

API参考：

http://www.andykhan.com/jexcelapi/index.html

官网：

http://jexcelapi.sourceforge.net/

 

1. 创建可写的工作簿workbook

WritableWorkbook workbook = Workbook.createWorkbook(new File("c:\test.xls"));

 

 

2. 读取现有的工作簿workbook（不可写）

Workbook workbook = Workbook.getWorkbook(new File("c:\template.xls"));

 

3. 创建可写的Sheet

workbook.createSheet("name", 0);

 

4. 读取现有的Sheet

workbook.getSheet(0);

 

 

5. 创建Label

Label label = new Label(0,0,"content");

 

6. 将Label 添加到Sheet

sheet.addCell(label);

 

7. 根据模板创建workbook

Workbook template = Workbook.getWorkbook(new File("c:\template.xls"));
WritableWorkbook workbook = Workbook.createWorkbook(new File("c:\test.xls"),template);

 

8. 创建Excel的例子

WritableWorkbook workbook = Workbook.createWorkbook(new File("c:\test.xls"));
WritableSheet sheet = workbook.getSheet(0);
Label label1 = new Label(0,0,"content");
Label label2 = new Label(0,1,"content");
sheet.addCell(label1);
sheet.addCell(label2);
workbook.write();
workbook.close();

 

 

9. 根据模板创建Excel的例子

Workbook template = Workbook.getWorkbook(new File("c:\template.xls"));
WritableWorkbook workbook = Workbook.createWorkbook(new File("c:\test.xls"),template);
WritableSheet sheet = workbook.getSheet(0);
Label label1 = new Label(0,0,"content");
Label label2 = new Label(0,1,"content");
sheet.addCell(label1);
sheet.addCell(label2);
workbook.write();
workbook.close();

 

10. 使用模板单元格的格式

Workbook template = Workbook.getWorkbook(new File("c:\template.xls"));
WritableWorkbook workbook = Workbook.createWorkbook(new File("c:\test.xls"),template);
WritableSheet sheet = workbook.getSheet(0);	
//获取模板单元格的格式（字体，颜色等）	
CellFormat cellFormat = sheet.getWritableCell(0, 0).getCellFormat();
Label label = new Label(0,0,"content",cellFormat);
sheet.addCell(label);
workbook.write();
workbook.close();

 

 

11. 处理换行

WritableCellFormat wcf = new WritableCellFormat();
wcf.setWrap(true);
wcf.setVerticalAlignment(VerticalAlignment.CENTRE);
Label label= new Label(0, 0,wcf);

 

 

12. struts2 下载excel

 

public InputStream getInputStream(){
		try {
			ByteArrayOutputStream os = new ByteArrayOutputStream();
                        Workbook template = Workbook.getWorkbook(new File("c:\template.xls"));
			WritableWorkbook workbook = Workbook.createWorkbook(os,template);
		        WritableSheet sheet = workbook.getSheet(0);		
		        CellFormat cellFormat = sheet.getWritableCell(0, 0).getCellFormat();
		        Label label = new Label(0,0,"content",cellFormat);
		        sheet.addCell(label);
		        workbook.write();
		        workbook.close();
		        return new ByteArrayInputStream(os.toByteArray());
		} catch (Exception e) {
			logger.error(e.getMessage(), e);
			return null;
		}
	}