如何获取EXCEL第一个表名
0
悬赏园豆：50
[已解决问题]
解决于 2010-02-23 12:01
<pre><span style="color: #0000ff;">public</span><span style="color: #000000;"> ArrayList ExcelSheetName(</span><span style="color: #0000ff;">string</span><span style="color: #000000;"> filepath)<br /> {<br /> ArrayList al </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000ff;">new</span><span style="color: #000000;"> ArrayList();<br /> </span><span style="color: #0000ff;">string</span><span style="color: #000000;"> strConn;<br /> strConn </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">Provider=Microsoft.Jet.OLEDB.4.0;Data Source=</span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> filepath </span><span style="color: #000000;">+</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">;Extended Properties=\</span><span style="color: #800000;">"</span><span style="color: #000000;">Excel </span><span style="color: #800080;">8.0</span><span style="color: #000000;">;HDR</span><span style="color: #000000;">=</span><span style="color: #000000;">Yes;IMEX</span><span style="color: #000000;">=</span><span style="color: #800080;">1</span><span style="color: #000000;">;\</span><span style="color: #800000;">"</span><span style="color: #800000;">;</span><span style="color: #800000;">"</span><span style="color: #000000;">;<br /> OleDbConnection conn </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000ff;">new</span><span style="color: #000000;"> OleDbConnection(strConn);<br /> conn.Open();<br /> DataTable sheetNames </span><span style="color: #000000;">=</span><span style="color: #000000;"> conn.GetOleDbSchemaTable<br /> (System.Data.OleDb.OleDbSchemaGuid.Tables, </span><span style="color: #0000ff;">new</span><span style="color: #000000;"> </span><span style="color: #0000ff;">object</span><span style="color: #000000;">[] { </span><span style="color: #0000ff;">null</span><span style="color: #000000;">, </span><span style="color: #0000ff;">null</span><span style="color: #000000;">, </span><span style="color: #0000ff;">null</span><span style="color: #000000;">, </span><span style="color: #800000;">"</span><span style="color: #800000;">TABLE</span><span style="color: #800000;">"</span><span style="color: #000000;"> });<br /> conn.Close();<br /> </span><span style="color: #0000ff;">foreach</span><span style="color: #000000;"> (DataRow dr </span><span style="color: #0000ff;">in</span><span style="color: #000000;"> sheetNames.Rows)<br /> {<br /> al.Add(dr[</span><span style="color: #800080;">2</span><span style="color: #000000;">]);<br /> }<br /> </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> al;<br /> }<br />这个方法获取的EXCEL表名是按字母顺序排列的，如果我要获得EXCEL的第一个工作表名，怎么做？<br /> 谢谢！</span></pre>
最佳答案
0
其他回答(4)
1
楼上的无法解决楼主的问题，我也碰到过这个问题，关注！
用一楼的DLL解决了这个问题，代码如下
public ArrayList ExcelSheetNameAl(string filepath)
{
ArrayList al = new ArrayList();
AppLibrary.ReadExcel.Workbook workbook = null;
workbook = AppLibrary.ReadExcel.Workbook.getWorkbook(filepath);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (AppLibrary.ReadExcel.Sheet sheet in workbook.Sheets)
{
al.Add(sheet.Name);
}
return al;
}
al[0]就是第一个SHEETNAME
0
不错 标记
0
标记我也遇到了
0
mark