public class ExcelToCpt {
/**
* excel转换成Cpt实现在线预览
* @param file excel文件
* @param cpt Cpt文件
*/
public static void ExcelToCpt(String file, String cpt) {
File excelFile = new File(file); // 获取EXCEL文件;
//传入的不是目录
if (!excelFile.isDirectory()) {
System.out.println("path=" + excelFile.getPath());
System.out.println("name=" + excelFile.getName());
//传入的是目录
} else if (excelFile.isDirectory()) {
String[] filelist = excelFile.list();
for (int i = 0; i < filelist.length; i++) {
File readfile = new File(file + "\\" + filelist[i]);
if (!readfile.isDirectory()) {
System.out.println("path=" + readfile.getPath());
System.out.println("name=" + readfile.getName());
} else if (readfile.isDirectory()) {
ExcelToCpt(file + "\\" + filelist[i],cpt);
}
}
}
FileInputStream a;
TemplateWorkBook tpl = null;
try {
a = new FileInputStream(excelFile);
// System.err.println(EngineModule.class.getName());
ModuleContext.startModule(EngineModule.class.getName());
// 需要对导出的excel的版本进行判断
String fileName = excelFile.getName();
// 获得输入的文本的判断是哪个形式的
String extension = fileName.lastIndexOf(".") == -1 ? "" : fileName.substring(fileName.lastIndexOf(".") + 1);
if ("xls".equals(extension)) {
tpl = new ExcelReportImporter().generateWorkBookByStream(a);
} else if ("xlsx".equals(extension)) {
tpl = new Excel2007ReportImporter().generateWorkBookByStream(a);
}
//转换后获得到Cpt的模板
File Cpt=new File(cpt);
OutputStream outputStream = new FileOutputStream(Cpt);
((IOFile) tpl).export(outputStream);
outputStream.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
ModuleContext.stopModules();
}
//测试
// public static void main(String[] args) throws Exception {
// ExcelToCpt cpt = new ExcelToCpt();
// cpt.ExcelToCpt("F:\\abc.xls", "F:\\abc.cpt");
// }
}
/**
* excel转换成Cpt实现在线预览
* @param file excel文件
* @param cpt Cpt文件
*/
public static void ExcelToCpt(String file, String cpt) {
File excelFile = new File(file); // 获取EXCEL文件;
//传入的不是目录
if (!excelFile.isDirectory()) {
System.out.println("path=" + excelFile.getPath());
System.out.println("name=" + excelFile.getName());
//传入的是目录
} else if (excelFile.isDirectory()) {
String[] filelist = excelFile.list();
for (int i = 0; i < filelist.length; i++) {
File readfile = new File(file + "\\" + filelist[i]);
if (!readfile.isDirectory()) {
System.out.println("path=" + readfile.getPath());
System.out.println("name=" + readfile.getName());
} else if (readfile.isDirectory()) {
ExcelToCpt(file + "\\" + filelist[i],cpt);
}
}
}
FileInputStream a;
TemplateWorkBook tpl = null;
try {
a = new FileInputStream(excelFile);
// System.err.println(EngineModule.class.getName());
ModuleContext.startModule(EngineModule.class.getName());
// 需要对导出的excel的版本进行判断
String fileName = excelFile.getName();
// 获得输入的文本的判断是哪个形式的
String extension = fileName.lastIndexOf(".") == -1 ? "" : fileName.substring(fileName.lastIndexOf(".") + 1);
if ("xls".equals(extension)) {
tpl = new ExcelReportImporter().generateWorkBookByStream(a);
} else if ("xlsx".equals(extension)) {
tpl = new Excel2007ReportImporter().generateWorkBookByStream(a);
}
//转换后获得到Cpt的模板
File Cpt=new File(cpt);
OutputStream outputStream = new FileOutputStream(Cpt);
((IOFile) tpl).export(outputStream);
outputStream.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
ModuleContext.stopModules();
}
//测试
// public static void main(String[] args) throws Exception {
// ExcelToCpt cpt = new ExcelToCpt();
// cpt.ExcelToCpt("F:\\abc.xls", "F:\\abc.cpt");
// }
}