import jxl.*;
import jxl.write.*;
import java.io.*;
import java.io.File.*;
import java.util.*;public class excel2
{
public static void main(String[] args)
{String targetfile = "c:/out2.xls";//输出的excel文件名
String worksheet = "List";//输出的excel文件工作表名
WritableWorkbook workbook;
try
{
//创建可写入的Excel工作薄,运行生成的文件在tomcat/bin下
//workbook = Workbook.createWorkbook(new File("output2.xls"));
System.out.println("begin");OutputStream os=new FileOutputStream(targetfile);
workbook=Workbook.createWorkbook(os); WritableSheet sheet = workbook.createSheet(worksheet, 0); //添加第一个工作表
//设置边框
jxl.write.Label labelCFC;
jxl.write.WritableCellFormat wcsB = new jxl.write.WritableCellFormat();
wcsB.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THICK);
labelCFC = new jxl.write.Label(0,6,"边框设置",wcsB);
sheet.addCell(labelCFC);
workbook.write();
workbook.close();
}catch(Exception e)
{
e.printStackTrace();
}
System.out.println("end");
Runtime r=Runtime.getRuntime();
Process p=null;
//String cmd[]={"notepad","exec.java"};
String cmd[]={"D:\\soft\\office_2000_japan\\Office\\EXCEL.EXE","out2.xls"};
try{
p=r.exec(cmd);
}
catch(Exception e){
System.out.println("error executing: "+cmd[0]);
}
}
}
import jxl.write.*;
import java.io.*;
import java.io.File.*;
import java.util.*;public class excel2
{
public static void main(String[] args)
{String targetfile = "c:/out2.xls";//输出的excel文件名
String worksheet = "List";//输出的excel文件工作表名
WritableWorkbook workbook;
try
{
//创建可写入的Excel工作薄,运行生成的文件在tomcat/bin下
//workbook = Workbook.createWorkbook(new File("output2.xls"));
System.out.println("begin");OutputStream os=new FileOutputStream(targetfile);
workbook=Workbook.createWorkbook(os); WritableSheet sheet = workbook.createSheet(worksheet, 0); //添加第一个工作表
//设置边框
jxl.write.Label labelCFC;
jxl.write.WritableCellFormat wcsB = new jxl.write.WritableCellFormat();
wcsB.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THICK);
labelCFC = new jxl.write.Label(0,6,"边框设置",wcsB);
sheet.addCell(labelCFC);
workbook.write();
workbook.close();
}catch(Exception e)
{
e.printStackTrace();
}
System.out.println("end");
Runtime r=Runtime.getRuntime();
Process p=null;
//String cmd[]={"notepad","exec.java"};
String cmd[]={"D:\\soft\\office_2000_japan\\Office\\EXCEL.EXE","out2.xls"};
try{
p=r.exec(cmd);
}
catch(Exception e){
System.out.println("error executing: "+cmd[0]);
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货