excel导入导出，完美支持2003---2007文件，代码和jar都在

曾经终败给现在 2022-09-22 12:59 106阅读 0赞

package exceltest;  
  
  
import java.io.File;  
import java.io.FileInputStream;  
import java.io.FileNotFoundException;  
import java.io.FileOutputStream;  
import java.io.IOException;  
import java.io.InputStream;  
import java.io.OutputStream;  
import java.text.SimpleDateFormat;  
import java.util.ArrayList;  
import java.util.List;  
  
  
import jxl.Cell;  
import jxl.CellType;  
import jxl.DateCell;  
import jxl.LabelCell;  
import jxl.Sheet;  
import jxl.Workbook;  
import jxl.format.UnderlineStyle;  
import jxl.read.biff.BiffException;  
import jxl.write.Boolean;  
import jxl.write.Label;  
import jxl.write.Number;  
import jxl.write.NumberFormat;  
import jxl.write.WritableCell;  
import jxl.write.WritableCellFormat;  
import jxl.write.WritableFont;  
import jxl.write.WritableImage;  
import jxl.write.WritableSheet;  
import jxl.write.WritableWorkbook;  
import jxl.write.WriteException;  
import jxl.write.biff.RowsExceededException;  
  
  
public class Excel \{  
  
  
public static List list = new ArrayList();  
  
  
public static void main(String\[\] args) \{  
// 读取Excel  
// realExcel("D:/testRead.xls");  
  
// 输出Excel  
File fileWrite = new File("D:/testWrite.xls");  
try \{  
fileWrite.createNewFile();  
OutputStream output = new FileOutputStream(fileWrite);  
writeExcel(output);  
  
\} catch (IOException e) \{  
e.printStackTrace();  
\}  
//修改Excel  
updateExcel(new File("D:/testRead.xls"),new File("D:/testWrite.xls"));  
  
\}  
  
/\*  
\* 修改Excel  
\* @file :  
\*/  
private static void updateExcel(File file, File file2) \{  
  
try \{  
Workbook workbook = Workbook.getWorkbook(file);  
WritableWorkbook writBook = Workbook.createWorkbook(file2,workbook);  
WritableSheet sheet = writBook.getSheet(0);  
WritableCell cell = sheet.getWritableCell(0,0);  
  
//判断单元格的类型，做出相应的转换  
if(cell.getType() == CellType.LABEL)\{  
Label label = (Label)cell;  
label.setString("my name is xiaohui");  
\}  
  
writBook.write();  
writBook.close();  
workbook.close();  
  
\} catch (BiffException | IOException e) \{  
e.printStackTrace();  
\} catch (WriteException e) \{  
e.printStackTrace();  
\}  
\}  
  
  
/\*  
\* 写入Exel方法。  
\*/  
@SuppressWarnings("static-access")  
public static void writeExcel(OutputStream output) \{  
  
  
WritableWorkbook workbook = null;  
try \{  
workbook = Workbook.createWorkbook(output);  
WritableSheet sheet = workbook.createSheet("Test Sheet 1", 0);  
  
  
// 1.添加Label对象：  
Label label = new Label(0, 0, "this is a label test");  
  
  
sheet.addCell(label);  
  
  
// 添加字型为Formatting的对象：  
WritableFont writFont = new WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true);  
WritableCellFormat writCellFormat = new WritableCellFormat(writFont);  
Label labelCell = new Label(1, 0, "my name is Keylin", writCellFormat);  
  
  
sheet.addCell(labelCell);  
  
  
// 添加带有字体颜色的Formattiong对象。  
WritableFont writFontCell = new WritableFont(writFont.ARIAL, 10, writFont.NO\_BOLD, false,  
UnderlineStyle.NO\_UNDERLINE, jxl.format.Colour.BLUE);  
WritableCellFormat writCellFormatColor = new WritableCellFormat(writFontCell);  
Label labelColor = new Label(1,0,"my name is Keylin",writCellFormatColor);  
sheet.addCell(labelColor);  
  
//2.添加Number 对象。  
  
Number labeNu = new Number(0,1,3.1415926);  
sheet.addCell(labeNu);  
  
//添加带有formattiong的Number对象  
NumberFormat numberFormat = new NumberFormat("\#.\#\#");  
WritableCellFormat writCellFormatNu = new WritableCellFormat(numberFormat);  
Number labeNumber = new Number(1,1,3.1415926,writCellFormatNu);  
sheet.addCell(labeNumber);  
  
//添加boolean对象  
  
Boolean LabelBoo = new Boolean(0,2,false);  
sheet.addCell(LabelBoo);  
  
//添加图片对象，jxl只支持png格式图片  
File image = new File("F:/tools/apkTool\_new/apkTool/HWSupportMobile\_android/source/bin/res/drawable-ldpi/icon.png");  
WritableImage writImage = new WritableImage(0,1,2,2,image);  
sheet.addImage(writImage);  
  
workbook.write();  
workbook.close();  
  
\} catch (IOException e) \{  
e.printStackTrace();  
\} catch (RowsExceededException e) \{  
e.printStackTrace();  
\} catch (WriteException e) \{  
e.printStackTrace();  
\}  
\}  
  
  
/\*  
\* 读取Excel的方法  
\*   
\*/  
public static void realExcel(String filePath) \{  
  
  
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");  
Workbook workbook = null;  
try \{  
InputStream file = new FileInputStream(filePath);  
  
  
// 构造Workbook（工作薄）对象  
workbook = Workbook.getWorkbook(file);  
  
  
// 创建一个sheet(工作页)的对象  
Sheet sheet = workbook.getSheet("Sheet1");  
  
  
// 得到工作页的列跟行数。  
int lows = sheet.getColumns();  
int rows = sheet.getRows();  
  
  
for (int i = 0; i < lows; i++) \{  
for (int j = 0; j < rows; j++) \{  
// 获取该行列的Cell（单元格）  
Cell cell = sheet.getCell(i, j);  
// 获取Cell对象，返回字符串。  
String strc = cell.getContents();  
// 获取具体类型值得方式；  
if (cell.getType() == CellType.LABEL) \{  
LabelCell labelc = (LabelCell) cell;  
strc = labelc.getString();  
\}  
// 类型为时间的处理。  
if (cell.getType() == CellType.DATE) \{  
DateCell dateCell = (DateCell) cell;  
strc = format.format(dateCell.getDate());  
\}  
  
  
System.out.println("第" + i + "列：" + "\\t" + strc);  
list.add(strc);  
\}  
System.out.println();  
\}  
workbook.close();  
\} catch (FileNotFoundException e) \{  
e.printStackTrace();  
\} catch (BiffException e) \{  
e.printStackTrace();  
\} catch (IOException e) \{  
e.printStackTrace();  
\}  
\}  
  
  
\}