1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| using Microsoft.Office.Interop.Excel;
using System;
class ExcelReader
{
_Application application = new Microsoft.Office.Interop.Excel.Application();
_Workbook workbook = null;
public ExcelReader(string filePath)
{
workbook = application.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
}
public bool IsExistWorkSheet(string wkSheetName)
{
Sheets worksheets = workbook.Worksheets;
for (int i = 1; i < worksheets.Count + 1; i++)
{
if (worksheets[i].Name == wkSheetName)
return true;
}
return false;
}
} |
Partager