|
以文本方式查看主题 - 中文XML论坛 - 专业的XML技术讨论区 (http://bbs.xml.org.cn/index.asp) -- 『 WORD to XML, HTML to XML 』 (http://bbs.xml.org.cn/list.asp?boardid=13) ---- 如何这段XML转换EXCEL (http://bbs.xml.org.cn/dispbbs.asp?boardid=13&rootid=&id=18326) |
|
-- 作者：阿精 -- 发布时间：5/15/2005 9:39:00 AM -- 如何这段XML转换EXCEL - <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"> - <s:Schema id="RowsetSchema"> - <s:ElementType name="row" content="eltOnly" rs:updatable="true" rs:UniqueTable="Report_Day"> - <s:AttributeType name="emp_id" rs:number="1" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="emp_id" rs:keycolumn="true"> <s:datatype dt:type="string" dt:maxLength="12" /> </s:AttributeType> - <s:AttributeType name="sign_date" rs:number="2" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="sign_date" rs:keycolumn="true"> <s:datatype dt:type="dateTime" rs:dbtype="variantdate" dt:maxLength="16" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="shift_id" rs:number="3" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="shift_id"> <s:datatype dt:type="string" dt:maxLength="8" /> </s:AttributeType> - <s:AttributeType name="status" rs:number="4" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="status"> <s:datatype dt:type="ui1" dt:maxLength="1" rs:precision="3" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="sign_count" rs:number="5" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="sign_count"> <s:datatype dt:type="ui1" dt:maxLength="1" rs:precision="3" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="in1" rs:number="6" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="in1"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="out1" rs:number="7" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="out1"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="in2" rs:number="8" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="in2"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="out2" rs:number="9" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="out2"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="in3" rs:number="10" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="in3"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="out3" rs:number="11" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="out3"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="in4" rs:number="12" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="in4"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="out4" rs:number="13" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="out4"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="in5" rs:number="14" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="in5"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="out5" rs:number="15" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="out5"> <s:datatype dt:type="string" dt:maxLength="5" /> </s:AttributeType> - <s:AttributeType name="work_days" rs:number="16" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="work_days"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="absent_days" rs:number="17" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="absent_days"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="leave_days" rs:number="18" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="leave_days"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="work_hrs" rs:number="19" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="work_hrs"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="basic_hrs" rs:number="20" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="basic_hrs"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="ot_hrs" rs:number="21" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="ot_hrs"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="late_mins" rs:number="22" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="late_mins"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="leave_mins" rs:number="23" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="leave_mins"> <s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="3" rs:precision="9" rs:fixedlength="true" /> </s:AttributeType> - <s:AttributeType name="notes" rs:number="24" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Report_Day" rs:basecolumn="notes"> <s:datatype dt:type="string" dt:maxLength="50" /> </s:AttributeType> - <s:AttributeType name="emp_fname" rs:number="25" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Employee" rs:basecolumn="emp_fname"> <s:datatype dt:type="string" dt:maxLength="10" /> </s:AttributeType> - <s:AttributeType name="depart_name" rs:number="26" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Depart" rs:basecolumn="depart_name"> <s:datatype dt:type="string" dt:maxLength="50" /> </s:AttributeType> - <s:AttributeType name="job_name" rs:number="27" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true" rs:basetable="Job" rs:basecolumn="job_name"> <s:datatype dt:type="string" dt:maxLength="50" /> </s:AttributeType> <s:extends type="rs:rowbase" /> </s:ElementType> </s:Schema> - <rs:data> <z:row emp_id="1" sign_date="2005-04-01T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:41" out1="11:29" in2="13:07" out2="18:00" in3="18:25" out3="22:43" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="12.200" basic_hrs="7.500" ot_hrs="4.700" late_mins=".000" leave_mins="1.000" notes="旷工0.1天,早退1分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-02T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:29" out1="11:30" in2="13:07" out2="17:57" in3="18:22" out3="23:01" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="12.500" basic_hrs="7.500" ot_hrs="5.000" late_mins=".000" leave_mins="2.000" notes="旷工0.1天,早退2分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-03T00:00:00" shift_id="|A|A|A" status="0" sign_count="6" in1="07:35" out1="11:30" in2="13:19" out2="17:59" in3="18:29" out3="22:04" in4="" out4="" in5="" out5="" work_days=".000" absent_days=".000" leave_days=".000" work_hrs="11.400" basic_hrs=".000" ot_hrs="11.400" late_mins=".000" leave_mins=".000" notes="" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-04T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:32" out1="11:29" in2="12:49" out2="17:57" in3="18:25" out3="22:24" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.900" basic_hrs="7.500" ot_hrs="4.400" late_mins=".000" leave_mins="3.000" notes="旷工0.1天,早退3分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-05T00:00:00" shift_id="|A|A" status="5" sign_count="4" in1="07:44" out1="11:27" in2="12:11" out2="18:01" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins="2.000" notes="旷工0.1天,早退2分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-06T00:00:00" shift_id="|A|A|A" status="1" sign_count="6" in1="07:42" out1="11:30" in2="13:18" out2="18:00" in3="18:27" out3="22:01" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.500" basic_hrs="7.500" ot_hrs="4.000" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-07T00:00:00" shift_id="|A|A|A" status="1" sign_count="6" in1="07:44" out1="11:30" in2="13:10" out2="18:00" in3="18:24" out3="22:00" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.500" basic_hrs="7.500" ot_hrs="4.000" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-08T00:00:00" shift_id="|A|A" status="1" sign_count="4" in1="07:43" out1="11:30" in2="13:06" out2="17:59" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-09T00:00:00" shift_id="|A|A" status="5" sign_count="4" in1="07:47" out1="11:29" in2="13:06" out2="17:59" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins="2.000" notes="旷工0.1天,早退2分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-10T00:00:00" shift_id="|A|A" status="0" sign_count="4" in1="07:42" out1="11:28" in2="13:02" out2="17:58" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".000" absent_days=".000" leave_days=".000" work_hrs="7.800" basic_hrs=".000" ot_hrs="7.800" late_mins=".000" leave_mins=".000" notes="" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-11T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:47" out1="11:28" in2="13:00" out2="17:59" in3="18:23" out3="22:00" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.500" basic_hrs="7.500" ot_hrs="4.000" late_mins=".000" leave_mins="2.000" notes="旷工0.1天,早退2分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-12T00:00:00" shift_id="|A|A" status="1" sign_count="4" in1="07:46" out1="11:31" in2="13:27" out2="18:01" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-13T00:00:00" shift_id="|A|A|A" status="1" sign_count="6" in1="07:48" out1="11:30" in2="13:10" out2="18:00" in3="18:39" out3="22:00" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.300" basic_hrs="7.500" ot_hrs="3.800" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-14T00:00:00" shift_id="|A|A" status="5" sign_count="4" in1="07:47" out1="11:28" in2="13:14" out2="17:58" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins="4.000" notes="旷工0.1天,早退4分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-15T00:00:00" shift_id="|A|A" status="5" sign_count="4" in1="07:49" out1="11:27" in2="13:24" out2="17:55" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins="7.000" notes="旷工0.1天,早退7分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-16T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:52" out1="11:29" in2="13:03" out2="17:59" in3="18:25" out3="22:00" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.500" basic_hrs="7.500" ot_hrs="4.000" late_mins=".000" leave_mins="2.000" notes="旷工0.1天,早退2分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-17T00:00:00" shift_id="|A|A|A" status="0" sign_count="6" in1="07:40" out1="11:25" in2="13:02" out2="17:59" in3="18:26" out3="22:00" in4="" out4="" in5="" out5="" work_days=".000" absent_days=".000" leave_days=".000" work_hrs="11.300" basic_hrs=".000" ot_hrs="11.300" late_mins=".000" leave_mins=".000" notes="" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-18T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:46" out1="11:30" in2="13:11" out2="17:59" in3="18:28" out3="21:46" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.200" basic_hrs="7.500" ot_hrs="3.700" late_mins=".000" leave_mins="1.000" notes="旷工0.1天,早退1分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-19T00:00:00" shift_id="×" status="1" sign_count="0" in1="" out1="" in2="" out2="" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".000" absent_days="1.000" leave_days=".000" work_hrs=".000" basic_hrs=".000" ot_hrs=".000" late_mins=".000" leave_mins=".000" notes="旷工1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-20T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:51" out1="11:30" in2="13:05" out2="17:58" in3="18:23" out3="22:03" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.500" basic_hrs="7.500" ot_hrs="4.000" late_mins=".000" leave_mins="1.000" notes="旷工0.1天,早退1分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-21T00:00:00" shift_id="|A|A|A" status="1" sign_count="6" in1="07:47" out1="11:30" in2="12:50" out2="17:59" in3="18:54" out3="21:08" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="10.200" basic_hrs="7.500" ot_hrs="2.700" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-22T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:47" out1="11:28" in2="13:21" out2="17:57" in3="18:25" out3="22:42" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="12.200" basic_hrs="7.500" ot_hrs="4.700" late_mins=".000" leave_mins="4.000" notes="旷工0.1天,早退4分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-23T00:00:00" shift_id="|A|A" status="5" sign_count="4" in1="07:46" out1="11:26" in2="13:02" out2="18:00" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="8.000" basic_hrs="7.500" ot_hrs=".500" late_mins=".000" leave_mins="3.000" notes="旷工0.1天,早退3分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-24T00:00:00" shift_id="|A|A|A" status="0" sign_count="6" in1="07:48" out1="11:30" in2="13:02" out2="17:58" in3="18:26" out3="22:00" in4="" out4="" in5="" out5="" work_days=".000" absent_days=".000" leave_days=".000" work_hrs="11.400" basic_hrs=".000" ot_hrs="11.400" late_mins=".000" leave_mins=".000" notes="" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-25T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:47" out1="11:30" in2="13:04" out2="17:55" in3="18:19" out3="22:03" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.500" basic_hrs="7.500" ot_hrs="4.000" late_mins=".000" leave_mins="4.000" notes="旷工0.1天,早退4分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-26T00:00:00" shift_id="|A" status="1" sign_count="2" in1="18:20" out1="21:05" in2="" out2="" in3="" out3="" in4="" out4="" in5="" out5="" work_days=".000" absent_days=".700" leave_days=".000" work_hrs="2.500" basic_hrs=".000" ot_hrs="2.500" late_mins=".000" leave_mins=".000" notes="旷工0.7天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-27T00:00:00" shift_id="|A|A|A" status="1" sign_count="6" in1="07:52" out1="11:31" in2="13:01" out2="18:00" in3="18:28" out3="23:06" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="12.600" basic_hrs="7.500" ot_hrs="5.100" late_mins=".000" leave_mins=".000" notes="旷工0.1天" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-28T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:51" out1="11:31" in2="12:45" out2="17:59" in3="18:25" out3="24:00" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="13.500" basic_hrs="7.500" ot_hrs="6.000" late_mins=".000" leave_mins="1.000" notes="旷工0.1天,早退1分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-29T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:35" out1="11:23" in2="12:56" out2="18:01" in3="18:31" out3="23:05" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="12.500" basic_hrs="7.500" ot_hrs="5.000" late_mins=".000" leave_mins="6.000" notes="旷工0.1天,早退6分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> <z:row emp_id="1" sign_date="2005-04-30T00:00:00" shift_id="|A|A|A" status="5" sign_count="6" in1="07:50" out1="11:31" in2="13:12" out2="17:58" in3="18:32" out3="21:39" in4="" out4="" in5="" out5="" work_days=".900" absent_days=".100" leave_days=".000" work_hrs="11.100" basic_hrs="7.500" ot_hrs="3.600" late_mins=".000" leave_mins="1.000" notes="旷工0.1天,早退1分锺" emp_fname="贺金梅" depart_name="A组" job_name="員工" /> </rs:data> </xml> |
|
-- 作者：karl_chen -- 发布时间：11/3/2005 12:19:00 PM -- 其实你可以把你想要显示的格式采用电子表格画出来,然后写一个xsl将你要提取的数据转化成另外一个xml文档,然后再 你画的电子表格里通过xml映射导入生成的该xml就可以了.其中有个要解决的问题是电子表格合并后无法绑定数据.我也想解决这个问题. |
|
-- 作者：abc0317 -- 发布时间：4/6/2006 5:20:00 PM -- 大家同病相怜!我现在也在研究,有进展告诉大家! |
|
W 3 C h i n a ( since 2003 ) 旗 下 站 点 苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》 |
93.750ms |