éè¦å¯¼å
¥jxl.jar
æ建ç¯å¢
å°ä¸è½½åçæ件解å
ï¼å¾å°jxl.jarï¼æ¾å
¥classpathï¼å®è£
å°±å®æäºã
å建æ件
æçæä¸ä¸ªå为âæµè¯æ°æ®.xlsâçExcelæ件ï¼å
¶ä¸ç¬¬ä¸ä¸ªå·¥ä½è¡¨è¢«å½å为â第ä¸é¡µâï¼å¤§è´ææå¦ä¸ï¼
代ç ï¼CreateXLS.javaï¼ï¼
//çæExcelçç±»
import java.io.*;
import jxl.*;
import jxl.write.*;
public class CreateXLS
{
public static void main(String args[])
{
try
{
//æå¼æ件
WritableWorkbook book=
Workbook.createWorkbook(new File(âæµè¯.xlsâ));
//çæå为â第ä¸é¡µâçå·¥ä½è¡¨ï¼åæ°0表示è¿æ¯ç¬¬ä¸é¡µ
WritableSheet sheet=book.createSheet(â第ä¸é¡µâ,0);
//å¨Label对象çæé åä¸æååå
æ ¼ä½ç½®æ¯ç¬¬ä¸å第ä¸è¡(0,0)
//以ååå
æ ¼å
容为test
Label label=new Label(0,0,âtestâ);
//å°å®ä¹å¥½çåå
æ ¼æ·»å å°å·¥ä½è¡¨ä¸
sheet.addCell(label);
/*çæä¸ä¸ªä¿åæ°åçåå
æ ¼
å¿
须使ç¨Numberçå®æ´å
è·¯å¾ï¼å¦åæè¯æ³æ§ä¹
åå
æ ¼ä½ç½®æ¯ç¬¬äºåï¼ç¬¬ä¸è¡ï¼å¼ä¸º789.123*/
jxl.write.Number number = new jxl.write.Number(1,0,789.123);
sheet.addCell(number);
//åå
¥æ°æ®å¹¶å
³éæ件
book.write();
book.close();
}catch(Exception e)
{
System.out.println(e);
}
}
}
ç¼è¯æ§è¡åï¼ä¼å¨å½åä½ç½®äº§çä¸ä¸ªExcelæ件ã
温馨提示:答案为网友推荐,仅供参考