如何操作xlsx结尾文件，使其写入文本

最新推荐文章于 2022-07-15 14:49:17 发布

H352296390

最新推荐文章于 2022-07-15 14:49:17 发布

阅读量1.2k

点赞数 5

本文链接：https://blog.youkuaiyun.com/H352296390/article/details/8804376

版权

package excel;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;

import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class txt {

public static void main(String[] args)
{
  try {

   XSSFWorkbook xwb = new XSSFWorkbook("E:/1.xlsx");
   // 读取第一章表格内容
   XSSFSheet sheet = xwb.getSheetAt(0);
   // 定义 row、cell
   XSSFRow row;
   String cellKey;
   String cellValue;
   int keyIndex1 = 2;
   int valueIndex1 = 0;
   StringBuffer txt = new StringBuffer();
    File f = new File("e:/map.txt");
   BufferedReader input = new BufferedReader(new FileReader(f));
   FileOutputStream outFile = new FileOutputStream("map.txt");
   BufferedWriter output = new BufferedWriter(new FileWriter(f));
   // 循环输出表格中的内容
   for (int i = 1; i < sheet
     .getPhysicalNumberOfRows(); i++) {
    row = sheet.getRow(i);
    cellKey = row.getCell(keyIndex1).toString();
    cellValue = row.getCell(valueIndex1).toString();
    txt.append("<item group=\"Mapping\" name=\"key\" sourcevalue=\"");
    txt.append(cellKey);
    txt.append("\" targevalue=\"");
    txt.append(cellValue);
    txt.append("\"/>");
    txt.append("\n");
   }
   output.write(txt.toString());
   output.close();
   System.out.println("over............."+sheet
     .getPhysicalNumberOfRows());
  } catch (Exception e) {
   e.printStackTrace();
  }

}
}