使用EasyExcel将数据写入Excel表中

最新推荐文章于 2024-08-15 09:40:08 发布

铁甲小宝磊

最新推荐文章于 2024-08-15 09:40:08 发布

阅读量2k

点赞数

文章标签： excel java 开发语言

本文链接：https://blog.csdn.net/tianl1997/article/details/129259729

版权

最近工作中遇到了需要将较多的数据写入Excel中, 使用了阿里的EasyExcel来实现功能, 下面仅用少量的数据来演示:

sql脚本:

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for demo_data
-- ----------------------------
DROP TABLE IF EXISTS `demo_data`;
CREATE TABLE `demo_data`  (
  `id` int(11) NOT NULL,
  `date` datetime(0) NULL DEFAULT NULL,
  `number` int(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of demo_data
-- ----------------------------
INSERT INTO `demo_data` VALUES (1, '2023-02-27 15:19:01', 1);
INSERT INTO `demo_data` VALUES (2, '2023-02-27 15:19:17', 2);
INSERT INTO `demo_data` VALUES (3, '2023-02-27 15:20:12', 3);
INSERT INTO `demo_data` VALUES (4, '2023-02-27 15:20:14', 4);
INSERT INTO `demo_data` VALUES (5, '2023-02-27 15:20:17', 5);
INSERT INTO `demo_data` VALUES (6, '2023-02-27 15:20:20', 6);
INSERT INTO `demo_data` VALUES (7, '2023-02-27 15:20:23', 7);
INSERT INTO `demo_data` VALUES (8, '2023-02-27 15:20:26', 8);
INSERT INTO `demo_data` VALUES (9, '2023-02-27 15:20:29', 9);
INSERT INTO `demo_data` VALUES (10,