将dbf格式的文件导入到excel中

最新推荐文章于 2020-12-21 19:44:30 发布

boyssheng

最新推荐文章于 2020-12-21 19:44:30 发布

阅读量2k

点赞数

分类专栏： excel 文章标签： Excel J# F# 工作

本文链接：https://blog.csdn.net/boyssheng/article/details/83730143

版权

excel 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

public class DBFtoExcel {

	/**
	 * 从dbf文件中读取数据，并将数据保存到headName,data中。
	 * @param filePath  dbf文件的位置
	 * @param headName 字段名称集合
	 * @param data 数据集合
	 */
	public void readDBFFile(String filePath,List headName,List data) {
		InputStream inputStream = null;
		try {
			inputStream = new FileInputStream(filePath);
			DBFReader reader = new DBFReader(inputStream);
			int numberOfFields = reader.getFieldCount();
			DBFField filed = null;
			for (int i = 0; i < numberOfFields; i++) {
				filed = reader.getField(i);//读字段值
				headName.add(new String(filed.getName()));
			}
			Object[] rowObjects = null;
			while ((rowObjects = reader.nextRecord()) != null) { //读数据
				data.add(rowObjects);
			}

		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			if (inputStream != null) {
				try { 
					inputStream.close(); 
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
	}

	/**
	 * 将从dbf文件读取的数据保存成excel
	 * @param saveFilePath 文件保存的路径
	 * @param sheetNamePosts excel表中sheet名字和顺序位置
	 * @param headName 字段名称集合
	 * @param data 数据集合
	 */
	public void writeExcel(String saveFilePath,String[] sheetNamePosts,List headName,List data){
		WritableWorkbook book = null;
		try {
			book = Workbook.createWorkbook(new File(saveFilePath));
			Label label = null;
			WritableSheet sheet = null;//工作表
			Object[] rowObjects = null;
			String[] sheetNamePost = null;//工作表的名字和位置
			for (int i = 0; i < sheetNamePosts.length; i++) {
				sheetNamePost = sheetNamePosts[i].split(":");
				sheet = book.createSheet(sheetNamePost[0], Integer.parseInt(sheetNamePost[1]));//创建一个工作表
				for (int j = 0; j < headName.size(); j++) {
					//Label(列号,行号 ,内容)
					label = new Label(j,0,new String(headName.get(j).toString().getBytes("ISO-8859-1"),"GBK"));
					sheet.addCell(label);
				}
				for (int j = 0; j < data.size(); j++) {
					rowObjects = (Object[]) data.get(j);
					for (int k = 0; k < rowObjects.length; k ++) {
						//Label(列号,行号 ,内容)
						label = new Label(k,j+1,rowObjects[k] == null ? "" : new String(rowObjects[k].toString().getBytes("ISO-8859-1"),"GBK"));
						sheet.addCell(label);
					}
				}
			}
			book.write();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		} finally {
			if (book != null) {
				try {
					book.close();
				} catch (WriteException e) {
					e.printStackTrace();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
	}

	public static void main(String[] args) {
		DBFtoExcel toExcel = new DBFtoExcel();
		String filePath = "F:\\dbffile\\13-s.dbf";
		List headName = new ArrayList();
		List data = new ArrayList();
		String saveFilePath = "f:\\dbffile\\测试dbfData.xls";
		String[] sheetNamePosts = {"第一页:0"};
		toExcel.readDBFFile(filePath, headName, data);
		toExcel.writeExcel(saveFilePath, sheetNamePosts, headName, data);
	}

}