male.xml

详细介绍了excel宏语言vba开发原理

<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'>
		<s:AttributeType name='c0' rs:name='职工编号' rs:number='1' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='5'/>
		</s:AttributeType>
		<s:AttributeType name='c1' rs:name='所属部门' rs:number='2' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='10'/>
		</s:AttributeType>
		<s:AttributeType name='c2' rs:name='姓名' rs:number='3' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='10'/>
		</s:AttributeType>
		<s:AttributeType name='c3' rs:name='性别' rs:number='4' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='1'/>
		</s:AttributeType>
		<s:AttributeType name='c4' rs:name='职务' rs:number='5' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='10'/>
		</s:AttributeType>
		<s:AttributeType name='c5' rs:name='职称' rs:number='6' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='10'/>
		</s:AttributeType>
		<s:AttributeType name='c6' rs:name='文化程度' rs:number='7' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='10'/>
		</s:AttributeType>
		<s:AttributeType name='c7' rs:name='籍贯' rs:number='8' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='string' dt:maxLength='20'/>
		</s:AttributeType>
		<s:AttributeType name='c8' rs:name='出生日期' rs:number='9' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='dateTime' rs:dbtype='variantdate' dt:maxLength='16' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='c9' rs:name='年龄' rs:number='10' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='c10' rs:name='参加工作时间' rs:number='11' rs:nullable='true' rs:maydefer='true'
			 rs:writeunknown='true'>
			<s:datatype dt:type='dateTime' rs:dbtype='variantdate' dt:maxLength='16' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='c11' rs:name='工龄' rs:number='12' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
			<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='c12' rs:name='进本单位时间' rs:number='13' rs:nullable='true' rs:maydefer='true'
			 rs:writeunknown='true'>
			<s:datatype dt:type='dateTime' rs:dbtype='variantdate' dt:maxLength='16' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:AttributeType name='c13' rs:name='本单位工龄' rs:number='14' rs:nullable='true' rs:maydefer='true'
			 rs:writeunknown='true'>
			<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
		</s:AttributeType>
		<s:extends type='rs:rowbase'/>
	</s:ElementType>
</s:Schema>
<rs:data>
	<z:row c0='00002' c1='人力资源部' c2='王玉成' c3='男' c4='副主任' c5='工程师' c6='博士' c7='北京市'
		 c8='1972-05-16T00:00:00' c9='34' c10='1992-11-03T00:00:00' c11='14' c12='1995-03-26T00:00:00' c13='11'/>
	<z:row c0='00003' c1='技术部' c2='李然' c3='男' c4='项目经理' c5='工程师' c6='本科' c7='天津市'
		 c8='1967-11-03T00:00:00' c9='39' c10='1986-05-12T00:00:00' c11='20' c12='1990-09-16T00:00:00' c13='16'/>
	<z:row c0='00004' c1='销售部' c2='孙顺' c3='男' c4='项目经理' c5='工程师' c6='硕士' c7='北京市'
		 c8='1974-11-03T00:00:00' c9='32' c10='1980-11-03T00:00:00' c11='26' c12='1982-11-03T00:00:00' c13='24'/>
	<z:row c0='00005' c1='销售部' c2='李辉' c3='男' c4='项目经理' c5='工程师' c6='硕士' c7='上海市'
		 c8='1968-08-16T00:00:00' c9='38' c10='1980-11-03T00:00:00' c11='26' c12='1982-09-22T00:00:00' c13='24'/>
	<z:row c0='00006' c1='总经理办公室' c2='刘邦' c3='男' c4='总经理' c5='高级工程师' c6='博士'
		 c7='北京市' c8='1964-11-03T00:00:00' c9='42' c10='1978-11-03T00:00:00' c11='26' c12='1980-11-03T00:00:00'
		 c13='26'/>
	<z:row c0='00008' c1='财务部' c2='王玉成' c3='男' c4='副主任' c5='高级经济师' c6='本科' c7='上海市'
		 c8='1963-11-03T00:00:00' c9='43' c10='1981-11-03T00:00:00' c11='25' c12='1979-11-03T00:00:00' c13='27'/>
	<z:row c0='00012' c2='王辉' c3='男' c6='本科' c7='北京市' c8='1985-05-20T00:00:00' c9='21' c12='2006-04-02T00:00:00'/>
</rs:data>
</xml>