//測(cè)試-將表格導(dǎo)入本地文件
        FileOutputStream fileOutputStream = null;
        try {
            fileOutputStream = new FileOutputStream("C:\\Users\\Administrator.DESKTOP-SFAEOA8\\Desktop\\consistencyCheckCommodityRuleTemplate.xlsx");
            fileOutputStream.write(byteArrayOutputStream.toByteArray());
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

public void uploadExcel() {
 
        //獲取校驗(yàn)數(shù)據(jù)
        List<DTO> consistencyCheck = getConsistencyCheck();
 
        //創(chuàng)建模板信息
        DataModel dataModel = setDataModel();
        ......（此處省略一萬(wàn)字)
 
        //創(chuàng)建ExcelData
        ExcelData excelData = setExcelData();
        ......（此處也省略一萬(wàn)字)
 
        //創(chuàng)建日志數(shù)據(jù)
        ConsistencyCheckLog consistencyCheckLog = setConsistencyCheckLog();
        ......（此處又省略一萬(wàn)字)
 
        //創(chuàng)建excel
        ByteArrayOutputStream  byteArrayOutputStream = createExcel(dataModel, excelData);
 
        //測(cè)試-將表格導(dǎo)入本地文件
        FileOutputStream fileOutputStream = null;
        try {
            fileOutputStream = new FileOutputStream("C:\\Users\\Administrator.DESKTOP-SFAEOA8\\Desktop\\consistencyCheckCommodityRuleTemplate.xlsx");
            fileOutputStream.write(byteArrayOutputStream.toByteArray());
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
 
        //上傳excel（無(wú)法上傳 先注掉好了）
        //uploadFileToDfs(consistencyCheckLog, byteArrayOutputStream);
    }

 // 把讀取的結(jié)果寫(xiě)入到ByteByteArrayOutputStream
 public static void main(String[] args) throws IOException {
  // TODO Auto-generated method stub
  String s = "C:\\a.txt";
  int len = 0;
  FileInputStream stream = new FileInputStream(s);
  ByteArrayOutputStream stream2 = new ByteArrayOutputStream();
  byte[] buffer = new byte[5];
  //先讀后寫(xiě),循環(huán)讀寫(xiě)
  while ((len = stream.read(buffer)) != -1) {
   stream2.write(buffer, 0, len);
  }
  byte[] data = stream2.toByteArray();
  System.out.println(new String(data));
 }