1、写入数据
package excelJxl;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import java.io.File;
public class JxlExcelCre {
/**
* JXL 创建Excel文件
* @author yangtingting
* @date 2019/07/29
*/
public static void main(String[] args) throws Exception{
//创建Excel文件
File file=new File("D:/test.xls");
//创建文件
file.createNewFile();
//创建工作薄
WritableWorkbook workbook = Workbook.createWorkbook(file);
//创建sheet
WritableSheet sheet=workbook.createSheet("sheet1",0);
//添加数据
String[] title={"id","name","sex"};
Label label=null;
for (int i=0;i<title.length;i++){
label=new Label(i,0,title[i]);
sheet.addCell(label);
}
//追加数据
for (int i=1;i<10;