上传Excel表格到后台报java.lang.IllegalStateException: Cannot get a text value from a numeric cell

最新推荐文章于 2023-05-03 16:43:40 发布
最新推荐文章于 2023-05-03 16:43:40 发布
阅读量910 收藏 1
点赞数 1
分类专栏： PIO 文章标签： poi java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Zero_uou/article/details/90668667
版权 
java.lang.IllegalStateException: Cannot get a text value from a numeric cell
	at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:643)
	at org.apache.poi.hssf.usermodel.HSSFCell.getRichStringCellValue(HSSFCell.java:720)
	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:703)
	at com.yuenyat.storage.controller.business.ReportFormController.export(ReportFormController.java:133)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.yuenyat.storage.security.support.MyFilterSecurityInterceptor.invoke(MyFilterSecurityInterceptor.java:75)
	at com.yuenyat.storage.security.support.MyFilterSecurityInterceptor.doFilter(MyFilterSecurityInterceptor.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at com.yuenyat.storage.security.support.MyFilterSecurityInterceptor.invoke(MyFilterSecurityInterceptor.java:75)
	at com.yuenyat.storage.security.support.MyFilterSecurityInterceptor.doFilter(MyFilterSecurityInterceptor.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
	@PostMapping(value = "/getImportDistrictList")
	@ResponseBody
	public String export(
			@RequestParam("file") MultipartFile file,
			HttpServletRequest request, HttpServletResponse response) {
		try {
			// @RequestParam("file") MultipartFile file 是用来接收前端传递过来的文件
			// 1.创建workbook对象，读取整个文档
			InputStream inputStream = file.getInputStream();
			//2013版及之前的
			POIFSFileSystem poifsFileSystem = new POIFSFileSystem(inputStream);
			HSSFWorkbook wb = new HSSFWorkbook(poifsFileSystem);
			// 2.读取页脚sheet
			HSSFSheet sheetAt = wb.getSheetAt(0);
			// 3.循环读取某一行
			for (Row row : sheetAt) {
				// 4.读取每一行的单元格
				String stringCellValue = row.getCell(0).getStringCellValue(); // 第一列数据
				String stringCellValue2 = row.getCell(1).getStringCellValue();// 第二列
				// 写多少个具体看大家上传的文件有多少列.....
				// 测试是否读取到数据,及数据的正确性
				logger.info(stringCellValue);
			}
			return "01";
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return "02";
		}
 
	}

原因很简单，我第二列是数字，而代码上我却用了String类型接收，

将String stringCellValue2 = row.getCell(1).getStringCellValue();// 第二列

改为这double doubleCellValue2 = row.getCell(1).getNumericCellValue();// 第二列

问题就解决了

keli_Jun
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
java.lang.IllegalStateException: Cannot get a text value from a numeric cell
123
05-04 1877
java.lang.IllegalStateException: Cannot get a text value from a numeric cell**异常信息****异常原因****解决方法** 异常信息 java.lang.IllegalStateException: Cannot get a text value from a numeric cell 异常原因 Excel数据Cell...
java：poi：java.lang.IllegalStateException: Cannot get a text value from a numeric cell
不花的花和尚的博客
04-27 523
java.lang.IllegalStateException: Cannot get a text value from a numeric cell at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:640) at org.apache.poi.hssf.usermodel.HSSFCell.getR...
Java异常之—-Caused by: java.lang.IllegalStateException: Method has too many Body parameters
01-20
异常：Caused by: java.lang.IllegalStateException: Method has too many Body parameters Caused by: java.lang.IllegalStateException: Method has too many Body parameters: public abstract ...
java.lang.IllegalStateException: Cannot call sendError() after the response has
04-21
在Java的Web开发中，`java.lang.IllegalStateException: Cannot call sendError() after the response has been committed` 是一个常见的错误，通常发生在尝试在HTTP响应已经发送到客户端之后调用`sendError()`方法...
Android异常 java.lang.IllegalStateException解决方法
09-01
在Android开发过程中，Java异常`java.lang.IllegalStateException`是一个常见的错误类型，它通常表示程序在不合法或者不合适的状态下尝试执行某项操作。在上述描述中提到了两种特定的`IllegalStateException`情况： ...
java.lang.IllegalStateException: getOutputStream() has already解决办法
09-17
纠结了半天的 java.lang.IllegalStateException: getOutputStream() has already。这个问题困扰了半天,在网上查阅了大量资料 出这个错误一般就是下面2个.....
Exception in thread "main" java.lang.IllegalStateException: Cannot get a text value from a numeric c
yvoncf的博客
08-16 4859
错误代码： System.out.println((String)cell.getStringCellValue()); Excel数据Cell有不同的类型，当我们试图从一个数字类型的Cell读取出一个字符串需要设置类型 问题： Exception in thread "main" java.lang.IllegalStateException: Cannot ge
处理java.lang.IllegalStateException: Cannot get a text value from a numeric cell
weixin_44988848的博客
07-14 1318
今天导入一个excel文件，读取内容时报出了java.lang.IllegalStateException: Cannot get a text value from a numeric cell的异常。 看了网上一些资料明白，这是因为cell的内容中有数字类型，但程序中对其进行操作比如 row.getCell(j).getStringCellValue()时无法自动转换类型，所以这里我整理了以下两种方法： 1、在excel文件中有数字的单元格前面加上 ‘ ，这个大家应该明白什么意思 2、在程序中进
正确处理java.lang.IllegalStateException: Cannot get a text value from a numeric cell
weixin_48424384的博客
10-25 2070
java.lang.IllegalStateException: Cannot get a text value from a numeric cell 我们在使用ApacePOI解析ExceL文件中的数据时，经常会在数据类型读取上报错，原因是我们没有将读取的row.getCell(j)中的数据类型转换成String类型。我们在String cellValue = row.getCell(j).getStringCellValue();前加上一行转换数据类型代码 row.ge
java.lang.IllegalStateException: Cannot get a text value from a numeric cell 解决办法
Mr. Xu的博客
11-27 825
Excel数据Cell有不同的类型,当我们试图从一个数字类型的Cell(表格中)读取出一个字符串时,就会出现Cannot get a text value from a numeric cell的异常错误 解决办法： 我们在表中带数字的单元格内加上 ` 就行了 ...
Cannot get a text value from a numeric cell
程序源的博客
12-31 991
通过poi来读取excel文件过程中，通过cell.getStringCellValue()方法尝试从一个数字类型的Cell读取出一个字符串时报错。 报错: Exception in thread "main" java.lang.IllegalStateException: Cannot get a text value from a numeric cell at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSS...
java.lang.IllegalStateException:Cannot get a STRING value from a NUMERIC cell（java导入excel报表）
weixin_58419099的博客
05-03 3033
java.lang.IllegalStateException:Cannot get a STRING value from a NUMERIC cell（java导入excel报表）
JAVA-Apache-POI-java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
hehyyoulan的博客
05-16 323
版权声明：本文为博主原创文章，转载注明地址：http://blog.csdn.net/wang704987562 https://blog.csdn.net/wang704987562/article/details/81837750 ...
getStringCellValue方法异常 java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
最新发布
11-22
该异常通常在使用POI库中的getStringCellValue()方法时出现，因为该方法只能用于获取单元格中的字符串类型值，如果单元格中的值不是字符串类型，就会抛出该异常。例如，如果单元格中的值是数字类型，而你使用getStringCellValue()方法来获取该单元格的值，就会抛出java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell异常。 解决该异常的方法是，首先使用getCellType()方法来获取单元格的类型，然后根据单元格的类型来选择使用相应的方法来获取单元格的值。例如，如果单元格的类型是数字类型，就可以使用getNumericCellValue()方法来获取该单元格的值。 以下是一个使用POI库来获取单元格值的例子： ```java // 创建工作簿对象 Workbook workbook = new XSSFWorkbook(new FileInputStream("example.xlsx")); // 获取第一个工作表 Sheet sheet = workbook.getSheetAt(0); // 获取第二行第三列的单元格 Cell cell = sheet.getRow(1).getCell(2); // 判断单元格的类型 if (cell.getCellType() == CellType.STRING) { // 如果单元格的类型是字符串类型，就使用getStringCellValue()方法来获取单元格的值 String value = cell.getStringCellValue(); System.out.println("单元格的值是：" + value); } else if (cell.getCellType() == CellType.NUMERIC) { // 如果单元格的类型是数字类型，就使用getNumericCellValue()方法来获取单元格的值 double value = cell.getNumericCellValue(); System.out.println("单元格的值是：" + value); } ```
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值