问个问题，怎么把JSP提交的数据保存问电子表格。就是EXCEL，急切～～～～～～～～～～～～～～～～

还有一种方法是用excel的包。从数据库中读取后输出问excel

直接用ODBC建立一个EXCEL的数据源，将得到的数据直接保存即可

将你的jsp中的定义contentType为：contentType="application/vnd.ms-excel;

这个是我用javascript写的一段代码你引入这个js
然后到你的页面上调用应该可以了！
//定义常量
var xlUnderlineStyleNone = 4294963154       //无下划线
var xlUnderlineStyleSingle = 2              //单下划线
var xlUnderlineStyleDouble = 4294963177     //双下划线var xlGeneral = 1                           //常规
var xlLeft = 4294963165                     //考左
var xlCenter = 4294963188                   //居中
var xlRight = 4294963144                    //靠右
var xlFill = 5                             //填充
var xlJustify = 1                           //两端对齐
var xlCenterAcrossSelection = 7             //跨列居中
var xlDistributed = 4294963179              //分散对齐var xlTop =  4294963136                     //靠上
var xlBottom = 4294963189                   //靠下var xlDiagonalDown = 5      //下对角线
var xlDiagonalUp = 6 //上对角线
var xlEdgeLeft = 7      //左边线
var xlEdgeTop = 8 //上边线
var xlEdgeBottom = 9 //下边线
var xlEdgeRight = 10 //右边线
var xlInsideVertical = 11 //内竖线
var xlInsideHorizontal = 12 //内横线var xlNone = 4294963154 //无边框的设置值var xlVertical = 4294963130       //字体旋转度数--文本数值排列
var xlAutomatic = 4294963191          //颜色自动var xlContinuous = 1           //联线连续
var xlThin = 2            //连线为窄线var xlLandscape = 2                          //横向打印
var xlPortrait = 1                           //纵向打印var WM_CLOSE = 16 //WM_CLOSE对应消息IDvar dataArray = new Array();
dataArray[0] =new Array();
dataArray[1] =new Array();
dataArray[2] =new Array();function createExcel()
{
var excelObj;
excelObj = new ActiveXObject( "Excel.Application" );
if( !excelObj ){
alert("无法创建EXCEL!");
}
ActiveWorkbook = excelObj.Application.WorkBooks.Add();

return excelObj;
}function closeExcel(excelObj)
{
excelObj.Application.ActiveWindow.Close();
if( !excelObj.Quit() ){
return true;
}else{
alert("无法关闭EXCEL!");
return false;
}
}function setVisible(excelObj,ab_visible)
{
if( ab_visible ){
excelObj.Application.Visible = true;
}
else{
excelObj.Application.Visible = false;
}
}function setTitle(excelObj,length,titleName)
{
var carry =0,residue=0;
var temp="";
if( length > 26)
{
carry =Math.floor(length/26) ; //返回小于等于其数值参数的最大整数
residue =length%26  ;
temp =String.fromCharCode(64+carry) + String.fromCharCode(64+residue) +1;
}else
{
temp =String.fromCharCode(65+length) +1;
}
combinCells(excelObj,'A1',temp);
setRowHeight(excelObj,1,40);
setAlign(excelObj,'A1',temp,3,2);
setFont(obj,'A1',temp,'隶书','黑体',20);
ls_range = 'A1:' + temp;
excelObj.Range( ls_range ).Select( );
excelObj.ActiveCell.FormulaR1C1 = titleName;
}function saveToFile(excelObj)
{
var myFolder=getFolder();
if(!myFolder)
{
alert("请选择保存路径!");
return;
}
var fileName=getFileName();
ActiveWorkbook.SaveAs( myFolder + fileName +".xls" );
}
function exportToExcel(excelObj)
{
var fileName=getFileName();
var content=getData();
var rowNum=content[0].length;

with(excelObj)
{
  Cells.Select;
      Selection.NumberFormatLocal = "@" ;   for(var i=2;i<rowNum+2;i++)
  {
    var a=65,b=65;
    var firstColSpanContorl=0;
    var titlePrinted=0; //控制打印标题次数
    var temp1="";
    var subContent0 =content[0][i-2].split(",");
    var subContent1 =content[1][i-2].split(",");
    var subContent2 =content[2][i-2].split(",");
    var colNum =subContent0.length;     if(i==2 && titlePrinted==0 ) //打印大标题部分
    {
     var titleLen =colNum;
     if(content[0][i-1].split(",").length>colNum)
     {
     titleLen =content[0][i-1].split(",").length;
     }
     setTitle(excelObj,titleLen,fileName);
     titlePrinted==1;
    }
    for(var j=0;j<colNum;j++) //打印数据部分
    {
       var temp="";  var temp2="";
       if( a > 90 ){ //列坐标进位控制
        a=65;
    temp1 =String.fromCharCode(b);
    temp = temp1 + String.fromCharCode(a);
    b++;
   }else{
    temp = temp1+ String.fromCharCode(a);
   }
   var tempVatical=temp;
   temp +=i;        if( i<3 && subContent2[j] !=1 && subContent2[j].length !=0) //打印小title(第2，3行)
   {
       if( i==2 && firstColSpanContorl==0 ){
         a = a +( Number(subContent2[j])-2 );
         firstColSpanContorl=1;
        }else{
       a = a + Number(subContent2[j])-1;
       }
       if( a > 90 ){ //进位
        a=65;
    temp1 =String.fromCharCode(b);
    temp2 = temp1 + String.fromCharCode(a);
    b++;
   }else{
    temp2 = temp1+ String.fromCharCode(a);
   }
    temp2 +=i;
    combinCells(excelObj,temp,temp2);
    ls_range =temp + ':' + temp2;
Range( ls_range ).Select( );
   }else if( i<3 && subContent1[j] !=1 && subContent1[j].length !=0)
   {
tempVatical =tempVatical + ( i+ Number(subContent2[j]) );
    combinCells(excelObj,temp,tempVatical);
    ls_range =temp + ':' + tempVatical;
Range( ls_range ).Select( );
   }else{
   //Range("A1").Select; 打印数据
   Range(temp).Select;
   }
   ActiveCell.FormulaR1C1 = subContent0[j];

   a++;
    }
  }
}
excelObj.Application.Visible = true;
    //ActiveWorkbook.SaveAs( myFolder + fileName +".xls" );
    return true;
}function getFolder()
{
   var Message = '请选择保存路径';
   var Shell  = new ActiveXObject( "Shell.Application" );
   var Folder = Shell.BrowseForFolder(0,Message,0x0040,0x11);

   if(Folder != null)
   {
    Folder = Folder.items();
     Folder = Folder.item();
     Folder = Folder.Path;
     if(Folder.charAt(Folder.length-1) != "\\")
       Folder = Folder + "\\";

     return Folder;
   }else
   {
     return false;
   }
}function setFolder(excelObj,savePath,fileName)
{
if(savePath.charAt(savePath.length-1) != "\\")
       savePath = savePath + "\\";
if( excelObj.ActiveWorkbook.SaveAs( savePath + fileName +".xls" ) )
{
return true;
}else{
alert("文件存储失败,请检查[路径,文件名]是否正确!");
return false;
}
}

其实要保存成Excel格式非常简单,你可以在Excel中做好你要显示的格式,无论多花翘都可以,然后把这个Excel档存成WEB档案,把原码放到jsp中,然后在相应的地方填上数据就可以了.这样你就不用你自己写显示格式,可以做的漂亮,而且简单!

你们的方法我尝试了，
但是如果页面里有JSP的代码，
那么就好像不行
如果我的TABLE里的数据是用JSP获得的，好像就不行
如果是静态的我手动写就可以

调试易

问个问题，怎么把JSP提交的数据保存问电子表格。就是EXCEL，急切～～～～～～～～～～～～～～～～

解决方案 »