import java.io.*;
import jxl.*;
import jxl.write.*;public class CreateXLS {
public static void main(String args[]) {
try {
//打开文件
WritableWorkbook book = Workbook.createWorkbook(new File(
"commodity.xls"));
//生成名为"商品信息"的工作表,参数0表示这是第一页
WritableSheet sheet = book.createSheet("商品信息", 0); sheet.addCell(new jxl.write.Label(0, 5, "商品ID"));
sheet.addCell(new jxl.write.Label(1, 5, "供货商ID"));
sheet.addCell(new jxl.write.Label(2, 5, "品牌"));
sheet.addCell(new jxl.write.Label(3, 5, "机型"));
sheet.addCell(new jxl.write.Label(4, 5, "终端类型"));
sheet.addCell(new jxl.write.Label(5, 5, "配置"));
sheet.addCell(new jxl.write.Label(0, 6, "888"));
sheet.addCell(new jxl.write.Label(1, 6, "666"));
sheet.addCell(new jxl.write.Label(2, 6, "三星"));
sheet.addCell(new jxl.write.Label(3, 6, "A108"));
sheet.addCell(new jxl.write.Label(4, 6, "CDMA"));
sheet.addCell(new jxl.write.Label(5, 6, "双电双充"));
sheet.addCell(new jxl.write.Label(0, 7, "999"));
sheet.addCell(new jxl.write.Label(1, 7, "666"));
sheet.addCell(new jxl.write.Label(2, 7, "摩托罗拉"));
sheet.addCell(new jxl.write.Label(3, 7, "V888"));
sheet.addCell(new jxl.write.Label(4, 7, "GSM"));
sheet.addCell(new jxl.write.Label(5, 7, "双电双充"));
//写入数据并关闭文件
book.write();
book.close(); } catch (Exception e) {
System.out.println(e);
}
}
}要关闭输入文件
import jxl.*;
import jxl.write.*;public class CreateXLS {
public static void main(String args[]) {
try {
//打开文件
WritableWorkbook book = Workbook.createWorkbook(new File(
"commodity.xls"));
//生成名为"商品信息"的工作表,参数0表示这是第一页
WritableSheet sheet = book.createSheet("商品信息", 0); sheet.addCell(new jxl.write.Label(0, 5, "商品ID"));
sheet.addCell(new jxl.write.Label(1, 5, "供货商ID"));
sheet.addCell(new jxl.write.Label(2, 5, "品牌"));
sheet.addCell(new jxl.write.Label(3, 5, "机型"));
sheet.addCell(new jxl.write.Label(4, 5, "终端类型"));
sheet.addCell(new jxl.write.Label(5, 5, "配置"));
sheet.addCell(new jxl.write.Label(0, 6, "888"));
sheet.addCell(new jxl.write.Label(1, 6, "666"));
sheet.addCell(new jxl.write.Label(2, 6, "三星"));
sheet.addCell(new jxl.write.Label(3, 6, "A108"));
sheet.addCell(new jxl.write.Label(4, 6, "CDMA"));
sheet.addCell(new jxl.write.Label(5, 6, "双电双充"));
sheet.addCell(new jxl.write.Label(0, 7, "999"));
sheet.addCell(new jxl.write.Label(1, 7, "666"));
sheet.addCell(new jxl.write.Label(2, 7, "摩托罗拉"));
sheet.addCell(new jxl.write.Label(3, 7, "V888"));
sheet.addCell(new jxl.write.Label(4, 7, "GSM"));
sheet.addCell(new jxl.write.Label(5, 7, "双电双充"));
//写入数据并关闭文件
book.write();
book.close(); } catch (Exception e) {
System.out.println(e);
}
}
}要关闭输入文件
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货