推荐一个java万能的Excel导入导出工具

2014-10-18 08:48:00 669 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

手把手教你用PLECS仿真BUCK数字电源（含DSP代码实现）本文详细介绍了如何利用PLECS仿真软件与Visual Studio 2022搭建高保真数字电源开发环境，手把手指导从BUCK电路建模、编写硬件感知的C控制算法到参数调优的全过程。重点阐述了通过DLL接口实现软件在环仿真，模拟DSP的ADC/PWM时序，并将验证后的代码无缝迁移至TI C2000系列DSP，构建从仿真到固件的完整数字电源开发闭环，显著提升开发效率与一次成功率。阅读详情

基于poi的万能的Excel导入导出工具.
支持从List<Map>中导出.
支持从List<POJO>中导入导出.
支持从List<POJO里面还有List<POJO>>中导入导出.
支持导出类似课程表结构类型纵表.
支持国际化.
支持数据字典.
支持单元格中下拉框数据校验.
支持自动标红错误的数据.
支持模板校验，用hash值相加校验模板中的数据是否被改动过.
支持自由交换表格中的行或者列.
不写一个配置文件.
用到了适配器模式，支持任意类型的数据导入导出，用户还可以自己编写适配器操作自定义的数据类型！
示例请参照：https://github.com/hyberbin/J-Excel
下载包：http://download.csdn.net/detail/hybswan890720/8053805

相关工具推荐：https://github.com/hyberbin/J-hyberbin

...全文

保姆级教程：在阿里云ECS上用Docker一键部署EMQX MQTT服务器（Ubuntu 20.04）本文提供在阿里云ECS上使用Docker一键部署EMQX MQTT服务器的详细教程，涵盖从实例创建、Docker环境配置到EMQX部署与优化的全流程。适合物联网开发者快速搭建高效、安全的MQTT消息服务器，适用于智能家居、工业物联网等场景。阅读详情

hybswan890720

Java 51,407 成员 86,130 内容

+ 关注 + 加入社区

切换为时间正序

日知己所无 2014-10-19

打赏
举报

赞一下 CSDN为什么不提供回帖的人给发帖的人评分的功能呢…… 貌似现在发帖只能往外发分，却不能往回收分

hybswan890720 2014-10-19

打赏
举报

public class TestExcel { static { SimpleConfigurator.addConfigurator(new DbConfig("jdbc:mysql://localhost/digitalcampus?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8&autoReconnect=true", DbConfig.DEFAULT_CONFIG_NAME)); } /** * 从List<Map>中导出 * @param workbook * @throws Exception */ public static void testSimpleMapExport(Workbook workbook) throws Exception { Hyberbin hyberbin = new Hyberbin(); List<Map> list = hyberbin.getMapList("select * from dc_xxkc"); Sheet sheet = workbook.createSheet("testSimpleMapExport"); List<String> cols = new ArrayList<String>(); List<FieldColumn> fieldColumns = hyberbin.getFieldColumns(); for (FieldColumn column : fieldColumns) { cols.add(column.getColumn()); } SimpleExportService service = new SimpleExportService(sheet, list, (String[]) cols.toArray(new String[]{}), "学校课程"); service.setDic("KCLX", "KCLX").addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 service.doExport(); } /** * 从List<Vo>中导出 * @param workbook * @throws Exception */ public static void testSimpleVoExport(Workbook workbook) throws Exception { Hyberbin<SchoolCourse> hyberbin = new Hyberbin(new SchoolCourse()); List<SchoolCourse> list = hyberbin.showAll(); Sheet sheet = workbook.createSheet("testSimpleVoExport"); //ExportExcelService service = new ExportExcelService(list, sheet, "学校课程"); ExportExcelService service = new ExportExcelService(list, sheet, new String[]{"id", "courseName", "type"}, "学校课程"); service.addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 service.doExport(); } /** * 从List<Vo>，vo中还有简单循环节中导出 * @param workbook * @throws Exception */ public static void testVoHasListExport(Workbook workbook) throws Exception { Hyberbin<SchoolCourse> hyberbin = new Hyberbin(new SchoolCourse()); List<SchoolCourse> list = hyberbin.showAll(); List<String> strings = new ArrayList<String>(); for (int i = 0; i < 10; i++) { strings.add("我是第" + i + "个循环字段"); } for (SchoolCourse course : list) { course.setBaseArray(strings); } Sheet sheet = workbook.createSheet("testVoHasListExport"); ExportExcelService service = new ExportExcelService(list, sheet, new String[]{"id", "courseName", "type", "baseArray"}, "学校课程"); service.addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 service.setGroupConfig("baseArray", new GroupConfig(10) { @Override public String getLangName(int innerIndex, int index) { return "我是第" + index + "个循环字段"; } }); service.doExport(); service.exportTemplate();//生成下拉框 } /** * 从List<Vo>，vo中还有复杂循环节中导出 * @param workbook * @throws Exception */ public static void testVoHasListVoExport(Workbook workbook) throws Exception { Hyberbin<SchoolCourse> hyberbin = new Hyberbin(new SchoolCourse()); List<SchoolCourse> list = hyberbin.showAll(); for (SchoolCourse course : list) { List<InnerVo> innerVos = new ArrayList<InnerVo>(); for (int i = 0; i < 10; i++) { innerVos.add(new InnerVo("key1", "value1")); } course.setInnerVoArray(innerVos); } Sheet sheet = workbook.createSheet("testVoHasListVoExport"); ExportExcelService service = new ExportExcelService(list, sheet, new String[]{"id", "courseName", "type", "innerVoArray"}, "学校课程"); service.addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 for (int i = 0; i < 10; i++) { service.addTook("hiddenvalue", "key", i, "something"); } service.setGroupConfig("innerVoArray", new GroupConfig(2, 10) { @Override public String getLangName(int innerIndex, int index) { return "我是第" + index + "个循环字段,第" + innerIndex + "个属性"; } }); service.doExport(); } /** * 导出一个纵表（课程表之类的） * @param workbook * @throws Exception */ public static void testTableExport(Workbook workbook) throws Exception { Sheet sheet = workbook.createSheet("testTableExport"); TableBean tableBean = new TableBean(3, 3); Collection<CellBean> cellBeans = new HashSet<CellBean>(); for (int i = 0; i < 3; i++) { for (int j = 0; j < 3; j++) { CellBean cellBean = new CellBean(i * 3 + j + "", i, j); cellBeans.add(cellBean); } } tableBean.setCellBeans(cellBeans); ExportTableService tableService = new ExportTableService(sheet, tableBean); tableService.doExport(); } /** * 从List<Vo>中入 * @param workbook * @throws Exception */ public static void testSimpleVoImport(Workbook workbook) throws Exception { Sheet sheet = workbook.getSheet("testSimpleVoExport"); ImportExcelService service = new ImportExcelService(SchoolCourse.class, sheet); service.addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 List list = service.doImport(); System.out.println("成功导入：" + list.size() + "条数据"); } /** * 从List<Vo>，vo中还有简单循环节中导入 * @param workbook * @throws Exception */ public static void testVoHasListImport(Workbook workbook) throws Exception { Sheet sheet = workbook.getSheet("testVoHasListExport"); ImportExcelService service = new ImportExcelService(SchoolCourse.class, sheet); service.addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 List list = service.doImport(); System.out.println("成功导入：" + list.size() + "条数据"); } /** * 从List<Vo>，vo中还有复杂循环节中导入 * @param workbook * @throws Exception */ public static void testVoHasListVoImport(Workbook workbook) throws Exception { Sheet sheet = workbook.getSheet("testVoHasListVoExport"); ImportExcelService service = new ImportExcelService(SchoolCourse.class, sheet); service.addDic("KCLX", "1", "国家课程").addDic("KCLX", "2", "学校课程");//设置数据字典 List list = service.doImport(); System.out.println("成功导入：" + list.size() + "条数据"); } public static void main(String[] args) throws Exception { Workbook workbook = new HSSFWorkbook(); testSimpleMapExport(workbook); testSimpleVoExport(workbook); testVoHasListExport(workbook); testVoHasListVoExport(workbook); testTableExport(workbook); testSimpleVoImport(workbook); testVoHasListImport(workbook); testVoHasListVoImport(workbook); workbook.write(new FileOutputStream("D:\\excel.xls")); }

hybswan890720 2014-10-19

打赏
举报

示例请参照：https://github.com/hyberbin/J-Excel

Magical茏 2014-10-18

打赏
举报

赞一个楼主既然推荐能不能有点demo

推荐一个java万能的Excel导入导出工具

相关推荐