读取本地txt文件数据和excel文件数据

来源：互联网发布：ipv6 无网络访问权限编辑：程序博客网时间：2024/05/22 00:52

public class IniReader {

public static void readTxtFile(String filePath){

try {

//读取文本文件

String encoding="GBK";
File file=new File(filePath);
if(file.isFile() && file.exists()){ //判断文件是否存在
InputStreamReader read = new InputStreamReader(new FileInputStream(file),encoding);//考虑到编码格式
BufferedReader bufferedReader = new BufferedReader(read);
String lineTxt = null;
while((lineTxt = bufferedReader.readLine()) != null){
System.out.println(lineTxt);
test(lineTxt);
}
read.close();
}else{
System.out.println("找不到指定的文件");
}
} catch (Exception e) {
System.out.println("读取文件内容出错");
e.printStackTrace();
}

}

public static void main(String argv[]){
String filePath = "D:\\ini\\config.txt";
readTxtFile(filePath);
Utils rw = new Utils();
String res = rw.readExcelFile("D:\\ini\\aaa.xls");
System.out.println("res="+res);
}
public static void test(String str){
String[] split = str.split(" ");
System.out.println("1="+split[0]);
System.out.println("2="+split[1]);

}

//读取本地excel文件数据

public class Utils {

public String readExcelFile(String filename) {
StringBuffer result = new StringBuffer();
String fileToBeRead = filename;

// 创建对Excel工作簿文件的引用
HSSFWorkbook workbook = null;
try {
workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));

// 创建对工作表的引用。
HSSFSheet sheet = workbook.getSheetAt(0);
// HSSFSheet sheet = workbook.getSheet("Sheet1");
// 便利所有单元格，读取单元格
int row_num = sheet.getLastRowNum();
for (int i = 0; i < row_num+1; i++) {
HSSFRow r = sheet.getRow(i);
int cell_num = r.getLastCellNum();
for (int j = 0; j < cell_num; j++) {
//System.out.println(r.getCell((short)j).getCellType());
if(r.getCell((short)j).getCellType() == 1){
result.append(r.getCell((short) j).getStringCellValue());
}else{
result.append(r.getCell((short) j).getNumericCellValue());
}
result.append("\t");
}
result.append("\n");
}
} catch (FileNotFoundException e) {
System.out.println("文件没找到 : " + e);
} catch (IOException e) {
System.out.println("已运行IO异常: " + e);
}
return result.toString();

}

public void writeExcel(String path, String content) {
String outputFile = path;
String data = content;

try {
// 创建新的Excel 工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
// 在Excel工作簿中建一工作表，其名为缺省值
HSSFSheet sheet = workbook.createSheet();

String[] rows = data.split("\n");
for (int i = 0; i < rows.length; i++) {
HSSFRow row = sheet.createRow((short) i);
String[] cells = rows[i].split("\t");
for (int j = 0; j < cells.length; j++) {
HSSFCell cell = row.createCell((short) j);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(cells[j]);
}
}
// 新建一输出文件流
FileOutputStream fOut = new FileOutputStream(outputFile);
// 把相应的Excel 工作簿存盘
workbook.write(fOut);
fOut.flush();
// 操作结束，关闭文件
fOut.close();
System.out.println(path + "文件生成完毕...");

} catch (FileNotFoundException e) {
System.out.println("文件没找到 : " + e);
} catch (IOException e) {
System.out.println("已运行IO异常 : " + e);
}
}

public String readWordFile(String filename) {
return "";
}
}

0 0