The Excel export function implemented by jxl

Labels: Java-Excel Export

<% @ Page Language = "Java" Import = "Java. util. *" pageencoding = "GBK" %>

<% @ Page import = "jxl. Workbook" %>

<% @ Page import = "jxl. format. Alignment" %>

<% @ Page import = "jxl. format. Border" %>

<% @ Page import = "jxl. format. borderlinestyle" %>

<% @ Page import = "jxl. format. colour" %>

<% @ Page import = "jxl. format. underlinestyle" %>

<% @ Page import = "jxl. Write. Label" %>

<% @ Page import = "jxl. Write. writablecellformat" %>

<% @ Page import = "jxl. Write. writablefont" %>

<% @ Page import = "jxl. Write. writablesheet" %>

<% @ Page import = "jxl. Write. writableworkbook" %>

<% @ Page import = "jxl. Write. writeexception" %>

<%

Response. Reset ();

Response. addheader ("content-disposition", "attachment; filename =" + new string ("1.xls". getbytes (" gb2312 ")," ISO8859-1 "));

Writableworkbook WWB = Workbook. createworkbook (response. getoutputstream ());

Writablesheet Ws = WWB. createsheet ("Report", 0 );

Int [] colswidth = new int [2];

Writablefont WFC = new writablefont (writablefont. Arial, 10, writablefont. Bold, false, underlinestyle. no_underline, colour. Blue );

Writablecellformat wcffc = new writablecellformat (WFC );

Wcffc. setalignment (alignment. centre );

Wcffc. setborder (border. All, borderlinestyle. Thin );

Label healabel = new label (0, 0, "ID", wcffc );

WS. addcell (healabel );

Healabel = new label (1, 0, "name", wcffc );

WS. addcell (healabel );

Healabel = new label (0, 1, "1", wcffc );

WS. addcell (healabel );

Healabel = new label (1, 1, "1", wcffc );

WS. addcell (healabel );

WWB. Write ();

WWB. Close ();

Out. Clear ();

Out = pagecontext. pushbody ();

%>

After simple implementation, if you forget it, you can try again.