JXL 读写excle
来源:互联网 发布:JAVA输入命令格式 编辑:程序博客网 时间:2024/05/19 17:27
1)引入jxl.jar包
2)写接口
package testExcel;
public interface ExcelService {
public void write(int colum, int row, String content) throws Exception;
public String read(int colum, int row)throws Exception;
}
3)读写excle类
package testExcel;
import testExcel.ExcelService;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExcelUtils implements ExcelService{
private String path = "D://excel.xls";
public static void main(String[] args) throws Exception {
ExcelUtils excelUtils = new ExcelUtils();
String content = "Hello World";
excelUtils.write(2, 3, content);
String newContent = excelUtils.read(2, 3);
System.out.println(newContent);
}
public void write(int colum, int row, String content) throws Exception {
FileOutputStream fileOutputStream = new FileOutputStream(path);
WritableWorkbook writableWorkbook = Workbook
.createWorkbook(fileOutputStream);
WritableSheet writableSheet = writableWorkbook.createSheet("Excel", 0);
Label label = new Label(colum, row, content);
writableSheet.addCell(label);
writableWorkbook.write();
writableWorkbook.close();
fileOutputStream.close();
}
public String read(int colum, int row) throws Exception {
FileInputStream fileInputStream = new FileInputStream(path);
Workbook workbook = Workbook.getWorkbook(fileInputStream);
Sheet sheet = workbook.getSheet(0);
Cell cell = sheet.getCell(colum, row);
String content = cell.getContents();
workbook.close();
fileInputStream.close();
return content;
}
}
- JXL 读写excle
- JXL处理excle
- jxl 导出excle整理
- jxl导入excle到oracle
- 采用jxl操作读取Excle
- Android 数据导出之Excle jxl.jar
- Android 数据导出之Excle jxl.jar
- 上传excle Jxl读取Excel 导入数据
- 用jxl导出带图片的excle
- 百万级数据读写Excle
- Python对Excle的读写
- JXL读写EXCEL文件
- 利用jxl读写Excel
- JXL读写Excel
- 使用jxl读写excel
- 使用JXL读写Excel
- jxl 读写excel
- JXL读写xls
- ReSIProcate之各工程功能简单介绍
- C++ win32控制台下输出宽字符串(包括汉字)
- java.lang.OutOfMemoryError错误
- 完成的项目
- cat
- JXL 读写excle
- xml中的特殊字符
- 去除给定字符串中重复的字符串
- dpkg
- 只能输入整数或小数
- Oracle中的硬解析与软解析
- [转]background-image属性研究
- 事件机制的工作流程
- 初次使用zend framework,如何使用多个controllers