WritableWorkBook实现创建excel,并向excel写入数据。代码如下:
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.UUID;
import org.junit.Test;
import jxl.CellFormat;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.WritableCell;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
public class TestCreateExcel {
private final String basePath = "F://错误/";
private final String txtpath = "F:/错误20151117.txt";
// private TestCreateExcel test;
//
// public TestCreateExcel(){
// test = new TestCreateExcel();
// }
public static void main(String[] args) {
TestCreateExcel test = new TestCreateExcel();
File txtFile = new File(test.writeTxt());//读取的文件
File excelFile = new File(test.getPath());//写进的文件
WritableWorkbook workbook =null;
try {
//创建新的工作簿
workbook = Workbook.createWorkbook(excelFile);
//创建一张工作表
WritableSheet sheet = workbook.createSheet("one", 0);
//创建单元格
WritableCell cell = null;
//创建Label对象
Label label = null;
//设置单元格的格式
WritableFont font1