168. Excel表列名称（JS实现）

最新推荐文章于 2022-06-10 17:25:36 发布
原创 最新推荐文章于 2022-06-10 17:25:36 发布 · 753 阅读 · 2 ·
CC 4.0 BY-SA版权
本文为博主原创文章，转载请务必附上文章网址，谢谢。

1 题目

给定一个正整数，返回它在 Excel 表中相对应的列名称。
例如，
1 -> A
2 -> B
3 -> C
…
26 -> Z
27 -> AA
28 -> AB
…
示例 1:
输入: 1
输出: “A”
示例 2:
输入: 28
输出: “AB”
示例 3:
输入: 701
输出: “ZY”

链接：https://leetcode-cn.com/problems/excel-sheet-column-title

2 思路

这道题看起来挺简单，但实际做的时候要好好考虑一下索引的对应关系，例如数字1对应字符数组的索引0, 数字28对应索引01

3代码

/**
 * @param {number} n
 * @return {string}
 */
var convertToTitle = function(n)
最低0.47元/天 解锁文章
JavaScript语言实现，数字转Excel列名
weixin_46557501的博客
03-27 893
研发场景/应用场景 使用SpreadJS表单控件，前端生成Excel文件，并实现图表、打印、导出等功能。其中，生成图表的函数需要传入的参数之一，是excel文件中图表数据源对应的单元格区域，类似“A1:AF132”。然而，图表数据源的列数不固定，这就需要根据数字（后端返回的数组长度）获取列名称。 解决方案 function numberTransColName( number ){ var ordA = 'A'.charCodeAt(0); var ordZ = 'Z'.charCodeAt(0);
168. Excel表列名称(2021.06.09)
多啦的博客
06-09 210
168. Excel表列名称 链接：https://leetcode-cn.com/problems/excel-sheet-column-title/ 题目描述见链接内容。 解法1：减一法 这道题实质上就是进制转换的题目，将十进制转换为26进制，但是特别之处在，如果按照26进制转换，余数是0-25，而现在的转换余数是1-26，对应A-Z，现在需要消除这两个之间的差异 解法1就是把被除数减一 首先找到字符转换的基准，String.fromCharCode(65)，对应字母A 这个时候，如果n等于1，对2
168. Excel表列名称 （JavaScript）
是阿春呀的博客
06-29 377
Excel表列名称 给你一个整数 columnNumber ，返回它在 Excel 表中相对应的列名称。 例如： A -> 1 B -> 2 C -> 3 … Z -> 26 AA -> 27 AB -> 28 … 示例 1： 输入：columnNumber = 1 输出：“A” 示例 2： 输入：columnNumber = 28 输出：“AB” 示例 3： 输入：columnNumber = 701 输出：“ZY” 示例 4： 输入：columnNumber ..
leetcode(js) 168. Excel表列名称
浮生匆忙，与君同往
06-19 425
Excel表列名称 给定一个正整数，返回它在 Excel 表中相对应的列名称。 例如， 1 -> A 2 -> B 3 -> C ... 26 -> Z 27 -> AA 28 -> AB ... 示例 1: 输入: 1 输出: “A” 示例 2: 输入: 28 输出: “AB” 示例 3: 输入: 701 输出: “ZY” 通过次数27,983提交次数73,869 解题思路：按照二进制的转换思想转换这里的26进制，但是由于这里是从1开始的，而不是从0开始的，所以.
[leetcode]Excel表列名称[javascript]
迷途之家
12-22 309
https://leetcode-cn.com/problems/excel-sheet-column-title/ 描述 给定一个正整数，返回它在 Excel 表中相对应的列名称。 例如， 1 -> A 2 -> B 3 -> C ... 26 -> Z 27 -> AA 28 -> AB .....
168. Excel表列名称（javascript）168. Excel Sheet Column Title
ingenuou_的博客
02-24 586
168. Excel表列名称（javascript）
js-leetcode题解之168-excel-sheet-column-title.js
11-07
在JavaScript中解决LeetCode的第168题——Excel表列名称，是一个与数学和字符串操作相关的编程问题。这个问题要求我们把一个正整数转换成一个Excel列的标题，这种标题是用字母来表示的。例如，数字1对应字母"A"，...
前端常用的【文件下载操作2】不获取后端文件流 【纯前端】实现：el-table表格下载为Excel文件【sheetJS XLSX】
Sabrina_cc的博客
06-10 1419
之前的一篇文章中已经使用过sheet JS，本文章将再次使用这个插件
Django 使用xlwt实现从后台mysql导出数据到excel表
心如海的博客
08-01 1936
1. pip install xlwt   #安装xlwt 模块 2. 新建excel.py import xlwt #from io import StringIO from django.db import connection from django.shortcuts import HttpResponse try: import cStringIO as stringIOM...
leetcode]Excel表列名称[javascript]
包磊磊的博客
10-23 407
给定一个正整数，返回它在 Excel 表中相对应的列名称。 例如， 1 -> A 2 -> B 3 -> C ... 26 -> Z 27 -> AA 28 -> AB ... /** * @param {number} n * @return {string} */ ...
[leetcode]Excel表列序号[javascript]
迷途之家
12-22 446
https://leetcode-cn.com/problems/excel-sheet-column-number/ 描述 给定一个Excel表格中的列名称，返回其相应的列序号。 例如， A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ......
【JavaScript】自然数转Excel列名
wosperry的博客
04-19 352
indexToExcelColumn = (index)=>{ // 自然数 if (typeof index !== 'number') return false; if (Number.isNaN( index )) return false; if ( (1 / index) < 0 ) return false; if (index < 0) return false; // 调整为正确的数值 var arr26 = in...
JS 数字转换为EXCEL字母列
weixin_42349358的博客
05-30 2320
/** * Convert from numeric position to letter for column names in Excel * @param {int} n Column number * @return {string} Column letter(s) name */ function createCellPos( n ){ var ordA = '...
【jqgrid】 js实现动态列名
Programmer_mixia的博客
10-25 3670
js实现代码： jQuery(function(){ var JdxsGrid = Class.create(BaseJqGrid,{   caption : "学生列表", pager: "pager", //分页工具栏   postData:{id:jQuery("#id").val(),jddm:jQuery("#jddm").val()},         url:_pat
JS实现EXCEL列名和坐标转换
qq_30059235的博客
01-12 905
方法来源JExcel框架 /** * 根据坐标获取列名 * @param {Object} cellId */ function getColumnNameFromId(cellId){ if (! Array.isArray(cellId)) { cellId = cellId.split('-'); } var i = cellId[0]; var letter = ''; if (i > 701) { letter += String.fromCharCode(64
javaScript将页面的表格导成EXCEL(按单元格)
iteye_18326的博客
03-07 194
JS部份： //自定定义一个用于记录导出信息的对像 function TableToExcel(tableID) { this.tableBorder = -1; //边框类型，-1没有边框 可取1/2/3/4 this.backGround = 0; //背景颜色：白色 可取调色板中的颜色编号 1/2/3/4.... this.fontColor = 1; //字体颜...
查询Excel表格中的某一列数据【Node.js实现】
Coder Ben's Writing
08-24 3119
const fs = require('fs') const xlsx = require('node-xlsx') const sheets = xlsx.parse('example.xlsx') sheets.forEach(sheet =&gt; { // 获取整个excel中的数据 const data = sheet['data'] // 将需要的列数...
数字转换成excel列名（10进制到Excel的26进制的转换函数）
weixin_34008805的博客
10-12 231
/// <summary> /// 10进制到Excel的26进制的转换函数 /// </summary> /// <param name="i"></param> ...
将excel表的数据导入
蓝枫秋千的踩坑记录
12-17 547
import React from 'react' import XLSX from 'xlsx' class List extends React.Component { onImportExcel = file => { // 获取上传的文件对象 const { files } = file.target; // 通过FileRe...
导出的数据是空的,但实际上已经查到数据了 2025-10-10 16:23:48.273 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] New http connection, requesting read 2025-10-10 16:23:48.273 [reactor-http-nio-2] DEBUG reactor.netty.transport.TransportConfig - [7aa6b257, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Initialized pipeline DefaultChannelPipeline{(reactor.left.httpCodec = io.netty.handler.codec.http.HttpServerCodec), (reactor.left.httpTrafficHandler = reactor.netty.http.server.HttpTrafficHandler), (reactor.right.reactiveBridge = reactor.netty.channel.ChannelOperationsHandler)} 2025-10-10 16:23:48.323 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Increasing pending responses, now 1 2025-10-10 16:23:48.400 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServer - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Handler is being applied: org.springframework.http.server.reactive.ReactorHttpHandlerAdapter@707ef05f 2025-10-10 16:23:48.519 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [7aa6b257-1] HTTP POST "/master/inventory/export/excel" 2025-10-10 16:23:48.574 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerMapping - [7aa6b257-1] Mapped to com.hvlink.controller.InventoryController#exportInventory(InventoryParam, ServerHttpResponse) 2025-10-10 16:23:48.623 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [7aa6b257-1] Content-Type:application/json 2025-10-10 16:23:48.639 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [7aa6b257-1] 0..1 [com.hvlink.entity.param.master.InventoryParam] 2025-10-10 16:23:48.718 [reactor-http-nio-2] DEBUG reactor.netty.channel.FluxReceive - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] [terminated=false, cancelled=false, pending=0, error=null]: subscribing inbound receiver 2025-10-10 16:23:48.811 [reactor-http-nio-2] DEBUG o.s.http.codec.json.Jackson2JsonDecoder - [7aa6b257-1] Decoded [InventoryParam(id=null, companyCode=null, supplierCode=null, supplierName=null, factoryCode=null, fa (truncated)...] 2025-10-10 16:23:48.851 [reactor-http-nio-2] DEBUG com.hvlink.aspect.DataSourceAspect - 切换数据源：SALVE 2025-10-10 16:23:48.989 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:23:49.038 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44ec7e32] was not registered for synchronization because synchronization is not active 2025-10-10 16:23:49.234 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:23:49.234 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:23:49.251 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.InventoryMapper.selectList - ==> Preparing: SELECT id,company_code,supplier_code,factory_code,warehouse_code,part_code,part_desc,supplier_part_code,unit,special_flag,batch_no,no_limit_quantity,quality_quantity,freeze_quantity,is_deleted,create_by,create_time,update_by,update_time FROM tb_inventory WHERE (id IN (?,?,?,?,?) AND is_deleted = ?) 2025-10-10 16:23:49.439 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.InventoryMapper.selectList - ==> Parameters: 2093(Integer), 2094(Integer), 2095(Integer), 2096(Integer), 2097(Integer), 0(Integer) 2025-10-10 16:23:49.606 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.InventoryMapper.selectList - <== Total: 5 2025-10-10 16:23:49.606 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44ec7e32] 2025-10-10 16:23:49.611 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:23:49.611 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a7d4d53] was not registered for synchronization because synchronization is not active 2025-10-10 16:23:49.611 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:23:49.611 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:23:49.611 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.SupplierMapper.selectList - ==> Preparing: SELECT id,company_code,supplier_code,supplier_name,supplier_tel,remark,is_deleted,create_by,create_time,update_by,update_time FROM tm_supplier WHERE (supplier_code IN (?,?)) 2025-10-10 16:23:49.611 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.SupplierMapper.selectList - ==> Parameters: 0012000049(String), 0012000048(String) 2025-10-10 16:23:49.634 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.SupplierMapper.selectList - <== Total: 18 2025-10-10 16:23:49.634 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a7d4d53] 2025-10-10 16:23:49.634 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:23:49.634 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3a66747d] was not registered for synchronization because synchronization is not active 2025-10-10 16:23:49.637 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:23:49.637 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:23:49.637 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.FactoryMapper.selectList - ==> Preparing: SELECT id,company_code,factory_code,factory_name,status,is_deleted,create_by,create_time,update_by,update_time FROM tm_factory WHERE (factory_code IN (?)) 2025-10-10 16:23:49.637 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.FactoryMapper.selectList - ==> Parameters: 1400(String) 2025-10-10 16:23:49.648 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.FactoryMapper.selectList - <== Total: 0 2025-10-10 16:23:49.648 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3a66747d] 2025-10-10 16:23:49.650 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:23:49.651 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@a1edc43] was not registered for synchronization because synchronization is not active 2025-10-10 16:23:49.653 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:23:49.653 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:23:49.653 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.PackageMapper.selectList - ==> Preparing: SELECT id,company_code,factory_code,part_code,unit,standard_package,box_quantity,package_quantity,drag_quantity,max_inventory_level,safety_inventory,is_deleted,create_by,create_time,update_by,update_time FROM tm_package WHERE (factory_code IN (?) AND part_code IN (?,?,?,?,?)) 2025-10-10 16:23:49.653 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.PackageMapper.selectList - ==> Parameters: 1400(String), S00020153101(String), S00020145101(String), S00020155101(String), S00020151101(String), S00020094101(String) 2025-10-10 16:23:49.705 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.PackageMapper.selectList - <== Total: 5 2025-10-10 16:23:49.705 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@a1edc43] 2025-10-10 16:23:53.080 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [7aa6b257-1] Completed 200 OK 2025-10-10 16:23:53.115 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Last HTTP response frame 2025-10-10 16:23:53.115 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] No sendHeaders() called before complete, sending zero-length header 2025-10-10 16:23:53.121 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Decreasing pending responses, now 0 2025-10-10 16:23:53.121 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Last HTTP packet was sent, terminating the channel 2025-10-10 16:23:53.121 [reactor-http-nio-2] DEBUG reactor.netty.channel.ChannelOperations - [7aa6b257-1, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] [HttpServer] Channel inbound receiver cancelled (subscription disposed). 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Increasing pending responses, now 1 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServer - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Handler is being applied: org.springframework.http.server.reactive.ReactorHttpHandlerAdapter@707ef05f 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [7aa6b257-2] HTTP POST "/master/inventory/export/excel" 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerMapping - [7aa6b257-2] Mapped to com.hvlink.controller.InventoryController#exportInventory(InventoryParam, ServerHttpResponse) 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [7aa6b257-2] Content-Type:application/json 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [7aa6b257-2] 0..1 [com.hvlink.entity.param.master.InventoryParam] 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG reactor.netty.channel.FluxReceive - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] [terminated=false, cancelled=false, pending=0, error=null]: subscribing inbound receiver 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG o.s.http.codec.json.Jackson2JsonDecoder - [7aa6b257-2] Decoded [InventoryParam(id=null, companyCode=null, supplierCode=null, supplierName=null, factoryCode=null, fa (truncated)...] 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG com.hvlink.aspect.DataSourceAspect - 切换数据源：SALVE 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:24:02.887 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@35a2dbe5] was not registered for synchronization because synchronization is not active 2025-10-10 16:24:02.893 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:24:02.893 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:24:02.893 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.InventoryMapper.selectList - ==> Preparing: SELECT id,company_code,supplier_code,factory_code,warehouse_code,part_code,part_desc,supplier_part_code,unit,special_flag,batch_no,no_limit_quantity,quality_quantity,freeze_quantity,is_deleted,create_by,create_time,update_by,update_time FROM tb_inventory WHERE (id IN (?,?,?,?,?) AND is_deleted = ?) 2025-10-10 16:24:02.893 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.InventoryMapper.selectList - ==> Parameters: 2093(Integer), 2094(Integer), 2095(Integer), 2096(Integer), 2097(Integer), 0(Integer) 2025-10-10 16:24:02.903 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.InventoryMapper.selectList - <== Total: 5 2025-10-10 16:24:02.903 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@35a2dbe5] 2025-10-10 16:24:02.903 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:24:02.903 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b7f3c15] was not registered for synchronization because synchronization is not active 2025-10-10 16:24:02.909 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:24:02.909 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:24:02.909 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.SupplierMapper.selectList - ==> Preparing: SELECT id,company_code,supplier_code,supplier_name,supplier_tel,remark,is_deleted,create_by,create_time,update_by,update_time FROM tm_supplier WHERE (supplier_code IN (?,?)) 2025-10-10 16:24:02.909 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.SupplierMapper.selectList - ==> Parameters: 0012000049(String), 0012000048(String) 2025-10-10 16:24:02.926 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.SupplierMapper.selectList - <== Total: 18 2025-10-10 16:24:02.926 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b7f3c15] 2025-10-10 16:24:02.926 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:24:02.927 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17572d02] was not registered for synchronization because synchronization is not active 2025-10-10 16:24:02.931 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:24:02.931 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:24:02.931 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.FactoryMapper.selectList - ==> Preparing: SELECT id,company_code,factory_code,factory_name,status,is_deleted,create_by,create_time,update_by,update_time FROM tm_factory WHERE (factory_code IN (?)) 2025-10-10 16:24:02.931 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.FactoryMapper.selectList - ==> Parameters: 1400(String) 2025-10-10 16:24:02.944 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.FactoryMapper.selectList - <== Total: 0 2025-10-10 16:24:02.944 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17572d02] 2025-10-10 16:24:02.944 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-10-10 16:24:02.944 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@68ce4b4e] was not registered for synchronization because synchronization is not active 2025-10-10 16:24:02.946 [reactor-http-nio-2] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-10-10 16:24:02.946 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 592081aa-c2b5-4801-aaf5-a770a35e87cc] will not be managed by Spring 2025-10-10 16:24:02.946 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.PackageMapper.selectList - ==> Preparing: SELECT id,company_code,factory_code,part_code,unit,standard_package,box_quantity,package_quantity,drag_quantity,max_inventory_level,safety_inventory,is_deleted,create_by,create_time,update_by,update_time FROM tm_package WHERE (factory_code IN (?) AND part_code IN (?,?,?,?,?)) 2025-10-10 16:24:02.946 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.PackageMapper.selectList - ==> Parameters: 1400(String), S00020153101(String), S00020145101(String), S00020155101(String), S00020151101(String), S00020094101(String) 2025-10-10 16:24:03.001 [reactor-http-nio-2] DEBUG com.hvlink.mapper.master.PackageMapper.selectList - <== Total: 5 2025-10-10 16:24:03.003 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@68ce4b4e] 2025-10-10 16:24:03.068 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [7aa6b257-2] Completed 200 OK 2025-10-10 16:24:03.070 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Last HTTP response frame 2025-10-10 16:24:03.070 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] No sendHeaders() called before complete, sending zero-length header 2025-10-10 16:24:03.070 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Decreasing pending responses, now 0 2025-10-10 16:24:03.070 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] Last HTTP packet was sent, terminating the channel 2025-10-10 16:24:03.070 [reactor-http-nio-2] DEBUG reactor.netty.channel.ChannelOperations - [7aa6b257-2, L:/192.168.10.130:9000 - R:/192.168.10.130:57143] [HttpServer] Channel inbound receiver cancelled (subscription disposed).
最新发布
10-11
从你提供的日志来看，系统确实已经查到了数据（例如 `InventoryMapper.selectList` 返回了 5 条记录，`SupplierMapper.selectList` 返回了 18 条），但最终导出的 Excel 文件却是空的。这说明：**数据查询是成功的，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值