为excel最后一列加个end

最新推荐文章于 2024-06-17 08:56:22 发布

dyclh

最新推荐文章于 2024-06-17 08:56:22 发布

阅读量143

点赞数

分类专栏： java 文章标签： Excel CSS Cache HTML JSP

本文链接：https://blog.csdn.net/dyclh/article/details/83649055

版权

java 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

<%@ page language="java" pageEncoding="GBK"%>
<%@ page import="java.io.*" %>
<%@ page import="jxl.*" %>
<%@ page import="java.util.*" %>
<%@ page import="jxl.write.*" %>


<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
	<base href="<%=basePath%>">

	<title>蔡头检查excel格式</title>
	
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>
  
<body><center>


<br><br>
请告诉我的EXCEL文件名<br><br>
<form name="checkform" action="checkExcel2.jsp" method="post">
	<input type="text" name="filepath1" style="width:300px"><br><br>
	<input type="text" name="filepath2" style="width:300px"><br><br>
	<input type="text" name="filepath3" style="width:300px"><br><br>
	<input type="text" name="filepath4" style="width:300px"><br><br>
	<input type="text" name="filepath5" style="width:300px"><br><br>
	<input type="text" name="filepath6" style="width:300px"><br><br>
	<input type="text" name="filepath7" style="width:300px"><br><br>
	<input type="text" name="filepath8" style="width:300px"><br><br>
	<input type="text" name="filepath9" style="width:300px"><br><br>
	<input type="submit"  value="提交">
	</form>
	
	</center>
</body>
</html>


<%@ page language="java" pageEncoding="GBK"%>
<%@ page import="java.io.*" %>
<%@ page import="jxl.*" %>
<%@ page import="java.util.*" %>
<%@ page import="jxl.write.*" %>


<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
	<base href="<%=basePath%>">

	<title>蔡头检查excel格式</title>
	
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>
  
<body><center>


<%

 try{
     
		
		String fpath="filepath";
		for(int i=1;i<9;i++)
		{
				String aaaaa=fpath+i;
				String newname=(String)request.getParameter(aaaaa);
				if(newname!=null|newname!=""){
				
						//创建只读的Excel工作薄的对象
				    jxl.Workbook rw = jxl.Workbook.getWorkbook(new File(newname));
				    Sheet rs = rw.getSheet(0);
				    
				//    创建可写入的Excel工作薄对象
				    jxl.write.WritableWorkbook  wwb = Workbook.createWorkbook(new File(newname), rw);
				                
				//    读取第一张工作表
				    jxl.write.WritableSheet ws = wwb.getSheet(0);
				//    获得第一个单元格对象
				    int num=ws.getRows();
				    System.out.println(num);
				    int aaa=num-1;
				    System.out.println(rs.getCell(0,aaa).getContents() );
				    System.out.println("".equals(rs.getCell(0,aaa).getContents().trim()));
				    
				    if("".equals(rs.getCell(0,aaa).getContents().trim())){
				    	jxl.write.Label end = new Label(0, aaa,"end"); 
				        ws.addCell(end);
				    }
				    else  if(!"end".equals(rs.getCell(0,aaa).getContents().trim()) )
				    {
				    		jxl.write.Label end = new Label(0, num,"end"); 
				        	ws.addCell(end);
				    }
				    
				//    写入Excel对象
				    wwb.write();
				//    关闭可写入的Excel对象
				    wwb.close();
				//    关闭只读的Excel对象
				    rw.close();
				out.println("更改成功");
				}else{
					break;
				}
		
		}
   

		
      
      
      
    }catch(Exception e){
      System.out.println(e);
    }

 %>
	
	</center>
</body>
</html>