java程序导出excel中如何添加单元格备注信息

Question

如题所述

Answer 1

<input type=button value=保存为 Excel><script language=javascript>function AllAreaExcel() {var title;title=document.getElementsByTagName(table)[0].childNodes.item(0).childNodes(0).childNodes(0).innerText;alert(title);var oXL = new ActiveXObject(Excel.Application);var oWB = oXL.Workbooks.Add();var oSheet = oWB.ActiveSheet;//从excel的第5行开始插入oSheet.Range(A5).select;oWB .Worksheets(1).Activate;oSheet.Cells(3,1).Value=title; //在第3行插入报表头oWB.Worksheets(1).Range(A3:I3).merge(); // 合并单元格区域 A3:I3oWB.Worksheets(1).Range(A3:I3).HorizontalAlignment=3; //居中对齐A3:I3var sel=document.body.createTextRange();sel.moveToElementText(table1); //table 的ID值sel.select();