代码快速实现xml转换为Excelxml转excel通用类java完成代码可作工具使用Word文档下载推荐.docx
- 文档编号:19293284
- 上传时间:2023-01-05
- 格式:DOCX
- 页数:24
- 大小:87.60KB
代码快速实现xml转换为Excelxml转excel通用类java完成代码可作工具使用Word文档下载推荐.docx
《代码快速实现xml转换为Excelxml转excel通用类java完成代码可作工具使用Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《代码快速实现xml转换为Excelxml转excel通用类java完成代码可作工具使用Word文档下载推荐.docx(24页珍藏版)》请在冰豆网上搜索。
活动信息"
mainXmlStruct1.tableCalssField="
OBJ_SUBTYPE"
mainXmlStruct1.tableCalssCName.put("
200101"
"
院团大事"
);
HashMap<
String,String>
test1=newHashMap<
();
test1.put("
0"
新建"
100"
完成"
mainXmlStruct1.tableFilesClassValue.put("
OBJ_STATE"
test1);
mainXmlStruct1.tableFiles=newString[][]{{"
OBJ_NAME"
活动名称"
},{"
FIELD_1"
活动内容简介"
FIELD_2"
活动开始时间"
},
{"
FIELD_3"
活动结束时间"
状态"
}};
xt.alltables.put("
mainXmlStruct1);
思路,
定义结构定义数据关系
过程循环取表,循环取表头,循环取内容--------
classxExcelType
{
/**xls显示方式0:
组合式1:
单一列表式**/
intexShowType=0;
StringrootName="
DataSource"
StringmaintableName="
String,xmlStruct>
alltables=newHashMap<
}
/**定义xml数据结构定义**/
classxmlStruct
StringtableName="
"
//表名
StringtableCName="
//表名中文说明
/**表的性质0:
主表(默认)1:
从表---这里暂处理1级主从,哈**/
inttableType=0;
StringtableCalssField="
//如果有内容分类,分类标识字段
StringtableCalssFieldValue="
tableCalssCName=newHashMap<
/**表的字典字段及对应值**/
String,HashMap<
>
tableFilesClassValue=newHashMap<
/**表字段中文对应**/
//HashMap<
tableFiles=newHashMap<
String,
String>
String[][]tableFiles;
理论上通用,罪过。
不多说,有可能用到的,下附件看看。
不合理的地方请指出----------------
下面是完整代码(一些特殊引用只是用作数据取数据,引用时可以去掉的----)packagejetsennet.jmcc.business;
importjava.io.File;
importjava.io.IOException;
importjava.sql.SQLException;
importjava.util.HashMap;
importjava.util.Iterator;
importjava.util.List;
importjava.util.Map;
importjavax.jws.WebParam;
importmon.PathUtil;
importjetsennet.contentmanage.CmDataAccess;
importjetsennet.contentmanage.CmObjHelper;
import.UserAuthHeader;
import.WSResult;
importjetsennet.sqlclient.ConnectionInfo;
importjetsennet.sqlclient.DbConfig;
importjetsennet.sqlclient.ISqlExecutor;
importjetsennet.sqlclient.QueryTable;
importjetsennet.sqlclient.SqlClientObjFactory;
importjetsennet.sqlclient.SqlCondition;
importjetsennet.sqlclient.SqlLogicType;
importjetsennet.sqlclient.SqlParamType;
importjetsennet.sqlclient.SqlQuery;
importjetsennet.sqlclient.SqlRelationType;
importjetsennet.sqlclient.TableJoinType;
importjetsennet.util.StringUtil;
importjxl.Workbook;
importjxl.write.Label;
importjxl.write.WritableCellFormat;
importjxl.write.WritableFont;
importjxl.write.WritableSheet;
importjxl.write.WritableWorkbook;
importorg.dom4j.Document;
importorg.dom4j.Element;
importorg.dom4j.io.SAXReader;
publicclassxmlToExcel
privatestaticjetsennet.logger.ILoglogger=jetsennet.logger.LogManager.getLogger("
JetsenNet.JCMP"
privatestaticStringXSD_FILE_PATH="
jcmp/schemafiles"
privatestaticConnectionInfocmpConnectionString=newConnectionInfo(DbConfig.getProperty("
cmp_driver"
),DbConfig.getProperty("
cmp_dburl"
),
DbConfig.getProperty("
cmp_dbuser"
cmp_dbpwd"
));
staticjxl.write.WritableFonttitleFont=newjxl.write.WritableFont(WritableFont.createFont("
宋体"
),10,WritableFont.BOLD,false);
staticWritableCellFormattitleFormat=newjxl.write.WritableCellFormat(titleFont);
privatestaticConnectionInfomccConnectionString=newConnectionInfo(DbConfig.getProperty("
mcc_driver"
mcc_dburl"
mcc_dbuser"
mcc_dbpwd"
privatestaticISqlExecutorsqlExecutor=SqlClientObjFactory.createSqlExecutor(mccConnectionString);
staticintcelltitlenow=0;
//当前列表头列号
staticintcellvaluenow=0;
//当前内容列号
staticintrowtitlenow=0;
//当前列表头行号
staticbooleanaddcelltitle=true;
staticStringOldObjtype="
publicstaticvoidmain(String[]args)
Filefile=newFile("
C:
/temp/test.xls"
WritableWorkbookworkbook;
try
workbook=Workbook.createWorkbook(file);
//processActivity(workbook,"
4023,4025,4007,4024,4026"
200101,200103,200101,200102,200104"
processActivity(workbook,"
4023,4025,4007"
200101,200101,200101"
workbook.write();
workbook.close();
catch(Exceptione)
//TODOAuto-generatedcatchblock
e.printStackTrace();
System.out.println("
OK?
publicstaticvoidprocessActivity(WritableWorkbookworkBook,String
obj_id,Stringobj_subtype)throwsException
OldObjtype="
celltitlenow=0;
addcelltitle=true;
rowtitlenow=0;
WritableSheetsheet=workBook.createSheet("
sheet1"
0);
/****/
/**导出ID**/
String[]ids=obj_id.split("
"
/**导出类型**/
String[]idt=obj_subtype.split("
/**导出个数**/
intidsl=ids.length;
/**定义列宽**/
intcellwihth=20;
xExcelTypext=newxExcelType();
xt.exShowType=1;
if(xt.exShowType==1)
else
addcelltitle=false;
//******************主表/结构定义
//200101
200102"
院团出访"
200103"
院团专家交流"
//200104
xmlStructmainXmlStruct2=newxmlStruct();
mainXmlStruct2.tableName="
mainXmlStruct2.tableCName="
mainXmlStruct2.tableCalssField="
mainXmlStruct2.tableCalssCName.put("
200104"
院团演出"
mainXmlStruct2.tableFiles=newString[][]{{"
mainXmlStruct2);
//20010401
xmlStructmainXmlStruct3=newxmlStruct();
mainXmlStruct3.tableName="
mainXmlStruct3.tableCalssField="
mainXmlStruct3.tableCalssCName.put("
20010401"
演出日志"
showType_hm=getHMctroWord("
//mainXmlStruct1.tableFilesClassValue.put("
showType_hm);
mainXmlStruct3.tableFiles=newString[][]{{"
演出时间"
演出场次"
演出类型"
NUM_VAL2"
观众人数"
mainXmlStruct3);
//********************从表/结构定义
//
xmlStructson1Struct1=newxmlStruct();
son1Struct1.tableName="
CM10_MULTIINFO"
son1Struct1.tableCName="
动信息"
son1Struct1.tableCalssField="
INFO_TYPE"
son1Struct1.tableCalssFieldValue="
1"
test2=newHashMap<
//test2.put("
新建1"
2"
完成2"
3"
完成3"
//xs2.tableFilesClassValue.put("
test2);
son1Struct1.tableFiles=newString[][]{{"
活动地点"
200101-1"
son1Struct1);
200102-1"
200103-1"
xmlStructson1Struct2=newxmlStruct();
son1Struct2.tableName="
son1Struct2.tableCName="
人员信息"
son1Struct2.tableCalssField="
son1Struct2.tableCalssFieldValue="
son1Struct2.tableFiles=newString[][]{{"
参与人员"
200101-2"
son1Struct2);
200102-2"
200103-2"
xmlStructson1Struct3=newxmlStruct();
son1Struct3.tableName="
son1Struct3.tableCName="
剧目信息"
son1Struct3.tableCalssField="
son1Struct3.tableCalssFieldValue="
son1Struct3.tableFiles=newString[][]{{"
剧目名称"
200101-3"
son1Struct3);
200102-3"
200103-3"
xmlStructson2Struct1=newxmlStruct();
son2Struct1.tableName="
son2Struct1.tableCalssField="
son2Struct1.tableCalssFieldValue="
son2Struct1.tableFiles=newString[][]{{"
节目单"
200104-1"
son2Struct1);
xmlStructson2Struct2=newxmlStruct();
son2Struct2.tableName="
son2Struct2.tableCalssField="
son2Struct2.tableCalssFieldValue="
son2Struct2.tableFiles=newString[][]{{"
剪报"
200104-2"
son2Struct2);
xmlStructson2Struct3=newxmlStruct();
son2Struct3.tableName="
son2Struct3.tableCalssField="
son2Struct3.tableCalssFieldValue="
son2Struct3.tableFiles=newString[][]{{"
海报"
200104-3"
son2Struct3);
//演出的日志多关联
xmlStructson3Struct1=newxmlStruct();
son3Struct1.tableName="
son3Struct1.tableCalssField="
son3Struct1.tableCalssFieldValue="
son3Struct1.tableFiles=newString[][]{{"
FIELD_
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 代码 快速 实现 xml 转换 Excelxml excel 通用 java 完成 工具 使用
链接地址:https://www.bdocx.com/doc/19293284.html