如何使用C＃讀取Excel文件的數(shù)據(jù)？如何使用C＃讀取Excel文件？我打開(kāi)一個(gè)Excel文件進(jìn)行閱讀并將其復(fù)制到剪貼板以搜索電子郵件格式，但我不知道該怎么做。FileInfo finfo;Excel.ApplicationClass ExcelObj = new Excel.ApplicationClass();ExcelObj.Visible = false;Excel.Workbook theWorkbook;Excel.Worksheet worksheet;if (listView1.Items.Count > 0){
foreach (ListViewItem s in listView1.Items)
{
finfo = new FileInfo(s.Text);
if (finfo.Extension == ".xls" || finfo.Extension == ".xlsx" || finfo.Extension == ".xlt" || finfo.Extension == ".xlsm" || finfo.Extension == ".csv")
{
theWorkbook = ExcelObj.Workbooks.Open(s.Text, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, false, false);
for (int count = 1; count <= theWorkbook.Sheets.Count; count++)
{
worksheet = (Excel.Worksheet)theWorkbook.Worksheets.get_Item(count);
worksheet.Activate();
worksheet.Visible = false;
worksheet.UsedRange.Cells.Select();
}
}
}}
3 回答
- 3 回答
- 0 關(guān)注
- 1192 瀏覽
添加回答
舉報(bào)
0/150
提交
取消