Question

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

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:I3 oWB.Worksheets(1).Range(A3:I3).HorizontalAlignment=3; //居中对齐A3:I3 var sel=document.body.createTextRange(); sel.moveToElementText(table1); //table 的ID值 sel.select();