java读取excel表格拼接sql_poi解析Excel，遍历表结构，获取单元格内容，拼接sql语句，写入TXT文件...

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.ss.usermodel.WorkbookFactory;

public class SqlCreate {

/**

* @param args

* @throws IOException

* @throws FileNotFoundException

*/

private static String path = "F:\\15xsd修改\\03_SMD"; // execl保存路径

private static String savepath = "F:\\15xsd修改\\增量脚本\\zlsql2.txt"; //拼接后的sql保存路径

public static void main(String[] args) {

try {

File file = new File(path); //此处file不是文件，是路径

FileOutputStream out = new FileOutputStream(savepath);

// OutputStream out = new FileOutputStream(savepath);

Workbook wb = null;

int count=0;

for (File f : file.listFiles()) { //通过".listFiles()"方法遍历路径下文件

count++;

System.out.println("获取文件：" + f+"----"+count);

InputStream excelFileInputStream = null;

excelFileInputStream = new FileInputStream(f);

wb = WorkbookFactory.create(excelFileInputStream);

excelFileInputStream.close();

Sheet st = wb.getSheet("TAB");

Sheet sc = wb.getSheet("COL");

int stl = st.getLastRowNum();

int scl = sc.getLastRowNum();

Row rowst = st.getRow(4);

Cell cellschema = rowst.getCell(2);

// System.out.println(cellschema);

String sql = "";

for (int i = 0; i < scl; i++) {

// String sql="";

Row row = sc.getRow(i);//获取Excel的行，下标从0开始

if (row == null) {//若行为空，则遍历下一行

continue;

}

Cell cell = row.getCell(1);//获取指定单元格，单元格从左到右下标从0开始

Cell cell2=row.getCell(0);

if (cell != null

&& cell.getStringCellValue().equals("C_DJHKYKWDCL")) {

// sql += "ALTER TABLE " + cellschema + "."+cell2

// + " RENAME N_DJHKYKWDCL TO C_DJHKYKWDCL;"+"\n" ;

sql += "ALTER TABLE " + cellschema + "."+cell2

+ " ALTER C_DJHKYKWDCL TYPE TEXT;"+"\n" ;

System.out.println(sql);

byte[]a = sql.getBytes();

out.write(a);

}

}

}

out.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}