Есть xml файл похожего типа | Код |
<?xml version="1.0" encoding="utf-8"?>
<Parametres>
<Conditions>
<Time_of_a_beginning>99.99.9999 15:00:15</Time_of_a_beginning>
<Liquid>Vodka</Liquid>
<Solvent_name>Vodka</Solvent_name>
<Solvent_reference_experiment_patch>D:\MY_PROJECTS\BPA\BPA\bin\Debug\Capillary\26R02.ref</Solvent_reference_experiment_patch>
<Solvent_tension>72.74</Solvent_tension>
<Concentration_unit />
<Concentration>0</Concentration>
<Viscosity_of_sample>1</Viscosity_of_sample>
<Density_at_temperature_room>1</Density_at_temperature_room>
<Density_at_temperature_thermostat />
<Version />
<Device_version />
<Decimal_separator>.</Decimal_separator>
<Short_Time_range_only>0</Short_Time_range_only>
</Conditions>
<Measurement>
<Mode>Critical Point Mode</Mode>
</Measurement>
<Parameters_of_capillary>
<Capillary_Name>26R02</Capillary_Name>
<Radius>0.13</Radius>
<Immersion_depth>5</Immersion_depth>
<Dead_Time_reference>0.014</Dead_Time_reference>
<Bubble_volume_reference>2.8</Bubble_volume_reference>
<Coefficient>1.0719</Coefficient>
<Equilibrium_pressure>1079.39</Equilibrium_pressure>
</Parameters_of_capillary>
<Points>
<Point Num="1" Time="0" Temperature="25.6" Pressure="1007" STensionRaw="66.74" Flowrate="11.2" Bubble_Time="0.2214" Dead_Time="0.0141" Life_Time="0.2073" Time_Effect="0.12400081441632431" STension="66.55" />
<Point Num="2" Time="1" Temperature="25.6" Pressure="1007" STensionRaw="66.74" Flowrate="11.2" Bubble_Time="0.2214" Dead_Time="0.0141" Life_Time="0.2073" Time_Effect="0.12400081441632431" STension="66.55" />
<Point Num="3" Time="44" Temperature="25.6" Pressure="1039.2" STensionRaw="68.99" Flowrate="8.9" Bubble_Time="0.2804" Dead_Time="0.014199999999999999" Life_Time="0.2662" Time_Effect="0.17171782803232344" STension="68.94" />
<Point Num="4" Time="87" Temperature="25.7" Pressure="1063.6" STensionRaw="70.69" Flowrate="7.5" Bubble_Time="0.3425" Dead_Time="0.0136" Life_Time="0.32889999999999997" Time_Effect="0.2319288382345546" STension="70.73" />
<Point Num="5" Time="153" Temperature="25.7" Pressure="1061" STensionRaw="70.51" Flowrate="6.2" Bubble_Time="0.4117" Dead_Time="0.013900000000000001" Life_Time="0.3979" Time_Effect="0.27828836126411416" STension="70.6" />
<Point Num="6" Time="213" Temperature="25.7" Pressure="1056.4" STensionRaw="70.19" Flowrate="5.8" Bubble_Time="0.5016" Dead_Time="0.013900000000000001" Life_Time="0.48760000000000003" Time_Effect="0.33525955384316819" STension="70.31" />
<Point Num="7" Time="327" Temperature="25.8" Pressure="1051.2" STensionRaw="69.82" Flowrate="3.4" Bubble_Time="0.6126" Dead_Time="0.0141" Life_Time="0.59839999999999993" Time_Effect="0.40345784456557543" STension="69.94" />
<Point Num="8" Time="449" Temperature="25.9" Pressure="1044.9" STensionRaw="69.39" Flowrate="3.3" Bubble_Time="0.75020000000000009" Dead_Time="0.0143" Life_Time="0.7359" Time_Effect="0.48508680848492752" STension="69.46" />
<Point Num="9" Time="519" Temperature="25.9" Pressure="1042.2" STensionRaw="69.2" Flowrate="0" Bubble_Time="0.90960000000000008" Dead_Time="0.013900000000000001" Life_Time="0.8957" Time_Effect="0.5836406442650085" STension="69.19" />
<Point Num="10" Time="593" Temperature="25.9" Pressure="1035.9" STensionRaw="68.76" Flowrate="0" Bubble_Time="1.0936" Dead_Time="0.0144" Life_Time="1.0792" Time_Effect="0.69135869286347518" STension="68.76" />
<Point Num="11" Time="594" Temperature="25.9" Pressure="1035.9" STensionRaw="68.76" Flowrate="0" Bubble_Time="1.0936" Dead_Time="0.0144" Life_Time="1.0792" Time_Effect="0.69135869286347518" STension="68.76" />
<Point Num="12" Time="624" Temperature="25.9" Pressure="1069.03" STensionRaw="70.87" Flowrate="9.2" Bubble_Time="0.2707" Dead_Time="0.013833" Life_Time="0.25683300000000003" Time_Effect="0.18280433442672542" STension="70.87" />
<Point Num="13" Time="644" Temperature="26" Pressure="1067.5" STensionRaw="70.85" Flowrate="8.98" Bubble_Time="0.301" Dead_Time="0.013" Life_Time="0.288" Time_Effect="0.20470889238913667" STension="70.85" />
<Point Num="14" Time="662" Temperature="26" Pressure="1069.79" STensionRaw="70.8" Flowrate="8.97" Bubble_Time="0.307" Dead_Time="0.014" Life_Time="0.293" Time_Effect="0.2075646918207279" STension="70.8" />
<Point Num="15" Time="680" Temperature="26" Pressure="1066.74" STensionRaw="70.88" Flowrate="8.98" Bubble_Time="0.309" Dead_Time="0.01375" Life_Time="0.29525" Time_Effect="0.21029215320362507" STension="70.88" />
<Point Num="16" Time="699" Temperature="26" Pressure="1068.26" STensionRaw="70.93" Flowrate="9.1" Bubble_Time="0.2842" Dead_Time="0.014" Life_Time="0.27025" Time_Effect="0.19315436346109879" STension="70.93" />
<Point Num="17" Time="721" Temperature="26" Pressure="1072.84" STensionRaw="71.01" Flowrate="11.74" Bubble_Time="0.2422" Dead_Time="0.013" Life_Time="0.22925" Time_Effect="0.16478698487606974" STension="71.01" />
<Point Num="18" Time="741" Temperature="26" Pressure="1070.55" STensionRaw="71.1" Flowrate="11.98" Bubble_Time="0.2238" Dead_Time="0.0135" Life_Time="0.210333" Time_Effect="0.15219782859276632" STension="71.1" />
<Point Num="19" Time="770" Temperature="26" Pressure="1073.6" STensionRaw="71.39" Flowrate="17.35" Bubble_Time="0.168" Dead_Time="0.013167" Life_Time="0.154833" Time_Effect="0.11469325992218994" STension="71.39" />
<Point Num="20" Time="793" Temperature="26" Pressure="1074.97" STensionRaw="71.45" Flowrate="19.28" Bubble_Time="0.149" Dead_Time="0.0135" Life_Time="0.1355" Time_Effect="0.10090491389257118" STension="71.45" />
<Point Num="21" Time="824" Temperature="26" Pressure="1078.94" STensionRaw="71.69" Flowrate="25.5" Bubble_Time="0.1165" Dead_Time="0.0134" Life_Time="0.1031" Time_Effect="0.078572144513587835" STension="71.69" />
<Point Num="22" Time="843" Temperature="26.1" Pressure="1078.28" STensionRaw="71.74" Flowrate="25.74" Bubble_Time="0.1145" Dead_Time="0.0132" Life_Time="0.1013" Time_Effect="0.077608496794887058" STension="71.74" />
<Point Num="23" Time="875" Temperature="26.1" Pressure="1080.97" STensionRaw="71.92" Flowrate="31.45" Bubble_Time="0.0916" Dead_Time="0.013417" Life_Time="0.078167" Time_Effect="0.061134746359201977" STension="71.92" />
<Point Num="24" Time="894" Temperature="26.1" Pressure="1081.06" STensionRaw="71.81" Flowrate="31.37" Bubble_Time="0.091299999999999992" Dead_Time="0.0135" Life_Time="0.077833" Time_Effect="0.060090627980220065" STension="71.81" />
<Point Num="25" Time="921" Temperature="26.1" Pressure="1082.83" STensionRaw="72.04" Flowrate="36.64" Bubble_Time="0.080099999999999991" Dead_Time="0.013214" Life_Time="0.066929" Time_Effect="0.05316543797107795" STension="72.04" />
<Point Num="26" Time="945" Temperature="26.1" Pressure="1084.82" STensionRaw="72.13" Flowrate="39.58" Bubble_Time="0.0726" Dead_Time="0.013" Life_Time="0.059643" Time_Effect="0.047991506739825759" STension="72.13" />
<Point Num="27" Time="971" Temperature="26.1" Pressure="1085.55" STensionRaw="72.15" Flowrate="42.15" Bubble_Time="0.0676" Dead_Time="0.013214" Life_Time="0.054357" Time_Effect="0.043870803098225615" STension="72.15" />
<Point Num="28" Time="994" Temperature="26.1" Pressure="1085.04" STensionRaw="72.24" Flowrate="43.28" Bubble_Time="0.064" Dead_Time="0.012813000000000002" Life_Time="0.051188000000000004" Time_Effect="0.04191772449158794" STension="72.24" />
<Point Num="29" Time="1017" Temperature="26.1" Pressure="1087.9" STensionRaw="72.27" Flowrate="45.88" Bubble_Time="0.06" Dead_Time="0.01275" Life_Time="0.04725" Time_Effect="0.038895303885161055" STension="72.27" />
<Point Num="30" Time="1047" Temperature="26" Pressure="1088.19" STensionRaw="72.44" Flowrate="50.4" Bubble_Time="0.055200000000000006" Dead_Time="0.012889" Life_Time="0.042332999999999996" Time_Effect="0.03607163480992856" STension="72.44" />
<Point Num="31" Time="1070" Temperature="26.1" Pressure="1089.96" STensionRaw="72.45" Flowrate="53.04" Bubble_Time="0.053200000000000004" Dead_Time="0.01275" Life_Time="0.04045" Time_Effect="0.034549201360419106" STension="72.45" />
<Point Num="32" Time="1106" Temperature="26.1" Pressure="1093.38" STensionRaw="72.85" Flowrate="60.9" Bubble_Time="0.0453" Dead_Time="0.012591" Life_Time="0.032727" Time_Effect="0.032727" STension="72.85" />
<Point Num="33" Time="1126" Temperature="26.1" Pressure="1095.1" STensionRaw="72.81" Flowrate="60.63" Bubble_Time="0.046200000000000005" Dead_Time="0.012773" Life_Time="0.033455" Time_Effect="0.033455" STension="72.81" />
<Point Num="34" Time="1147" Temperature="26.1" Pressure="1094.65" STensionRaw="72.83" Flowrate="62.03" Bubble_Time="0.0436" Dead_Time="0.012364" Life_Time="0.031227" Time_Effect="0.031227" STension="72.83" />
<Point Num="35" Time="1169" Temperature="26.1" Pressure="1098.65" STensionRaw="73.11" Flowrate="66.62" Bubble_Time="0.0407" Dead_Time="0.012166999999999999" Life_Time="0.028542" Time_Effect="0.028542" STension="73.11" />
<Point Num="36" Time="1189" Temperature="26.1" Pressure="1099.85" STensionRaw="73.2" Flowrate="68.48" Bubble_Time="0.0396" Dead_Time="0.012154" Life_Time="0.027462" Time_Effect="0.027462" STension="73.2" />
<Point Num="37" Time="1211" Temperature="26.1" Pressure="1102.91" STensionRaw="73.4" Flowrate="73.33" Bubble_Time="0.037" Dead_Time="0.011962" Life_Time="0.025077000000000002" Time_Effect="0.025077000000000002" STension="73.4" />
<Point Num="38" Time="1234" Temperature="26.1" Pressure="1104.34" STensionRaw="73.56" Flowrate="76.54" Bubble_Time="0.0356" Dead_Time="0.012143000000000001" Life_Time="0.023464" Time_Effect="0.023464" STension="73.56" />
<Point Num="39" Time="1256" Temperature="26.1" Pressure="1106.28" STensionRaw="73.62" Flowrate="77.87" Bubble_Time="0.0349" Dead_Time="0.011893" Life_Time="0.022964" Time_Effect="0.022964" STension="73.62" />
<Point Num="40" Time="1280" Temperature="26.1" Pressure="1110.77" STensionRaw="73.83" Flowrate="81.38" Bubble_Time="0.033299999999999996" Dead_Time="0.012" Life_Time="0.021332999999999998" Time_Effect="0.021332999999999998" STension="73.83" />
<Point Num="41" Time="1303" Temperature="26.1" Pressure="1110.02" STensionRaw="73.9" Flowrate="82.79" Bubble_Time="0.032799999999999996" Dead_Time="0.012033" Life_Time="0.020733" Time_Effect="0.020733" STension="73.9" />
<Point Num="42" Time="1330" Temperature="26.1" Pressure="1116.4" STensionRaw="74.26" Flowrate="88.57" Bubble_Time="0.0304" Dead_Time="0.011719" Life_Time="0.018687000000000002" Time_Effect="0.018687000000000002" STension="74.26" />
<Point Num="43" Time="1354" Temperature="26.1" Pressure="1115.18" STensionRaw="74.29" Flowrate="90.31" Bubble_Time="0.03" Dead_Time="0.01175" Life_Time="0.018281" Time_Effect="0.018281" STension="74.29" />
<Point Num="44" Time="1382" Temperature="26.1" Pressure="1118.42" STensionRaw="74.49" Flowrate="93.89" Bubble_Time="0.0287" Dead_Time="0.011734999999999999" Life_Time="0.016971" Time_Effect="0.016971" STension="74.49" />
<Point Num="45" Time="1412" Temperature="26.1" Pressure="1120.61" STensionRaw="74.59" Flowrate="95.52" Bubble_Time="0.0281" Dead_Time="0.011471" Life_Time="0.016647" Time_Effect="0.016647" STension="74.59" />
<Point Num="46" Time="1442" Temperature="26.1" Pressure="1125.2" STensionRaw="74.78" Flowrate="99.61" Bubble_Time="0.027399999999999997" Dead_Time="0.011529" Life_Time="0.015912000000000003" Time_Effect="0.015912000000000003" STension="74.78" />
<Point Num="47" Time="1472" Temperature="26.1" Pressure="1125.23" STensionRaw="74.92" Flowrate="101.71" Bubble_Time="0.0268" Dead_Time="0.0115" Life_Time="0.015278" Time_Effect="0.015278" STension="74.92" />
<Point Num="48" Time="1504" Temperature="26.1" Pressure="1129.67" STensionRaw="75.21" Flowrate="107.92" Bubble_Time="0.0251" Dead_Time="0.011474" Life_Time="0.013579" Time_Effect="0.013579" STension="75.21" />
<Point Num="49" Time="1537" Temperature="26.1" Pressure="1134.52" STensionRaw="75.57" Flowrate="116.74" Bubble_Time="0.0233" Dead_Time="0.011381" Life_Time="0.011904999999999999" Time_Effect="0.011904999999999999" STension="75.57" />
<Point Num="50" Time="1574" Temperature="26.1" Pressure="1138.38" STensionRaw="75.83" Flowrate="123.52" Bubble_Time="0.0218" Dead_Time="0.011068" Life_Time="0.010773" Time_Effect="0.010773" STension="75.83" />
<Point Num="51" Time="1611" Temperature="26.1" Pressure="1144.06" STensionRaw="76.14" Flowrate="131.67" Bubble_Time="0.0201" Dead_Time="0.010938" Life_Time="0.009167" Time_Effect="0.009167" STension="76.14" />
<Point Num="52" Time="1650" Temperature="26.1" Pressure="1166.63" STensionRaw="76.52" Flowrate="138.12" Bubble_Time="0.019" Dead_Time="0.010567" Life_Time="0.0084000000000000012" Time_Effect="0.0084000000000000012" STension="76.52" />
<Point Num="53" Time="1690" Temperature="26.2" Pressure="1150.26" STensionRaw="76.73" Flowrate="144.76" Bubble_Time="0.0177" Dead_Time="0.009375" Life_Time="0.008333" Time_Effect="0.008333" STension="76.73" />
<Point Num="54" Time="1731" Temperature="26.2" Pressure="1156.2" STensionRaw="77.11" Flowrate="152.67" Bubble_Time="0.016399999999999998" Dead_Time="0.008567" Life_Time="0.007833" Time_Effect="0.007833" STension="77.11" />
<Point Num="55" Time="1775" Temperature="26.2" Pressure="1164.08" STensionRaw="77.6" Flowrate="161.42" Bubble_Time="0.0158" Dead_Time="0.0077729999999999995" Life_Time="0.008045" Time_Effect="0.008045" STension="77.6" />
<Point Num="56" Time="1824" Temperature="26.2" Pressure="1189.5" STensionRaw="77.92" Flowrate="171.39" Bubble_Time="0.0149" Dead_Time="0.006729" Life_Time="0.008125" Time_Effect="0.008125" STension="77.92" />
<Point Num="57" Time="1881" Temperature="26.2" Pressure="1186.45" STensionRaw="78.22" Flowrate="178.17" Bubble_Time="0.0146" Dead_Time="0.0066050000000000006" Life_Time="0.008026" Time_Effect="0.008026" STension="78.22" />
<Point Num="58" Time="1927" Temperature="26.2" Pressure="1200.18" STensionRaw="82.01" Flowrate="188.95" Bubble_Time="0.0255" Dead_Time="0.007" Life_Time="0.0185" Time_Effect="0.0185" STension="82.01" />
<Point Num="59" Time="1975" Temperature="26.2" Pressure="1239.06" STensionRaw="79.58" Flowrate="199.98" Bubble_Time="0.013800000000000002" Dead_Time="0.005295" Life_Time="0.0085" Time_Effect="0.0085" STension="79.58" />
<Point Num="60" Time="2020" Temperature="26.2" Pressure="1229.91" STensionRaw="82.33" Flowrate="211.83" Bubble_Time="0.0145" Dead_Time="0.004" Life_Time="0.0105" Time_Effect="0.0105" STension="82.33" />
<Point Num="61" Time="2064" Temperature="26.2" Pressure="1279.47" STensionRaw="81.82" Flowrate="223.26" Bubble_Time="0.0128" Dead_Time="0.004714" Life_Time="0.008071" Time_Effect="0.008071" STension="81.82" />
<Point Num="62" Time="2108" Temperature="26.1" Pressure="1290.15" STensionRaw="85.52" Flowrate="234.95" Bubble_Time="0.02" Dead_Time="0.0095" Life_Time="0.0105" Time_Effect="0.0105" STension="85.52" />
<Point Num="63" Time="2152" Temperature="26.2" Pressure="1311.88" STensionRaw="86.84" Flowrate="247.99" Bubble_Time="0.0184" Dead_Time="0.008265" Life_Time="0.010147" Time_Effect="0.010147" STension="86.84" />
<Point Num="64" Time="2193" Temperature="26.1" Pressure="1378.6" STensionRaw="89.52" Flowrate="260.45" Bubble_Time="0.016300000000000002" Dead_Time="0.007111" Life_Time="0.009167" Time_Effect="0.009167" STension="89.52" />
<Point Num="65" Time="2237" Temperature="26.1" Pressure="1384.7" STensionRaw="91.71" Flowrate="268.9" Bubble_Time="0.0174" Dead_Time="0.0096110000000000015" Life_Time="0.007833" Time_Effect="0.007833" STension="91.71" />
<Point Num="66" Time="2248" Temperature="26.1" Pressure="1409.1" STensionRaw="94.16" Flowrate="281.65" Bubble_Time="0.022600000000000002" Dead_Time="0.012875" Life_Time="0.00975" Time_Effect="0.00975" STension="94.16" />
</Points>
</Parametres>
|
Как открыть его в Excel (не полностью к примеру, а только секции <Points> и <Parameters_of_capillary>), отформотированным, в удобочитаемом варианте, пошлите меня, сами знаете куда...за умными книгами или статьями, ну или намекните что юзать, а если пример будет "так ваще хорошо". З.Ы. по поиску на форуме не нашел, не ругайтесь, а лучче дайте ссылку на топик...заранее спасибо Добавлено через 7 минут и 30 секундmr. Duda, сорри, я не уточнил, это нада делать средствами .Net 2.0(если возможно), программа на шарпе |
Импорт XML в Excel 
Дата 18.7.2007, 15:49 (
Загрузка ...
