pio方式写入excel

---

layout: code
title: Example
date: 2020-06-17 09:50:39
tags:

写入Excel

使用 poi 进行解析的方式

HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("sheet1");
HSSFRow row = sheet.createRow(ROW++);
cell = row.createCell(index++);
cell.setCellValue("mainName");
OutputStream stream = new FileOutputStream("D:/E007/" + fileName+".xls");
workbook.write(stream);
stream.close();

访问地址返回json

public static String queryHubService(JSONObject requestJson, String trancdoe) {
		
	}

文件读取

创建文件读取流

r = new BufferedReader(new InputStreamReader(new FileInputStream(new File(path,readFileName)),"utf-8"));
String name = null;		
while ((name=r.readLine())!=null) {}

创建输出流

//true 以追加方式写入文件
FileOutputStream fos = new FileOutputStream("E:/log.txt",true);
//流输出
FileOutputStream os = new FileOutputStream(tempFile.getPath() + File.separator + fileName);
byte[] bs = new byte[1024];
int len;
while ((len = inputStream.read(bs)) != -1) {
     os.write(bs, 0, len);
}
os.close();
//字符串输出
FileWriter writer;
try {
	//追加方式写入文件true
	//writer = new FileWriter("E:/token.txt",true);
    writer = new FileWriter("E:/token.txt");
	writer.write("");//清空原文件内容
    writer.write(str);
    writer.flush();
    writer.close();
} catch (IOException e) {
    e.printStackTrace();r
}