主题:将页面表格中的内容导入到Excel时,如何设置列的宽度
我在JSP文件中写了一段脚本程序,实现将页面上显示的表格导入到Excel,但是如何设置其宽度,我这样写了但是程序就会有错。报设置宽度那一行有错:没有Columns[1]属性
<SCRIPT LANGUAGE="javascript">
//指定页面区域“单元格”内容导入Excel
function CellAreaExcel()
{
alert("start to export");
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var Lenr = PrintB.rows.length;
alert("start to export5");
oSheet.Cloumns[1].CloumnsWidth=5;
for (i=0;i<Lenr;i++)
{
var Lenc = PrintB.rows(i).cells.length;
for (j=0;j<Lenc;j++)
{
oSheet.Cells(i+1,j+1).value = PrintB.rows(i).cells(j).innerText.toString();
}
}
oXL.Visible = true;
}
PrintB是页面上显示的表格的ID
<SCRIPT LANGUAGE="javascript">
//指定页面区域“单元格”内容导入Excel
function CellAreaExcel()
{
alert("start to export");
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var Lenr = PrintB.rows.length;
alert("start to export5");
oSheet.Cloumns[1].CloumnsWidth=5;
for (i=0;i<Lenr;i++)
{
var Lenc = PrintB.rows(i).cells.length;
for (j=0;j<Lenc;j++)
{
oSheet.Cells(i+1,j+1).value = PrintB.rows(i).cells(j).innerText.toString();
}
}
oXL.Visible = true;
}
PrintB是页面上显示的表格的ID