java导出成Excel的方法(需要jxl.jar包)
来源:互联网 发布:hp5200网络打印机设置 编辑:程序博客网 时间:2024/05/24 05:03
import java.io.File;
import java.sql.ResultSet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.eclipse.swt.SWT;
import org.eclipse.swt.widgets.FileDialog;
import org.eclipse.swt.widgets.Shell;
public class Export2Excel {
public Export2Excel(Shell shell, String[] coloumNames, ResultSet rSet,
String sheetName) {
FileDialog fileDialog = new FileDialog(shell, SWT.NONE);
fileDialog.setFilterExtensions(new String[]{"*.xls"});
fileDialog.setText("文件另存为");
fileDialog.setFileName("temp.xls");
fileDialog.open();
String path = fileDialog.getFilterPath();
String fileName = fileDialog.getFileName();
try {
WritableWorkbook book = Workbook.createWorkbook((new File(path
+ "\\" + fileName)));
WritableSheet sheet = book.createSheet(sheetName, 0);
for (int i = 0; i < coloumNames.length; i++) {
sheet.setColumnView(100, 400);
Label label = new Label(i, 0, coloumNames[i]);
sheet.addCell(label);
}
int i = 0;
while (rSet.next()) {
i = i + 1;
Label label1A = new Label(0, i, rSet.getRow() + "");
sheet.addCell(label1A);
for (int j = 0; j < coloumNames.length; j++) {
System.out.println("j =" + j);
if (j == 0) {
Label label = new Label(j, i, rSet.getRow() + "");
sheet.addCell(label);
} else {
Label label = new Label(j, i, rSet.getString(j));
sheet.addCell(label);
}
}
}
book.write();
book.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
import java.sql.ResultSet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.eclipse.swt.SWT;
import org.eclipse.swt.widgets.FileDialog;
import org.eclipse.swt.widgets.Shell;
public class Export2Excel {
public Export2Excel(Shell shell, String[] coloumNames, ResultSet rSet,
String sheetName) {
FileDialog fileDialog = new FileDialog(shell, SWT.NONE);
fileDialog.setFilterExtensions(new String[]{"*.xls"});
fileDialog.setText("文件另存为");
fileDialog.setFileName("temp.xls");
fileDialog.open();
String path = fileDialog.getFilterPath();
String fileName = fileDialog.getFileName();
try {
WritableWorkbook book = Workbook.createWorkbook((new File(path
+ "\\" + fileName)));
WritableSheet sheet = book.createSheet(sheetName, 0);
for (int i = 0; i < coloumNames.length; i++) {
sheet.setColumnView(100, 400);
Label label = new Label(i, 0, coloumNames[i]);
sheet.addCell(label);
}
int i = 0;
while (rSet.next()) {
i = i + 1;
Label label1A = new Label(0, i, rSet.getRow() + "");
sheet.addCell(label1A);
for (int j = 0; j < coloumNames.length; j++) {
System.out.println("j =" + j);
if (j == 0) {
Label label = new Label(j, i, rSet.getRow() + "");
sheet.addCell(label);
} else {
Label label = new Label(j, i, rSet.getString(j));
sheet.addCell(label);
}
}
}
book.write();
book.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
- java导出成Excel的方法(需要jxl.jar包)
- java导出成Excel的方法(需要jxl.jar包)
- 关于java导出成Excel的方法(需要jxl.jar包)
- java导出生成Excel(需要jxl.jar包)
- java导入导出excel操作(jxl)jxl.jar 包
- Java解释Excel数据(jxl.jar包的使用)
- Java解释Excel数据(jxl.jar包的使用)
- Java解释Excel数据(jxl.jar包的使用)
- Java解释Excel数据(jxl.jar包的使用)
- Java解释Excel数据(jxl.jar包的使用)
- Java解释Excel数据(jxl.jar包的使用)
- 读取excel文件(jxl.jar包简介/java操作excel jxl.jar下载地址)
- jxl.jar包简介/java操作excel jxl.jar
- 导出excel jxl.jar
- jxl.jar包简介/java操作excel
- excel导入导出需要的jar包---maven
- Java 数据导出Excel 方法 POI / JXL
- jsp中操作Excel需要引入一个外部的jar包(jxl.jar),这个jar包主要是用来构建Excel的骨架的,具体实例如下:
- 遗传算法
- Linux集群之负载平衡原理和实现算法
- java 字符串解析
- DataGridView编辑列出现listview
- jQuery Validation范例
- java导出成Excel的方法(需要jxl.jar包)
- Cookie 和 Session 的区别
- Asp.net底层机制
- 邮件查询黑名单
- 一个简单的查询语句
- C#网络爬虫与搜索引擎调研
- 装CVS的时候出现cpl文件无法识别打开程序
- C#操作Win32 API
- 文德数据意与国内主机商合作 加快cPanel融入国内市场步伐