[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_11":-5},"routes/user.$name.replies",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":16},"replies",[34],"user",{"_20":21,"_13":14,"_22":23,"_24":14,"_25":26,"_27":28,"_29":30,"_31":16,"_32":33},"loginname","huhuime","page",1,"limit",50,"total","id","37431","avatar_url","https://avatars2.githubusercontent.com/u/6631239?v=4","githubUsername","create_at","2019-06-27 01:55:58.097","score",5,"topic_count",0,"reply_count","is_star",false,{"_20":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":33,"_47":33,"_31":48,"_49":50,"_25":51,"_52":53},"12541","author_id","13952","tab","share","content","excel的导入导出在一般业务系统里是非常常见的，但是nodejs里并没有成熟的处理excel的库，导入问题不大，稍微复杂的导出就搞不定了\r\n\r\n那么，只剩下曲线救国一条路了\r\n\r\n\r\nexcel的导入导出在一般业务系统里是非常常见的，但是nodejs里并没有成熟的处理excel的库，导入问题不大，稍微复杂的导出就搞不定了\r\n\r\n- exceljs \r\n- excel.js \r\n- node-xlsx\r\n\r\n都太简单了...\r\n\r\n那么，只剩下曲线救国一条路了\r\n\r\n## 合理架构\r\n\r\nnode的优点就不说了，它虽好，但毕竟才出来几年，很多东西都不够完善的，所以在使用这种比较新比较潮的技术的时候，一定要学会扬长避短，不然会很难受\r\n\r\napache的poi是一个不错的库，非常成熟，我从07年就开始用它，\r\n\r\n下面是百科的简介\r\n\r\n\r\nApache POI 是用Java编写的免费开源的跨平台的 Java API，Apache POI提供API给Java程式对Microsoft Office格式档案读和写的功能。POI为“Poor Obfuscation Implementation”的首字母缩写，意为“可怜的模糊实现”。\r\n\r\nApache POI 是创建和维护操作各种符合Office Open XML（OOXML）标准和微软的OLE 2复合文档格式（OLE2）的Java API。用它可以使用Java读取和创建,修改MS Excel文件.而且,还可以使用Java读取和创建MS Word和MSPowerPoint文件。Apache POI 提供Java操作Excel解决方案（适用于Excel97-2008）。\r\n\r\n\r\nhttp://poi.apache.org/\r\n\r\n我们需要考虑以下问题：\r\n\r\n- 多语言是否合适？\r\n- 分拆功能是否合适？\r\n\r\n## 思考\r\n\r\n系统小的时候肯定会尽量统一的，系统大了就会有各种鸟了\r\n\r\n比如创业初期，可能是rails or express写的东西，但随着业务的壮大，会发现瓶颈的，这个时候你需要扩容\r\n\r\n你多加台机器，然后部署一次\r\n\r\n可是这样真的好么？\r\n\r\n理想的做法是拆分成小模块，就像处理redis缓存一样，业务量大了，就立马多起几个docker实例，非常好运维\r\n\r\n而且从职责上看，它也是小而美的代表\r\n\r\n既然小了，那么你用什么语言开发还重要么？\r\n\r\n比如我的核心系统是expressjs写的，我的下载就用的java写的，我部署了2个，然后nginx处理一下，谁又能看出来差别呢？\r\n\r\n而且我的express一定要多起几个实例，而java的可能并发比较少，我没有去浪费资源。\r\n\r\n\r\n## 分享一个简单的工具类\r\n\r\n\r\n package im.xbm.dlcenter.test;\r\n\r\n import java.io.File;\r\n import java.io.FileInputStream;\r\n import java.io.IOException;\r\n import java.text.DecimalFormat;\r\n import java.text.SimpleDateFormat;\r\n import java.util.ArrayList;\r\n import java.util.List;\r\n\r\n import org.apache.poi.hssf.usermodel.HSSFCell;\r\n import org.apache.poi.hssf.usermodel.HSSFDateUtil;\r\n import org.apache.poi.hssf.usermodel.HSSFRow;\r\n import org.apache.poi.hssf.usermodel.HSSFSheet;\r\n import org.apache.poi.hssf.usermodel.HSSFWorkbook;\r\n import org.apache.poi.xssf.usermodel.XSSFCell;\r\n import org.apache.poi.xssf.usermodel.XSSFRow;\r\n import org.apache.poi.xssf.usermodel.XSSFSheet;\r\n import org.apache.poi.xssf.usermodel.XSSFWorkbook;\r\n\r\n public class ExcelUtils {\r\n \t// 对外提供读取excel文件的接口\r\n \tpublic static List> readExcel(File file) throws IOException {\r\n \t\tString fName = file.getName();\r\n \t\tString extension = fName.lastIndexOf(\".\") == -1 ? \"\" : fName\r\n \t\t\t\t.substring(fName.lastIndexOf(\".\") + 1);\r\n \t\tif (\"xls\".equals(extension)) {// 2003\r\n \t\t\tSystem.err.println(\"读取excel2003文件内容\");\r\n \t\t\treturn read2003Excel(file);\r\n \t\t} else if (\"xlsx\".equals(extension)) {// 2007\r\n \t\t\tSystem.err.println(\"读取excel2007文件内容\");\r\n \t\t\treturn read2007Excel(file);\r\n \t\t} else {\r\n \t\t\tthrow new IOException(\"不支持的文件类型:\" + extension);\r\n \t\t}\r\n \t}\r\n\r\n \t/**\r\n \t * 读取2003excel\r\n \t * \r\n \t * @param file\r\n \t * @return\r\n \t */\r\n \tprivate static List> read2003Excel(File file)\r\n \t\t\tthrows IOException {\r\n \t\tList> dataList = new ArrayList();\r\n \t\tHSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));\r\n \t\tHSSFSheet sheet = wb.getSheetAt(0);\r\n \t\tHSSFRow row = null;\r\n \t\tHSSFCell cell = null;\r\n \t\tObject val = null;\r\n \t\tDecimalFormat df = new DecimalFormat(\"0\");// 格式化数字\r\n \t\tSimpleDateFormat sdf = new SimpleDateFormat(\"yyyy-MM-dd HH:mm:ss\");// 格式化日期字符串\r\n \t\tfor (int i = sheet.getFirstRowNum(); i < sheet\r\n \t\t\t\t.getPhysicalNumberOfRows(); i++) {\r\n \t\t\trow = sheet.getRow(i);\r\n \t\t\tif (row == null) {\r\n \t\t\t\tcontinue;\r\n \t\t\t}\r\n \t\t\tList