将数据导入excel中(java和JavaScript结合使用),‘java’获取数据,‘JavaScript’将数据导入到excel中。
//指定内容导入Excel
function toExcel(){
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
oSheet.Cells(1,1).value = '相关主题' ;
oSheet.Cells(1,2).value = '姓名' ;
oSheet.Cells(1,3).value = '积分' ;
oSheet.Cells(1,4).value = '统计时间' ;
oSheet.Cells(1,5).value = '积分说明' ;
<%
//获得需导出的数据
List<PersonIntegralDetailBean> list = results.getIntegralList();
for(int i=0 ;i < list.size() ;i++){
%>
var t = <%=i%>;
t = t + 2;
oSheet.Cells(t,1).value = '<%=list.get(i).getTitle()%>' ;
oSheet.Cells(t,2).value = '<%=list.get(i).getPerson()%>' ;
oSheet.Cells(t,3).value = '<%=list.get(i).getIntegral()%>' ;
oSheet.Cells(t,4).value = '<%=list.get(i).getTime()%>' ;
oSheet.Cells(t,5).value = '<%=list.get(i).getIntegralNote()%>' ;
<%
}
%>
oSheet.Cells(<%=list.size()+4%>,2).value = '当前总积分:' ;
oSheet.Cells(<%=list.size()+4%>,3).value = '<%=result.getJifen()%>' ;
oXL.Visible = true;
}