• xlsxStyle + xlsx.full.min 导出数据，并设置导出样式

    1. html>
    2. <html>
    3.  
    4. <head>
    5. 	<title>SheetJS JS-XLSXtitle>
    6. 	<meta charset="utf-8" />
    7. head>
    8.  
    9. <body>
    10. 	<script type="text/javascript" src="./xlsx.full.min.js">script>
    11. 	<script type="text/javascript" src="./xlsxStyle.core.min.js">script>
    12. 	<script type="text/javascript" src="./xlsxStyle.utils.js">script>
    13. 	<script>
    14.  
    15. 		function saveAs(obj, fileName) {
    16. 			var tmpA = document.createElement("a");
    17. 			tmpA.download = fileName || "下载";
    18. 			tmpA.href = URL.createObjectURL(obj);
    19. 			tmpA.click();
    20. 			setTimeout(function () {
    21. 				URL.revokeObjectURL(obj);
    22. 			}, 50);
    23. 		};
    24.  
    25. 		const serveHead = [
    26. 			{
    27. 				'startTime': '报警开始时间'
    28. 			},
    29. 			{
    30. 				'endTime': '报警结束时间'
    31. 			},
    32. 			{
    33. 				'eventLevel': '报警等级'
    34. 			},
    35. 			{
    36. 				'mmsi': 'MMSI'
    37. 			},
    38. 			{
    39. 				'name': '船名'
    40. 			},
    41. 			{
    42. 				'alarmTime': '报警时间'
    43. 			},
    44. 			{
    45. 				'nearestCable': '海域'
    46. 			},
    47. 			{
    48. 				'sog': '船速(节)'
    49. 			},
    50.  
    51. 			{
    52. 				'minDistance': '距离(米)'
    53. 			},
    54. 			{
    55. 				'alarmDescription': '描述'
    56. 			}
    57. 		];
    58.  
    59. 		const serveData = [
    60. 			{
    61. 				"mmsi": 413770025,
    62. 				"name": "WANXUANCHENGHUO0859",
    63. 				"startTime": "2022-11-05 11:54:15",
    64. 				"endTime": "2022-11-05 12:00:15",
    65. 				"eventLevel": "预警",
    66. 				"details": [
    67. 					{
    68. 						"startTime": "2022-11-05 11:54:15",
    69. 						"endTime": "2022-11-05 12:00:15",
    70. 						"eventLevel": "预警",
    71. 						"eventType": null,
    72. 						"mmsi": 413770025,
    73. 						"name": "WANXUANCHENGHUO0859",
    74. 						"nearestCable": null,
    75. 						"alarmDescription": null,
    76. 						"sog": null,
    77. 						"cog": null,
    78. 						"minDistance": null,
    79. 						"lon": null,
    80. 						"lat": null,
    81. 						"alarmTime": "2022-11-05 11:54:15",
    82. 						"beginTime": null,
    83. 						"finishTime": null,
    84. 						"reportTime": null,
    85. 						"groupByStr": "413770025_2022-11-05 11:54:15_2022-11-05 12:00:15_预警_WANXUANCHENGHUO0859"
    86. 					},
    87. 					{
    88. 						"startTime": "2022-11-05 11:54:15",
    89. 						"endTime": "2022-11-05 12:00:15",
    90. 						"eventLevel": "预警",
    91. 						"eventType": null,
    92. 						"mmsi": 413770025,
    93. 						"name": "WANXUANCHENGHUO0859",
    94. 						"nearestCable": null,
    95. 						"alarmDescription": null,
    96. 						"sog": null,
    97. 						"cog": null,
    98. 						"minDistance": null,
    99. 						"lon": null,
    100. 						"lat": null,
    101. 						"alarmTime": "2022-11-05 12:00:15",
    102. 						"beginTime": null,
    103. 						"finishTime": null,
    104. 						"reportTime": null,
    105. 						"groupByStr": "413770025_2022-11-05 11:54:15_2022-11-05 12:00:15_预警_WANXUANCHENGHUO0859"
    106. 					}
    107. 				]
    108. 			},
    109. 			{
    110. 				"mmsi": 413989743,
    111. 				"name": "LUZAOZHUANGHUO2216",
    112. 				"startTime": "2022-11-05 09:32:41",
    113. 				"endTime": "2022-11-05 09:41:41",
    114. 				"eventLevel": "预警",
    115. 				"details": [
    116. 					{
    117. 						"startTime": "2022-11-05 09:32:41",
    118. 						"endTime": "2022-11-05 09:41:41",
    119. 						"eventLevel": "预警",
    120. 						"eventType": null,
    121. 						"mmsi": 413989743,
    122. 						"name": "LUZAOZHUANGHUO2216",
    123. 						"nearestCable": null,
    124. 						"alarmDescription": null,
    125. 						"sog": null,
    126. 						"cog": null,
    127. 						"minDistance": null,
    128. 						"lon": null,
    129. 						"lat": null,
    130. 						"alarmTime": "2022-11-05 09:38:41",
    131. 						"beginTime": null,
    132. 						"finishTime": null,
    133. 						"reportTime": null,
    134. 						"groupByStr": "413989743_2022-11-05 09:32:41_2022-11-05 09:41:41_预警_LUZAOZHUANGHUO2216"
    135. 					},
    136. 					{
    137. 						"startTime": "2022-11-05 09:32:41",
    138. 						"endTime": "2022-11-05 09:41:41",
    139. 						"eventLevel": "预警",
    140. 						"eventType": null,
    141. 						"mmsi": 413989743,
    142. 						"name": "LUZAOZHUANGHUO2216",
    143. 						"nearestCable": null,
    144. 						"alarmDescription": null,
    145. 						"sog": null,
    146. 						"cog": null,
    147. 						"minDistance": null,
    148. 						"lon": null,
    149. 						"lat": null,
    150. 						"alarmTime": "2022-11-05 09:41:41",
    151. 						"beginTime": null,
    152. 						"finishTime": null,
    153. 						"reportTime": null,
    154. 						"groupByStr": "413989743_2022-11-05 09:32:41_2022-11-05 09:41:41_预警_LUZAOZHUANGHUO2216"
    155. 					},
    156. 					{
    157. 						"startTime": "2022-11-05 09:32:41",
    158. 						"endTime": "2022-11-05 09:41:41",
    159. 						"eventLevel": "预警",
    160. 						"eventType": null,
    161. 						"mmsi": 413989743,
    162. 						"name": "LUZAOZHUANGHUO2216",
    163. 						"nearestCable": null,
    164. 						"alarmDescription": null,
    165. 						"sog": null,
    166. 						"cog": null,
    167. 						"minDistance": null,
    168. 						"lon": null,
    169. 						"lat": null,
    170. 						"alarmTime": "2022-11-05 09:35:41",
    171. 						"beginTime": null,
    172. 						"finishTime": null,
    173. 						"reportTime": null,
    174. 						"groupByStr": "413989743_2022-11-05 09:32:41_2022-11-05 09:41:41_预警_LUZAOZHUANGHUO2216"
    175. 					},
    176. 					{
    177. 						"startTime": "2022-11-05 09:32:41",
    178. 						"endTime": "2022-11-05 09:41:41",
    179. 						"eventLevel": "预警",
    180. 						"eventType": null,
    181. 						"mmsi": 413989743,
    182. 						"name": "LUZAOZHUANGHUO2216",
    183. 						"nearestCable": null,
    184. 						"alarmDescription": null,
    185. 						"sog": null,
    186. 						"cog": null,
    187. 						"minDistance": null,
    188. 						"lon": null,
    189. 						"lat": null,
    190. 						"alarmTime": "2022-11-05 09:32:41",
    191. 						"beginTime": null,
    192. 						"finishTime": null,
    193. 						"reportTime": null,
    194. 						"groupByStr": "413989743_2022-11-05 09:32:41_2022-11-05 09:41:41_预警_LUZAOZHUANGHUO2216"
    195. 					}
    196. 				]
    197. 			},
    198. 			{
    199. 				"mmsi": 413865686,
    200. 				"name": "未知",
    201. 				"startTime": "2022-11-05 11:09:46",
    202. 				"endTime": "2022-11-05 11:09:46",
    203. 				"eventLevel": "预警",
    204. 				"details": [
    205. 					{
    206. 						"startTime": "2022-11-05 11:09:46",
    207. 						"endTime": "2022-11-05 11:09:46",
    208. 						"eventLevel": "预警",
    209. 						"eventType": null,
    210. 						"mmsi": 413865686,
    211. 						"name": "未知",
    212. 						"nearestCable": null,
    213. 						"alarmDescription": null,
    214. 						"sog": null,
    215. 						"cog": null,
    216. 						"minDistance": null,
    217. 						"lon": null,
    218. 						"lat": null,
    219. 						"alarmTime": "2022-11-05 11:09:46",
    220. 						"beginTime": null,
    221. 						"finishTime": null,
    222. 						"reportTime": null,
    223. 						"groupByStr": "413865686_2022-11-05 11:09:46_2022-11-05 11:09:46_预警_未知"
    224. 					},
    225. 					{
    226. 						"startTime": "2022-11-05 11:09:46",
    227. 						"endTime": "2022-11-05 11:09:46",
    228. 						"eventLevel": "预警",
    229. 						"eventType": null,
    230. 						"mmsi": 413865686,
    231. 						"name": "未知",
    232. 						"nearestCable": null,
    233. 						"alarmDescription": null,
    234. 						"sog": null,
    235. 						"cog": null,
    236. 						"minDistance": null,
    237. 						"lon": null,
    238. 						"lat": null,
    239. 						"alarmTime": "2022-11-05 11:09:46",
    240. 						"beginTime": null,
    241. 						"finishTime": null,
    242. 						"reportTime": null,
    243. 						"groupByStr": "413865686_2022-11-05 11:09:46_2022-11-05 11:09:46_预警_未知"
    244. 					}
    245. 				]
    246. 			},
    247. 			{
    248. 				"mmsi": 413996871,
    249. 				"name": "未知",
    250. 				"startTime": "2022-11-05 09:21:16",
    251. 				"endTime": "2022-11-05 09:28:55",
    252. 				"eventLevel": "预警",
    253. 				"details": [
    254. 					{
    255. 						"startTime": "2022-11-05 09:21:16",
    256. 						"endTime": "2022-11-05 09:28:55",
    257. 						"eventLevel": "预警",
    258. 						"eventType": null,
    259. 						"mmsi": 413996871,
    260. 						"name": "未知",
    261. 						"nearestCable": null,
    262. 						"alarmDescription": null,
    263. 						"sog": null,
    264. 						"cog": null,
    265. 						"minDistance": null,
    266. 						"lon": null,
    267. 						"lat": null,
    268. 						"alarmTime": "2022-11-05 09:24:05",
    269. 						"beginTime": null,
    270. 						"finishTime": null,
    271. 						"reportTime": null,
    272. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    273. 					},
    274. 					{
    275. 						"startTime": "2022-11-05 09:21:16",
    276. 						"endTime": "2022-11-05 09:28:55",
    277. 						"eventLevel": "预警",
    278. 						"eventType": null,
    279. 						"mmsi": 413996871,
    280. 						"name": "未知",
    281. 						"nearestCable": null,
    282. 						"alarmDescription": null,
    283. 						"sog": null,
    284. 						"cog": null,
    285. 						"minDistance": null,
    286. 						"lon": null,
    287. 						"lat": null,
    288. 						"alarmTime": "2022-11-05 09:28:55",
    289. 						"beginTime": null,
    290. 						"finishTime": null,
    291. 						"reportTime": null,
    292. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    293. 					},
    294. 					{
    295. 						"startTime": "2022-11-05 09:21:16",
    296. 						"endTime": "2022-11-05 09:28:55",
    297. 						"eventLevel": "预警",
    298. 						"eventType": null,
    299. 						"mmsi": 413996871,
    300. 						"name": "未知",
    301. 						"nearestCable": null,
    302. 						"alarmDescription": null,
    303. 						"sog": null,
    304. 						"cog": null,
    305. 						"minDistance": null,
    306. 						"lon": null,
    307. 						"lat": null,
    308. 						"alarmTime": "2022-11-05 09:27:19",
    309. 						"beginTime": null,
    310. 						"finishTime": null,
    311. 						"reportTime": null,
    312. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    313. 					},
    314. 					{
    315. 						"startTime": "2022-11-05 09:21:16",
    316. 						"endTime": "2022-11-05 09:28:55",
    317. 						"eventLevel": "预警",
    318. 						"eventType": null,
    319. 						"mmsi": 413996871,
    320. 						"name": "未知",
    321. 						"nearestCable": null,
    322. 						"alarmDescription": null,
    323. 						"sog": null,
    324. 						"cog": null,
    325. 						"minDistance": null,
    326. 						"lon": null,
    327. 						"lat": null,
    328. 						"alarmTime": "2022-11-05 09:25:17",
    329. 						"beginTime": null,
    330. 						"finishTime": null,
    331. 						"reportTime": null,
    332. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    333. 					},
    334. 					{
    335. 						"startTime": "2022-11-05 09:21:16",
    336. 						"endTime": "2022-11-05 09:28:55",
    337. 						"eventLevel": "预警",
    338. 						"eventType": null,
    339. 						"mmsi": 413996871,
    340. 						"name": "未知",
    341. 						"nearestCable": null,
    342. 						"alarmDescription": null,
    343. 						"sog": null,
    344. 						"cog": null,
    345. 						"minDistance": null,
    346. 						"lon": null,
    347. 						"lat": null,
    348. 						"alarmTime": "2022-11-05 09:26:17",
    349. 						"beginTime": null,
    350. 						"finishTime": null,
    351. 						"reportTime": null,
    352. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    353. 					},
    354. 					{
    355. 						"startTime": "2022-11-05 09:21:16",
    356. 						"endTime": "2022-11-05 09:28:55",
    357. 						"eventLevel": "预警",
    358. 						"eventType": null,
    359. 						"mmsi": 413996871,
    360. 						"name": "未知",
    361. 						"nearestCable": null,
    362. 						"alarmDescription": null,
    363. 						"sog": null,
    364. 						"cog": null,
    365. 						"minDistance": null,
    366. 						"lon": null,
    367. 						"lat": null,
    368. 						"alarmTime": "2022-11-05 09:26:47",
    369. 						"beginTime": null,
    370. 						"finishTime": null,
    371. 						"reportTime": null,
    372. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    373. 					},
    374. 					{
    375. 						"startTime": "2022-11-05 09:21:16",
    376. 						"endTime": "2022-11-05 09:28:55",
    377. 						"eventLevel": "预警",
    378. 						"eventType": null,
    379. 						"mmsi": 413996871,
    380. 						"name": "未知",
    381. 						"nearestCable": null,
    382. 						"alarmDescription": null,
    383. 						"sog": null,
    384. 						"cog": null,
    385. 						"minDistance": null,
    386. 						"lon": null,
    387. 						"lat": null,
    388. 						"alarmTime": "2022-11-05 09:24:45",
    389. 						"beginTime": null,
    390. 						"finishTime": null,
    391. 						"reportTime": null,
    392. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    393. 					},
    394. 					{
    395. 						"startTime": "2022-11-05 09:21:16",
    396. 						"endTime": "2022-11-05 09:28:55",
    397. 						"eventLevel": "预警",
    398. 						"eventType": null,
    399. 						"mmsi": 413996871,
    400. 						"name": "未知",
    401. 						"nearestCable": null,
    402. 						"alarmDescription": null,
    403. 						"sog": null,
    404. 						"cog": null,
    405. 						"minDistance": null,
    406. 						"lon": null,
    407. 						"lat": null,
    408. 						"alarmTime": "2022-11-05 09:21:16",
    409. 						"beginTime": null,
    410. 						"finishTime": null,
    411. 						"reportTime": null,
    412. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    413. 					},
    414. 					{
    415. 						"startTime": "2022-11-05 09:21:16",
    416. 						"endTime": "2022-11-05 09:28:55",
    417. 						"eventLevel": "预警",
    418. 						"eventType": null,
    419. 						"mmsi": 413996871,
    420. 						"name": "未知",
    421. 						"nearestCable": null,
    422. 						"alarmDescription": null,
    423. 						"sog": null,
    424. 						"cog": null,
    425. 						"minDistance": null,
    426. 						"lon": null,
    427. 						"lat": null,
    428. 						"alarmTime": "2022-11-05 09:25:47",
    429. 						"beginTime": null,
    430. 						"finishTime": null,
    431. 						"reportTime": null,
    432. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    433. 					},
    434. 					{
    435. 						"startTime": "2022-11-05 09:21:16",
    436. 						"endTime": "2022-11-05 09:28:55",
    437. 						"eventLevel": "预警",
    438. 						"eventType": null,
    439. 						"mmsi": 413996871,
    440. 						"name": "未知",
    441. 						"nearestCable": null,
    442. 						"alarmDescription": null,
    443. 						"sog": null,
    444. 						"cog": null,
    445. 						"minDistance": null,
    446. 						"lon": null,
    447. 						"lat": null,
    448. 						"alarmTime": "2022-11-05 09:23:28",
    449. 						"beginTime": null,
    450. 						"finishTime": null,
    451. 						"reportTime": null,
    452. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    453. 					},
    454. 					{
    455. 						"startTime": "2022-11-05 09:21:16",
    456. 						"endTime": "2022-11-05 09:28:55",
    457. 						"eventLevel": "预警",
    458. 						"eventType": null,
    459. 						"mmsi": 413996871,
    460. 						"name": "未知",
    461. 						"nearestCable": null,
    462. 						"alarmDescription": null,
    463. 						"sog": null,
    464. 						"cog": null,
    465. 						"minDistance": null,
    466. 						"lon": null,
    467. 						"lat": null,
    468. 						"alarmTime": "2022-11-05 09:28:24",
    469. 						"beginTime": null,
    470. 						"finishTime": null,
    471. 						"reportTime": null,
    472. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    473. 					},
    474. 					{
    475. 						"startTime": "2022-11-05 09:21:16",
    476. 						"endTime": "2022-11-05 09:28:55",
    477. 						"eventLevel": "预警",
    478. 						"eventType": null,
    479. 						"mmsi": 413996871,
    480. 						"name": "未知",
    481. 						"nearestCable": null,
    482. 						"alarmDescription": null,
    483. 						"sog": null,
    484. 						"cog": null,
    485. 						"minDistance": null,
    486. 						"lon": null,
    487. 						"lat": null,
    488. 						"alarmTime": "2022-11-05 09:21:46",
    489. 						"beginTime": null,
    490. 						"finishTime": null,
    491. 						"reportTime": null,
    492. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    493. 					},
    494. 					{
    495. 						"startTime": "2022-11-05 09:21:16",
    496. 						"endTime": "2022-11-05 09:28:55",
    497. 						"eventLevel": "预警",
    498. 						"eventType": null,
    499. 						"mmsi": 413996871,
    500. 						"name": "未知",
    501. 						"nearestCable": null,
    502. 						"alarmDescription": null,
    503. 						"sog": null,
    504. 						"cog": null,
    505. 						"minDistance": null,
    506. 						"lon": null,
    507. 						"lat": null,
    508. 						"alarmTime": "2022-11-05 09:22:53",
    509. 						"beginTime": null,
    510. 						"finishTime": null,
    511. 						"reportTime": null,
    512. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    513. 					},
    514. 					{
    515. 						"startTime": "2022-11-05 09:21:16",
    516. 						"endTime": "2022-11-05 09:28:55",
    517. 						"eventLevel": "预警",
    518. 						"eventType": null,
    519. 						"mmsi": 413996871,
    520. 						"name": "未知",
    521. 						"nearestCable": null,
    522. 						"alarmDescription": null,
    523. 						"sog": null,
    524. 						"cog": null,
    525. 						"minDistance": null,
    526. 						"lon": null,
    527. 						"lat": null,
    528. 						"alarmTime": "2022-11-05 09:27:52",
    529. 						"beginTime": null,
    530. 						"finishTime": null,
    531. 						"reportTime": null,
    532. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    533. 					},
    534. 					{
    535. 						"startTime": "2022-11-05 09:21:16",
    536. 						"endTime": "2022-11-05 09:28:55",
    537. 						"eventLevel": "预警",
    538. 						"eventType": null,
    539. 						"mmsi": 413996871,
    540. 						"name": "未知",
    541. 						"nearestCable": null,
    542. 						"alarmDescription": null,
    543. 						"sog": null,
    544. 						"cog": null,
    545. 						"minDistance": null,
    546. 						"lon": null,
    547. 						"lat": null,
    548. 						"alarmTime": "2022-11-05 09:22:18",
    549. 						"beginTime": null,
    550. 						"finishTime": null,
    551. 						"reportTime": null,
    552. 						"groupByStr": "413996871_2022-11-05 09:21:16_2022-11-05 09:28:55_预警_未知"
    553. 					}
    554. 				]
    555. 			},
    556. 			{
    557. 				"mmsi": 413842719,
    558. 				"name": "WANTIANYU1689",
    559. 				"startTime": "2022-11-05 11:18:48",
    560. 				"endTime": "2022-11-05 11:18:48",
    561. 				"eventLevel": "预警",
    562. 				"details": [
    563. 					{
    564. 						"startTime": "2022-11-05 11:18:48",
    565. 						"endTime": "2022-11-05 11:18:48",
    566. 						"eventLevel": "预警",
    567. 						"eventType": null,
    568. 						"mmsi": 413842719,
    569. 						"name": "WANTIANYU1689",
    570. 						"nearestCable": null,
    571. 						"alarmDescription": null,
    572. 						"sog": null,
    573. 						"cog": null,
    574. 						"minDistance": null,
    575. 						"lon": null,
    576. 						"lat": null,
    577. 						"alarmTime": "2022-11-05 11:18:48",
    578. 						"beginTime": null,
    579. 						"finishTime": null,
    580. 						"reportTime": null,
    581. 						"groupByStr": "413842719_2022-11-05 11:18:48_2022-11-05 11:18:48_预警_WANTIANYU1689"
    582. 					},
    583. 					{
    584. 						"startTime": "2022-11-05 11:18:48",
    585. 						"endTime": "2022-11-05 11:18:48",
    586. 						"eventLevel": "预警",
    587. 						"eventType": null,
    588. 						"mmsi": 413842719,
    589. 						"name": "WANTIANYU1689",
    590. 						"nearestCable": null,
    591. 						"alarmDescription": null,
    592. 						"sog": null,
    593. 						"cog": null,
    594. 						"minDistance": null,
    595. 						"lon": null,
    596. 						"lat": null,
    597. 						"alarmTime": "2022-11-05 11:18:48",
    598. 						"beginTime": null,
    599. 						"finishTime": null,
    600. 						"reportTime": null,
    601. 						"groupByStr": "413842719_2022-11-05 11:18:48_2022-11-05 11:18:48_预警_WANTIANYU1689"
    602. 					}
    603. 				]
    604. 			}
    605. 		];
    606.  
    607. 		// 数据整理
    608. 		let serveTransData = [];
    609. 		let merges = []; //合并规律
    610. 		let cow = 5; // 前五列合并
    611. 		let startRow = 0;
    612. 		let endRow = 0;
    613. 		serveData.forEach(({ details = [] }) => {
    614. 			const mapData = details.map(item => {
    615. 				let tempData = {}
    616. 				serveHead.forEach(v => {
    617. 					const [code, name] = Object.entries(v)[0];
    618. 					tempData[name] = item[code];
    619. 				});
    620. 				return tempData;
    621. 			});
    622. 			serveTransData.push(...mapData);
    623. 			endRow += details.length;
    624. 			for (let i = 0; i < cow; i++) {
    625. 				merges.push({
    626. 					// c => 列  r => 行 
    627. 					s: { c: i, r: startRow + 1 }, e: { c: i, r: endRow }
    628. 				})
    629. 			};
    630. 			startRow = endRow;
    631. 		});
    632.  
    633. 		function doit(type) {
    634.  
    635. 			var sheetName = 'Sheet1';
    636. 			var wb = {
    637. 				SheetNames: [sheetName],
    638. 				Sheets: {},
    639. 				Props: {}
    640. 			};
    641. 			var data = XLSX.utils.json_to_sheet(serveTransData);
    642.  
    643. 			wb.Sheets[sheetName] = data;
    644.  
    645. 			XSU.mergeCellsByObj(wb, sheetName, merges); 	// merges单元合并规则
    646. 			XSU.setAlignmentHorizontalAll(wb, sheetName, 'center');//垂直居中
    647. 			XSU.setAlignmentVerticalAll(wb, sheetName, 'center');//水平居中
    648. 			XSU.setFontBoldOfRows(wb, sheetName, true, '1');//设置第二行标题行加粗
    649.  
    650. 			//列宽设置 1wch为1英文字符宽度
    651. 			var width = new Array(serveHead.length).fill({ wch: 20 });
    652. 			XSU.setColWidth(wb, sheetName, width);
    653.  
    654. 			//转换成二进制 使用xlsx-style（XS）进行转换才能得到带样式Excel
    655. 			var wBout = xlsxStyle.write(wb, { bookType: 'xlsx', bookSST: false, type: 'binary' });
    656. 			saveAs(new Blob([XSU.s2ab(wBout)]), "test.xlsx");
    657.  
    658. 		}
    659. 	script>
    660. 	<input type="submit" value="Export!" onclick="doit();">
    661. body>
    662.  
    663. html>

    合并规则      

          data["!merges"] = [

          //   // c => 列

          //   // r => 行

          //   纵向合并，范围是第1列的行1到行2

          //   { s: { c: 1, r: 1 }, e: { c: 1, r: 2 } }, // 纵向合并，范围是第2列的行1到行2

          //   { s: { c: 2, r: 1 }, e: { c: 2, r: 2 } }, // 纵向合并，范围是第3列的行1到行2

          //   { s: { c: 3, r: 1 }, e: { c: 3, r: 2 } }, // 纵向合并，范围是第4列的行1到行2

          //   { s: { c: 4, r: 1 }, e: { c: 4, r: 2 } }, // 纵向合并，范围是第5列的行1到行2

          //   // 第二组

          //   { s: { c: 0, r: 3 }, e: { c: 0, r: 4 } }, // 纵向合并，范围是第1列的行3到行4

          //   { s: { c: 1, r: 3 }, e: { c: 1, r: 4 } }, // 纵向合并，范围是第2列的行3到行4

          //   { s: { c: 2, r: 3 }, e: { c: 2, r: 4 } }, // 纵向合并，范围是第3列的行3到行4

          //   { s: { c: 3, r: 3 }, e: { c: 3, r: 4 } }, // 纵向合并，范围是第4列的行3到行4

          //   { s: { c: 4, r: 3 }, e: { c: 4, r: 4 } }, // 纵向合并，范围是第5列的行3到行4

          // ];

    文档地址： GitHub - Ctrl-Ling/XLSX-Style-Utils: 基于SheetJS以及XLSX-Style的纯前端带样式导出表格为Excel的工具包

  • 相关阅读:
    彻底解决 IDC Incast
    TP4586双路独立控制的 TWS 充电仓解决方案
    [论文阅读] 颜色迁移-Correlated Color Space
    怎么裁剪视频时长？建议收藏这些方法
    性能测试 —— Jmeter 常用三种定时器！
    2022-09-28 C++并发编程（二十七）
    Android性能优化方法论
    10种靠谱又收益不错的在家就可以做的网赚兼职平台介绍
    Android 使用 GeckoView 并实现 js 交互、权限交互
    分析智能平台VMware Greenplum 7 正式发布！
  • 原文地址：https://blog.csdn.net/qq_25919495/article/details/127744742