jxl读åexcel代ç :
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class ExcelImporter
{
/**
* @Function //å½æ°ãæ¹æ³å称
* @Description //æµè¯excellè¡¨æ ¼
* @Input //è¾å
¥åæ°ç说æ
* @Output //è¾åºåæ°ç说æ
* @Return //å½æ°è¿åå¼ç说æ
* @Others //å
¶å®è¯´æ
*/
public static void main(String[] args)
{
// TODO Auto-generated method stub
List<String> list = new ArrayList<String>();
String filePath = "C:/sinye.xls";
InputStream fs = null;
Workbook workBook = null;
try {
// å è½½excelæ件
fs = new FileInputStream(filePath);
// å¾å° workbook
workBook = Workbook.getWorkbook(fs);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
// åå¾sheetï¼å¦æä½ çworkbookéæå¤ä¸ªsheet å¯ä»¥å©ç¨ wb.getSheets()æ¹æ³æ¥å¾å°ææçã
// getSheets() æ¹æ³è¿å Sheet[] æ°ç» ç¶åå©ç¨æ°ç»æ¥æä½ãå°±æ¯å¤æ¬¡å¾ªç¯çäºã
Sheet sheet = workBook.getSheet(0);//è¿éåªåå¾ç¬¬ä¸ä¸ªsheetçå¼ï¼é»è®¤ä»0å¼å§
System.out.println(sheet.getColumns());//æ¥çsheetçå
System.out.println(sheet.getRows());//æ¥çsheetçè¡
Cell cell = null;//å°±æ¯å个åå
æ ¼
// å¼å§å¾ªç¯ï¼åå¾ cell éçå
容ï¼è¿éé½æ¯æStringæ¥åç 为äºçäºï¼å
·ä½ä½ èªå·±å¯ä»¥æå®é
ç±»åæ¥åãæè
é½æ
// Stringæ¥åãç¶åæ ¹æ®ä½ éè¦å¼ºå¶è½¬æ¢ä¸ä¸ã
for (int j = 0; j < sheet.getColumns(); j++) {
StringBuffer sb = new StringBuffer();
for (int i = 0; i < sheet.getRows(); i++) {
cell = sheet.getCell(j, i);
sb.append(cell.getContents());
sb.append(",");//å°åå
æ ¼çæ¯è¡å
容ç¨éå·éå¼
}
list.add(sb.toString());//å°æ¯è¡çå符串ç¨ä¸ä¸ªStringç±»åçéåä¿åã
}
workBook.close();//è®°å¾å
³é
//è¿ä»£éåæ¥çæ¯è¡çæ°æ®
for(String ss:list){
System.out.println(ss);
}
}
}
æ¥ä¸æ¥ï¼å°±æ¯åexceläºï¼è§ä»£ç ï¼
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
public class JxlWriteExcel {
/**
* @param datas å°è£
çObject[]çå表, ä¸è¬æ¯Stringå
容.
* @param title æ¯ä¸ªsheetéçæ é¢.
*/
public void writeExcel(OutputStream out, List list, String[] title) {
if(list == null) {
throw new IllegalArgumentException("è¦åå
¥excelçæ°æ®ä¸è½ä¸ºç©ºï¼");
}
try {
WritableWorkbook workbook = Workbook.createWorkbook(out);
WritableSheet ws = workbook.createSheet("sheet 1", 0);//å建sheet
int rowNum = 0; //è¦åçè¡ï¼jxlæä½excelæ¶ï¼ç¬¬ä¸è¡æ¯ä»0å¼å§ï¼ä»¥æ¤ç±»æ¨
if(title != null) {
putRow(ws, 0, title);//åå
¥æ é¢
rowNum = 1;
}
for(int i=0; i<list.size(); i++, rowNum++) {//åsheet
Object[] cells = (Object[]) list.get(i);
putRow(ws, rowNum, cells); //åä¸è¡å°sheet
}
workbook.write();
workbook.close(); //ä¸å®è¦å
³é, å¦å没æä¿åExcel
} catch (RowsExceededException e) {
System.out.println("jxl write RowsExceededException: "+e.getMessage());
} catch (WriteException e) {
System.out.println("jxl write WriteException: "+e.getMessage());
} catch (IOException e) {
System.out.println("jxl write file i/o exception!, cause by: "+e.getMessage());
}
}
private void putRow(WritableSheet ws, int rowNum, Object[] cells) throws RowsExceededException, WriteException {
for(int j=0; j<cells.length; j++) {//åä¸è¡
Label cell = new Label(j, rowNum, ""+cells[j]);
ws.addCell(cell);
}
}
}
è°ç¨åexcelçæµè¯ä»£ç
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
public class Test1 {
public static void main(String[] args) {
// TODO Auto-generated method stub
List list = new ArrayList();
//ç»è£
åå
¥excelçæ°æ®
for(int i=0;i<10;i++){
String[] data = {"å¼å¿"+i,"2"+i};
list.add(data);
}
try {
OutputStream out = new FileOutputStream(new File("c:\\sinye.xls"));
JxlWriteExcel jxlExcelWriter = new JxlWriteExcel();
jxlExcelWriter.writeExcel(out, list, new String[] {"å§å", "å¹´é¾"});
out.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
温馨提示:内容为网友见解,仅供参考