import java.io.*;
import jxl.*;
import jxl.write.*;
public class CreateExcel
{
public static void main(String args[])
try {
WritableWorkbook book = Workbook.createWorkbook(new File( "成绩报表.xls"));
WritableSheet sheet = book.createSheet("成绩报表", 0);
String [] name={"学号","姓名", "思想道德基本分","思想道德奖惩分","思想道德总分"," 专业素质基本分", "专业素质奖惩分", "专业素质总分",
"身心素质基本分", "身心素质奖惩分","身心素质基本分",
"文化素质基本分", "文化素质奖惩分" ,"文化素质总分" , "综合测评", "奖学金等级" };
for(int k=0;k<name.length;k++){
Label label1 = new Label(k, 0, name[k]);
sheet.addCell(label1);
}catch(Exception e){
System.out.println("error");
}
}
导出的excel表格每个单元的太小,jxl.jar里面有没有设置单元格的大小方法?让每个单元格的文字可以全部显示出来。
import jxl.*;
import jxl.write.*;
public class CreateExcel
{
public static void main(String args[])
try {
WritableWorkbook book = Workbook.createWorkbook(new File( "成绩报表.xls"));
WritableSheet sheet = book.createSheet("成绩报表", 0);
String [] name={"学号","姓名", "思想道德基本分","思想道德奖惩分","思想道德总分"," 专业素质基本分", "专业素质奖惩分", "专业素质总分",
"身心素质基本分", "身心素质奖惩分","身心素质基本分",
"文化素质基本分", "文化素质奖惩分" ,"文化素质总分" , "综合测评", "奖学金等级" };
for(int k=0;k<name.length;k++){
Label label1 = new Label(k, 0, name[k]);
sheet.addCell(label1);
}catch(Exception e){
System.out.println("error");
}
}
导出的excel表格每个单元的太小,jxl.jar里面有没有设置单元格的大小方法?让每个单元格的文字可以全部显示出来。
WritableSheet.setColumnView(int i,int width); //指定第i+1列的宽度为width