高手请进来,(附源代码)

错误情况:
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: -1 in the jsp file: nullGenerated servlet error:
    [javac] Since fork is true, ignoring compiler setting.
    [javac] Compiling 1 source file
    [javac] Since fork is true, ignoring compiler setting.
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:64: not a statement
    [javac] xlsbook.save;
    [javac]        ^
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:65: not a statement
    [javac] xls.quit;
    [javac]    ^
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:58: cannot resolve symbol
    [javac] symbol  : class var
    [javac] location: class org.apache.jsp.ex4_jsp
    [javac] var xls = new ActiveXObject("Excel.Application");
    [javac] ^
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:58: cannot resolve symbol
    [javac] symbol  : class ActiveXObject
    [javac] location: class org.apache.jsp.ex4_jsp
    [javac] var xls = new ActiveXObject("Excel.Application");
    [javac]               ^
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:61: cannot resolve symbol
    [javac] symbol  : class var
    [javac] location: class org.apache.jsp.ex4_jsp
    [javac] var xlsbook = xls.activeworkbook;
    [javac] ^
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:62: cannot resolve symbol
    [javac] symbol  : class var
    [javac] location: class org.apache.jsp.ex4_jsp
    [javac] var xlssheet = xlsbook.worksheets(1);
    [javac] ^
    [javac] C:\Program Files\Tomcat 4.1\work\Standalone\localhost\_\ex4_jsp.java:67: cannot resolve symbol
    [javac] symbol  : class delete
    [javac] location: class org.apache.jsp.ex4_jsp
    [javac] delete xls;
    [javac] ^
    [javac] 7 errors

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

是JS,不是JSP
<script>
var xls = new ActiveXObject("Excel.Application");
xls.visible = true;//false;
xls.workbooks.open("abc.xls");
var xlsbook = xls.activeworkbook;
var xlssheet = xlsbook.worksheets(1);
xlssheet.cells(1,1).value = "js op excel";
xlsbook.save;
xls.quit;
xls = null;
delete xls;
</script>
你这是java脚本啊，java脚本怎么能跟js一样的用法啊
把它们套在<script></script>标签中才行
但是还是不行啊,
代码:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.awt.*"%>
<%@ page import="java.util.*"%>
<html>
<head>
<title>sample</title>
<meta http-equiv="Content-Type";content-type="text/html;charset=gb2312"%>
</head>
<body bgcolor=yellow>
<script>
var xls = new ActiveXObject("Excel.Application");
xls.visible = true;//false;
xls.workbooks.open("abc.xls");
var xlsbook = xls.activeworkbook;
var xlssheet = xlsbook.worksheets(1);
xlssheet.cells(1,1).value = "js op excel";
xlsbook.save;
xls.quit;
xls = null;
delete xls;
</script></body>
</html>
错误情况:
org.apache.jasper.JasperException: /ex5.jsp(1,0) Page directive: can't have multiple occurrences of contentType
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page contentType="text/html;charset=gb2312"%>出现了两个这个东东是编译不过去的，删除一个
还是有点不行,
没有出编译大错误,
出现如下的对话框:
"出现运行错误,
是否纠正该错误
行12
错位:Automation服务器不能创建对象"我看了一下12行应该是"var xls = new ActiveXObject("Excel.Application");"
我以前也遇到过这问题,
请问怎么解决,
我如果将我的IE的internet选项中的高级页面设置为"默认"就没有弹出错误对话框,
但从下面的状态拦可以看到"完成,但网页上有错误,"的提示.
还是不行,
我想知道在你们的电脑上可以运行嘛,
这个问题我今晚遇到好几次了,
但一直都没解决,
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.awt.*"%>
<%@ page import="java.util.*"%>
<%@ page import="jxl.*"%>
<%@ page import="jxl.write.*"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>sample</title>
<meta http-equiv="Content-Type";content-type="text/html;charset=gb2312"%>
</head>
<body bgcolor=yellow>
<script>//声明一下，记得后面要关闭try {
jxl.Workbook workbook = jxl.Workbook.getWorkbook(new File("c:\sss.xls"));
} catch (Exception e) {
throw new Exception("file to import not found!");
}Sheet sheet = workbook.getSheet(0);
Cell cell = null;int columnCount=3;
int rowCount=sheet.getRows();
for (int i = 0; i <rowCount; i++) {
for (int j = 0; j <columnCount; j++) {
//注意，这里的两个参数，第一个是表示列的，第二才表示行
cell=sheet.getCell(j, i);
//要根据单元格的类型分别做处理，否则格式化过的内容可能会不正确
if(cell.getType()==CellType.NUMBER){
System.out.print(((NumberCell)cell).getValue());
}
else if(cell.getType()==CellType.DATE){
System.out.print(((DateCell)cell).getDate());
}
else{
System.out.print(cell.getContents());
}//System.out.print(cell.getContents());
System.out.print("\t");
}
System.out.print("\n");
}
//关闭它，否则会有内存泄露
workbook.close();</script></body>
</html>
希望你们帮我分析一下,
谢谢了,
类似的还有:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.awt.*"%>
<%@ page import="java.util.*"%>
<%@ page import="jxl.*"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>sample</title>
<meta http-equiv="Content-Type";content-type="text/html;charset=gb2312"%>
</head>
<body bgcolor=yellow>
<script>
var xls = new ActiveXObject("Excel.Application");
xls.visible = true;//false;
xls.workbooks.open("abc.xls");
var xlsbook = xls.activeworkbook;
var xlssheet = xlsbook.worksheets(1);
xlssheet.cells(1,1).value = "js op excel";
xlsbook.save;
xls.quit;
xls = null;
delete xls;
</script></body>
</html>
请问是什么原因,
在你们的机器能上能运行吗?
没有问题.你的代码如果是JS是没有问题的,你可能把JS和JSP混了,我看你代码引用了包jxl.*,这就只能用JSP了,是Java在服务器执行的,如果用<script>是在客户端执行的.
不怎么清楚楼上的说的什么,
可能真的是我搞错了,
但我不知道怎么改啊,
我的代码JSP代码已经全部帖出来了,
请问怎么修改可以正常运行,
上面有好几个代码,
你能帮我修改一个看看吗,
我刚学习,
不怎么懂,
我的运行环境是:
TOMCAT+J2SDK,
哦还一点就是我的程序只需要在服务器端运行就可以了,
不需要客户端对EXCEL的操作,