探讨生成excel的方法 附加源码探讨 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 dtElement=((Element)((Element)worksheetNode).getElementsByTagName("Table").item(0)); dtRowlist=dtElement.getElementsByTagName("Row"); dtColumnWidthlist=dtElement.getElementsByTagName("Column"); rowLastColumn=dtColumnWidthlist.item(dtColumnWidthlist.getLength()-1).cloneNode(true); dtRowlistTitle=((Element)dtElement.getElementsByTagName("Row").item(0)).getElementsByTagName("Cell").item(1).cloneNode(true); dtTitle =(Element)dtRowlist.item(4).cloneNode(true); dtContxt=(Element)dtRowlist.item(5).cloneNode(true); dtSumContxt=(Element)dtRowlist.item(6).cloneNode(true); dtLastSumPrivContxt=(Element)dtRowlist.item(7).cloneNode(true); dtLastSumContxt=(Element)dtRowlist.item(8).cloneNode(true); if((null!=dtRowlist)&&(dtRowlist.getLength()>=4)){ for(int i=0;i<4;i++){ dtCelllist = ((Element)dtRowlist.item(i)).getElementsByTagName("Cell"); int is= dtCelllist.getLength(); for(int jj=0;jj<is;jj++){ if(((Element)dtCelllist.item(jj).getFirstChild())!=null){ for(SCSKColumnModel scm:this.localSCSKColumnModellist){ if(scm.isAlreadyAddColumn()){continue;} if(0==scm.getChildColumnName().trim().indexOf("D")&&(!scm.isAlreadyAddColumn())){ ((Element)dtLastSumPrivContxt).getElementsByTagName("Cell").item(0).getFirstChild().setTextContent(scm.getChildColumnAsName()); scm.setZAlreadyAddColumn(true); continue; } if(scm.getChildColumnName().trim().equals(((Element)dtCelllist.item(jj).getFirstChild()).getTextContent().trim())){ String tempIndex=((Element)dtCelllist.item(jj).getFirstChild()).getTextContent(); ((Element)dtCelllist.item(jj).getFirstChild()).setTextContent((scm.getChildColumnAsName().trim().equals("")?scm.getChildColumnName():scm.getChildColumnAsName())); if(scm.isDataColumn()){ int _cellIndx= Integer.valueOf(tempIndex.replace("A",""))-1; ((Element)dtCelllist.item(jj)).setAttribute("ss:userColumnAsName","_"+scm.getChildColumnName().trim()+"_"+i+"_"+String.valueOf(jj)); if(scm.isHidden()){ setHiddenColumnMark((Element)dtContxt,"ss:userColumnIsHidden",_cellIndx); setHiddenColumnMark((Element)dtSumContxt,"ss:userColumnIsHidden",_cellIndx); setHiddenColumnMark((Element)dtLastSumContxt,"ss:userColumnIsHidden",_cellIndx); ((Element)dtColumnWidthlist.item(_cellIndx)).setAttribute("ss:Hidden", "1"); } setHiddenColumnMark((Element)dtContxt,"ss:userIsDataColumn",_cellIndx); setHiddenColumnMark((Element)dtSumContxt,"ss:userIsDataColumn",_cellIndx); setHiddenColumnMark((Element)dtLastSumContxt,"ss:userIsDataColumn",_cellIndx); if(scm.isTotal()){ setHiddenColumnMark((Element)dtContxt,"ss:userIsTotal",_cellIndx); setHiddenColumnMark((Element)dtSumContxt,"ss:userIsTotal",_cellIndx); setHiddenColumnMark((Element)dtLastSumContxt,"ss:userIsTotal",_cellIndx); if(scm.isTotalTimes()){ setHiddenColumnMark((Element)dtContxt,"ss:userIsTotalTimes",_cellIndx); setHiddenColumnMark((Element)dtSumContxt,"ss:userIsTotalTimes",_cellIndx); setHiddenColumnMark((Element)dtLastSumContxt,"ss:userIsTotalTimes",_cellIndx) 求教一个servlet提交问题 excel 帐票做成现在都用jxl还是poi好。 JNative使用疑點困惑,急送分 tomcat5.5 结合 iis6 后 怎样使用户输入 www.**.com 就能访问我的java web 急!! 请问SOAP是什么? JDBC 连接SQL Server 2000 的问题 大家平时是用哪个技术blog的? eclipse编译器怎么问题一大堆啊 利用struts开发,为什么返回错误对象,却不能显示呢? JBuilder9+was5开发EJB实例部署出错,望指教一二!! 在不用spring框架的情况下如何使用 log4j? 附件保存,独立文件还是数据库BLOB
dtRowlist=dtElement.getElementsByTagName("Row");
dtColumnWidthlist=dtElement.getElementsByTagName("Column");
rowLastColumn=dtColumnWidthlist.item(dtColumnWidthlist.getLength()-1).cloneNode(true);
dtRowlistTitle=((Element)dtElement.getElementsByTagName("Row").item(0)).getElementsByTagName("Cell").item(1).cloneNode(true);
dtTitle =(Element)dtRowlist.item(4).cloneNode(true);
dtContxt=(Element)dtRowlist.item(5).cloneNode(true);
dtSumContxt=(Element)dtRowlist.item(6).cloneNode(true);
dtLastSumPrivContxt=(Element)dtRowlist.item(7).cloneNode(true);
dtLastSumContxt=(Element)dtRowlist.item(8).cloneNode(true); if((null!=dtRowlist)&&(dtRowlist.getLength()>=4)){
for(int i=0;i<4;i++){
dtCelllist = ((Element)dtRowlist.item(i)).getElementsByTagName("Cell");
int is= dtCelllist.getLength();
for(int jj=0;jj<is;jj++){
if(((Element)dtCelllist.item(jj).getFirstChild())!=null){
for(SCSKColumnModel scm:this.localSCSKColumnModellist){
if(scm.isAlreadyAddColumn()){continue;}
if(0==scm.getChildColumnName().trim().indexOf("D")&&(!scm.isAlreadyAddColumn())){
((Element)dtLastSumPrivContxt).getElementsByTagName("Cell").item(0).getFirstChild().setTextContent(scm.getChildColumnAsName());
scm.setZAlreadyAddColumn(true);
continue;
}
if(scm.getChildColumnName().trim().equals(((Element)dtCelllist.item(jj).getFirstChild()).getTextContent().trim())){
String tempIndex=((Element)dtCelllist.item(jj).getFirstChild()).getTextContent();
((Element)dtCelllist.item(jj).getFirstChild()).setTextContent((scm.getChildColumnAsName().trim().equals("")?scm.getChildColumnName():scm.getChildColumnAsName())); if(scm.isDataColumn()){
int _cellIndx= Integer.valueOf(tempIndex.replace("A",""))-1;
((Element)dtCelllist.item(jj)).setAttribute("ss:userColumnAsName","_"+scm.getChildColumnName().trim()+"_"+i+"_"+String.valueOf(jj));
if(scm.isHidden()){
setHiddenColumnMark((Element)dtContxt,"ss:userColumnIsHidden",_cellIndx);
setHiddenColumnMark((Element)dtSumContxt,"ss:userColumnIsHidden",_cellIndx);
setHiddenColumnMark((Element)dtLastSumContxt,"ss:userColumnIsHidden",_cellIndx);
((Element)dtColumnWidthlist.item(_cellIndx)).setAttribute("ss:Hidden", "1");
}
setHiddenColumnMark((Element)dtContxt,"ss:userIsDataColumn",_cellIndx);
setHiddenColumnMark((Element)dtSumContxt,"ss:userIsDataColumn",_cellIndx);
setHiddenColumnMark((Element)dtLastSumContxt,"ss:userIsDataColumn",_cellIndx); if(scm.isTotal()){
setHiddenColumnMark((Element)dtContxt,"ss:userIsTotal",_cellIndx);
setHiddenColumnMark((Element)dtSumContxt,"ss:userIsTotal",_cellIndx);
setHiddenColumnMark((Element)dtLastSumContxt,"ss:userIsTotal",_cellIndx);
if(scm.isTotalTimes()){
setHiddenColumnMark((Element)dtContxt,"ss:userIsTotalTimes",_cellIndx);
setHiddenColumnMark((Element)dtSumContxt,"ss:userIsTotalTimes",_cellIndx);
setHiddenColumnMark((Element)dtLastSumContxt,"ss:userIsTotalTimes",_cellIndx)