's的前提是，Excel的第一行是字段名。先看这里，对于有字段名的，学会/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>=Yes；注意扩展属性=' Excel 12.0' HDR=是'用引号括起来，在c#中，引号/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>表示，这样在再次运行时就可以正常得到字段名。刚才已经乱码了。1 datasetds=new dataset()；2stringstrCon，strCmm3strCon='Provider=Microsoft。Jet . OLEDB.4.0DataSource=' workdirExtendedProperties=\ ' Excel8./span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>=是；\''
span style="color: rgba(0, 128, 0, 1)">//
"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite. /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 0, 1)"
/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br
/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span
/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)"> 4
strCmm/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">=/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">select top 1 * from [Sheet1$]/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">;
/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)"> 5 OleDbConnection oleCnn/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">=/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">new/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> OleDbConnection(strCon); /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)"> 6 OleDbCommand oleCmm/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">=/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">new/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> OleDbCommand(strCmm,oleCnn); /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)"> 7 /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">try/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)"> 8 {/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)"> 9 OleDbDataAdapter oleDa/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">=/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">new/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> OleDbDataAdapter(oleCmm); /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">10 oleDa.Fill(ds,/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">test/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">); /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">11 }/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">12 /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">catch/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">(System.Exception ex)/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">13 {/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">14 /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">string/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> error/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">=/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">ex.Message;/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">15 } /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">16 /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">for/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">(/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">int/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> i/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">=/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">0/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">;i/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"></span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">ds.Tables[/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">0/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">].Columns.Count;i/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"/span>/span>span class="xzm_is" data-txt="#2B#2B#3C"/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">)/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">17 {/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">18 listBox1.Items.Add(ds.Tables[/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">0/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)">].Columns[i]);/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 128, 1)">19 }
/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/div>
标签：
