美文网首页
Android操作Excel表格

Android操作Excel表格

作者: GoodRen | 来源:发表于2017-09-26 16:52 被阅读62次

需要用到两个jar包,jxl.jar和poi-ooxml-3.9.jar

只读取Excel表格信息

Workbook workbook = Workbook.getWorkbook(file);//只读取表格不需要获取WritableWorkbook
WritableSheet sheet = workbook.getSheet(0);//获取第一张表
int rowsCount = sheet.getRows();//获取表中的行数
int cloumsCount = sheet.getColumns();//获取表中的列数
Cell cell = sheet.getCell(2, 3);//获取第二行第三列的cell对象
String contents = cell.getContents();//获取cell对象中的内容

创建Excel表格并插入数据信息

File file = new File(sdcardPath + File.separator + "Excel"+ File.separator + date+".xls");//获取excel文件对象
WorkbookSettings settings = new WorkbookSettings (); 
settings.setWriteAccess(null);
settings.setEncoding("UTF-8");
WritableWorkbook workbook = Workbook.createWorkbook(file,settings);//创建excel文件
WritableSheet sheet=workbook.createSheet("提取确认表", 0);//创建第一张表,表名是"提取确认表"
Label label1 = new Label(0, 0, "序号");//0行0列
Label label2 = new Label(1, 0,"行李编号1" );//0行1列
Label label3 = new Label(2, 0,"行李编号2" );//0行2列
Label label4 = new Label(3, 0,"比对结果" );//0行3列
sheet.addCell(label1);
sheet.addCell(label2);
sheet.addCell(label3);
sheet.addCell(label4);
//从内存中写入文件
workbook.write();
workbook.close();

读取已存在的Excel表格并插入数据信息

Workbook workbook = Workbook.getWorkbook(file);
WritableWorkbook writableWorkbook = Workbook.createWorkbook(file, workbook);//获取可写的writableWorkbook对象
WritableSheet sheet = writableWorkbook.getSheet(0);//获取表,然后就可以获取行数,然后在原表后面插入数据了

相关文章

网友评论

      本文标题:Android操作Excel表格

      本文链接:https://www.haomeiwen.com/subject/jknsextx.html