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 }