Excel VBA txt转excel 数据汇总与统计

Device Id Operator Recipe lm-20130930-Sb2Se3 SCs - lm-20130930-Sb2Se3 lm-20130930-lm-20130930-Sb2Se3 lm-20130930-Sb2Se3 SCs - 15.3 Unknown zhongjie.IV Sample Area Irradiance Pre sweep delay Bias Direction Max Reverse Bias Max Forward Bias Num Sweep Points Dwell Time Current Limit PVIV 10A I-AMP Average Dark Current Rshunt V-Lo Rshunt V-Hi 0.400000 1.0000 0.5000 0 -0.5000 0.8000 1000 30 60 0 1 0 -0.6000 0.6000 Voc V Isc A Jsc mA/cm2 Imax A Vmax V Pmax mW Fill Factor Efficiency R at Voc R at Isc Power W RShunt ohms Cell Temp start Cell Temp end Exposure Time Date 0.29638740 0.00331665 8.29162214 0.00167174 0.14516637 0.24268095 24.6875 0.6067 95.086646 93.160 0.00048768 NaN 17.988 18.033 50.362 21:12:46 10/02/2013 Vmeas Imeas 0.80000000 -0.00821256 0.79740000 -0.00816712 0.79480000 -0.00811442 0.79220000 -0.00805961 0.78960000 -0.00800174 0.78695000 -0.00794201 0.78435000 -0.00788077 0.78175000 -0.00781962 0.77915000 -0.00775798 0.77655000 -0.00769664 0.77395000 -0.00763438 0.77135000 -0.00757106 0.76875000 -0.00750838 0.76615000 -0.00744565 0.76355000 -0.00738424 0.76090000 -0.00732106 0.75830000 -0.00725856 0.75570000 -0.00719677 0.75310000 -0.00713435 0.75050000 -0.00707193 0.74790000 -0.00701098 0.74530000 -0.00694894 0.74270000 -0.00688660 0.74010000 -0.00682524 0.73750000 -0.00676390 0.73485000 -0.00670143 0.73225000 -0.00664158 0.72965000 -0.00658065 0.72705000 -0.00651960 0.72445000 -0.00646030 0.72185000 -0.00639981 0.71925000 -0.00634001 0.71665000 -0.00628125 0.71405000 -0.00622207 0.71140000 -0.00616237 0.70880000 -0.00610373 0.70620000 -0.00604505 0.70360000 -0.00598601 0.70100000 -0.00592890 0.69840000 -0.00587033 0.69580000 -0.00581275 0.69320000 -0.00575624 0.69060000 -0.00569816 0.68800000 -0.00564137 0.68535000 -0.00558337 0.68275000 -0.00552664 0.68015000 -0.00547101 0.67755000 -0.00541549 0.67495000 -0.00535960 0.67235000 -0.00530359 0.66975000 -0.00524972 0.66715000 -0.00519559 0.66455000 -0.00514053 0.66190000 -0.00508590 0.65930000 -0.00503143 0.65670000 -0.00497887 0.65410000 -0.00492539 0.65150000 -0.00487140 0.64890000 -0.00481956 0.64630000 -0.00476712 0.64370000 -0.00471513 0.64110000 -0.00466356 0.63850000 -0.00461231 0.63585000 -0.00456073 0.63325000 -0.00450913 0.63065000 -0.00445767 0.62805000 -0.00440761 0.62545000 -0.00435818 0.62285000 -0.00430802 0.62025000 -0.00425790 0.61765000 -0.00420926 0.61505000 -0.00415937 0.61245000 -0.00411115 0.60980000 -0.00406275 0.60720000 -0.00401453 0.60460000 -0.00396718 0.60200000 -0.00391989 0.59940000 -0.00387315 0.59680000 -0.00382644 0.59420000 -0.00377970 0.59160000 -0.00373343 0.58900000 -0.00368706 0.58635000 -0.00364028 0.58375000 -0.00359506 0.58115000 -0.00355071 0.57855000 -0.00350654 0.57595000 -0.00346195 0.57335000 -0.00341760 0.57075000 -0.00337382 0.56815000 -0.00332985 0.56555000 -0.00328763 0.56295000 -0.00324455 0.56030000 -0.00320106 0.55770000 -0.00315867 0.55510000 -0.00311657 0.55250000 -0.00307492 0.54990000 -0.00303395 0.54730000 -0.00299317 0.54470000 -0.00295239 0.54210000 -0.00291256 0.53950000 -0.00287205 0.53685000 -0.00283138 0.53425000 -0.00279163 0.53165000 -0.00275252 0.52905000 -0.00271412 0.52645000 -0.00267548 0.52385000 -0.00263743 0.52125000 -0.00259989 0.51865000 -0.00256172 0.51605000 -0.00252435 0.51345000 -0.00248717 0.51080000 -0.00244971 0.50820000 -0.00241319 0.50560000 -0.00237747 0.50300000 -0.00234094 0.50040000 -0.00230528 0.49780000 -0.00226968 0.49520000 -0.00223471 0.49260000 -0.00219919 0.49000000 -0.00216471 0.48740000 -0.00213013 0.48475000 -0.00209573 0.48215000 -0.00206194 0.47955000 -0.00202846 0.47695000 -0.00199493 0.47435000 -0.00196159 0.47175000 -0.00192889 0.46915000 -0.00189583 0.46655000 -0.00186332 0.46395000 -0.00183101 0.46130000 -0.00179887 0.45870000 -0.00176690 0.45610000 -0.00173544 0.45350000 -0.00170451 0.45090000 -0.00167326 0.44830000 -0.00164219 0.44570000 -0.00161168 0.44310000 -0.00158089 0.44050000 -0.00155018 0.43790000 -0.00152012 0.43525000 -0.00148892 0.43265000 -0.00145913 0.43005000 -0.00142963 0.42745000 -0.00139997 0.42485000 -0.00137040 0.42225000 -0.00134121 0.41965000 -0.00131173 0.41705000 -0.00128325 0.41445000 -0.00125442 0.41185000 -0.00122521 0.40920000 -0.00119600 0.40660000 -0.00116719 0.40400000 -0.00113875 0.40140000 -0.00111042 0.39880000 -0.00108245 0.39620000 -0.00105444 0.39360000 -0.00102732 0.39100000 -0.00100016 0.38840000 -0.00097041 0.38575000 -0.00094215 0.38315000 -0.00091466 0.38055000 -0.00088643 0.37795000 -0.00085924 0.37535000 -0.00083148 0.37275000 -0.00080447 0.37015000 -0.00077664 0.36755000 -0.00074988 0.36495000 -0.00072182 0.36235000 -0.00069673 0.35970000 -0.00066872 0.35710000 -0.00064028 0.35450000 -0.00061104 0.35190000 -0.00058384 0.34930000 -0.00055639 0.34670000 -0.00052925 0.34410000 -0.00050189 0.34150000 -0.00047426 0.33890000 -0.00044754 0.33625000 -0.00041939 0.33365000 -0.00039202 0.33105000 -0.00036489 0.32845000 -0.00033710 0.32585000 -0.00031015 0.32325000 -0.00028241 0.32065000 -0.00025505 0.31805000 -0.00022734 0.31545000 -0.00020005 0.31285000 -0.00017246 0.31020000 -0.00014513 0.30760000 -0.00011746 0.30500000 -0.00009024 0.30240000 -0.00006261 0.29980000 -0.00003523 0.29720000 -0.00000858 0.29460000 0.00001859 0.29200000 0.00004673 0.28940000 0.00007449 0.28680000 0.00010080 0.28415000 0.00012651 0.28155000 0.00015259 0.27895000 0.00017894 0.27635000 0.00020783 0.27375000 0.00023597 0.27115000 0.00027031 0.26855000 0.00029850 0.26595000 0.00032670 0.26335000 0.00035451 0.26070000 0.00038396 0.25810000 0.00041159 0.25550000 0.00044055 0.25290000 0.00046905 0.25030000 0.00049729 0.24770000 0.00052617 0.24510000 0.00055474 0.24250000 0.00058332 0.23990000 0.00061159 0.23730000 0.00064052 0.23465000 0.00066917 0.23205000 0.00069818 0.22945000 0.00072698 0.22685000 0.00075659 0.22425000 0.00078515 0.22165000 0.00081390 0.21905000 0.00084269 0.21645000 0.00087001 0.21385000 0.00090083 0.21120000 0.00092981 0.20860000 0.00095910 0.20600000 0.00098891 0.20340000 0.00101826 0.20080000 0.00104744 0.19820000 0.00107475 0.19560000 0.00110321 0.19300000 0.00113283 0.19040000 0.00116270 0.18780000 0.00119161 0.18515000 0.00122193 0.18255000 0.00125161 0.17995000 0.00128120 0.17735000 0.00131020 0.17475000 0.00133941 0.17215000 0.00136912 0.16955000 0.00139849 0.16695000 0.00142817 0.16435000 0.00145721 0.16175000 0.00148729 0.15910000 0.00151337 0.15650000 0.00154262 0.15390000 0.00157092 0.15130000 0.00160054 0.14870000 0.00162886 0.14610000 0.00165485 0.14350000 0.00168922 0.14090000 0.00172534 0.13830000 0.00175588 0.13565000 0.00178639 0.13305000 0.00181510 0.13045000 0.00184330 0.12785000 0.00187330 0.12525000 0.00190380 0.12265000 0.00193358 0.12005000 0.00196259 0.11745000 0.00199139 0.11485000 0.00202289 0.11225000 0.00204804 0.10960000 0.00207105 0.10700000 0.00209336 0.10440000 0.00212099 0.10180000 0.00214845 0.09920000 0.00219146 0.09660000 0.00222332 0.09400000 0.00225882 0.09140000 0.00229046 0.08880000 0.00231990 0.08615000 0.00235051 0.08355000 0.00238083 0.08095000 0.00240985 0.07835000 0.00243947 0.07575000 0.00246792 0.07315000 0.00249707 0.07055000 0.00252612 0.06795000 0.00255515 0.06535000 0.00258521 0.06275000 0.00261456 0.06010000 0.00264467 0.05750000 0.00267406 0.05490000 0.00270316 0.05230000 0.00273236 0.04970000 0.00276083 0.04710000 0.00279052 0.04450000 0.00281970 0.04190000 0.00284878 0.03930000 0.00286706 0.03670000 0.00289460 0.03405000 0.00293620 0.03145000 0.00296517 0.02885000 0.00299434 0.02625000 0.00302276 0.02365000 0.00305136 0.02105000 0.00308043 0.01845000 0.00310825 0.01585000 0.00313679 0.01325000 0.00316492 0.01060000 0.00319322 0.00800000 0.00322437 0.00540000 0.00325389 0.00280000 0.00328349