//使用poi,用java实现清除excel工作簿内容之间空行
public void delLineNull(String infileName) {
System.out.println("开始移除空行操作");
int key = 0;
int MaxRowNum = 0,MaxCellNum = 0;
try {
FileInputStream in = new FileInputStream(infileName);
POIFSFileSystem fs = new POIFSFileSystem(in);
HSSFWorkbook workbook = new HSSFWorkbook(fs);
FileOutputStream out = new FileOutputStream("D:\\ee.xls");
int number = workbook.getNumberOfSheets();
for (int i = 0; i < number; i++) { // 对每个sheet检查空行
HSSFSheet sheet = workbook.getSheetAt(i); //14
System.out.println("正在对工作簿:" + sheet.getSheetName() + " 移除空行操作 行数"
+ (sheet.getLastRowNum() + 1));
MaxRowNum = 0;
for (int k = 0; k <= sheet.getLastRowNum(); k++) {
HSSFRow hRow = sheet.getRow(k);
//System.out.println((k + 1) + "行");
if (isBlankRow(hRow)) // 找到空行索引
{
int m = 0;
for (m = k + 1; m <= sheet.getLastRowNum(); m++) {
HSSFRow nhRow = sheet.getRow(m);
if (!isBlankRow(nhRow)) {
//System.out.println("下一个非空行" + (m + 1));
sheet.shiftRows(m, sheet.getLastRowNum(), k - m);
break;
}