读取txt数据，向excel中写入数据_writableworkbook inputstream-CSDN博客

本文链接：https://blog.csdn.net/pzh989898/article/details/49893615

该博客介绍了如何利用WritableWorkBook接口来创建Excel文件，并详细阐述了将txt数据导入到Excel的过程，提供了具体的代码实现。

摘要由CSDN通过智能技术生成

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