请问我这个java代码怎么添加poi包的代码才能实现删除excel文件的第一行?
package cn.ayee.xhd_Ledger;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FilenameFilter;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class NhdLedger {
public static void main(String[] args) throws IOException {
File srcFolder = new File("G:\\share");
File destFolder = new File("G:\\newShare");
if(!destFolder.isDirectory()) {
destFolder.mkdir();
}
//获取该目录下的被复制文件的File数组
File[] fileArray = srcFolder.listFiles(new FilenameFilter() {
@Override
public boolean accept(File dir, String name) {
return new File(dir, name).isFile() && name.endsWith(".xls");
}
});
//遍历被复制文件的File数组,得到每一个被复制文件对象
for(File file : fileArray) {
String name = file.getName();
File newFile = new File(destFolder, name);
copyFile(file, newFile);
File[] destFileArray = destFolder.listFiles();
//在目的地目录下改名
//获取复制文件的File数组
for(File destFile : destFileArray) {
String newName = destFile.getName().replace(name,"enterbill.xls");
//封装复制的新文件的路径名
File destNewFile = new File(destFolder, newName);
//改名
destFile.renameTo(destNewFile);
//加上下面这段POI包的代码就报错
/* FileInputStream is = new FileInputStream(destNewFile);
HSSFWorkbook workbook = new HSSFWorkbook(is);
HSSFSheet sheet = workbook.getSheetAt(0);
sheet.shiftRows(1, 1, -1);
FileOutputStream os = new FileOutputStream(destNewFile);
workbook.write(os);
is.close();
os.close();*/
}
}
}
public static void copyFile(File file, File newFile) throws IOException {
BufferedInputStream bis = new BufferedInputStream(new FileInputStream(file));
BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(newFile));
byte[] bys = new byte[1024];
int len;
while((len = bis.read(bys)) != -1) {
bos.write(bys, 0, len);
}
bis.close();
bos.close();
}
}