1.判断sheet是否存在
/// <summary>
/// 指定sheet是否存在,存在返回true,不存在返回false
/// </summary>
/// <param name="fileName"></param>
/// <param name="sheetName"></param>
/// <returns></returns>
private bool IsExistSheet(string filePath, string sheetName)
{
IWorkbook workbook = null;
ISheet sheet = null;
bool result = false;
if (!File.Exists(filePath))
{
return false;
}
FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
if (filePath.IndexOf(".xlsx") > 0)
{
workbook = new XSSFWorkbook(fs);
}
else if (filePath.IndexOf(".xls") > 0)
{
workbook = new HSSFWorkbook(fs);
}
for (int i = 0; i < workbook.NumberOfSheets; i++)
{
if (workbook.GetSheetName(i) == sheetName)
{
return result = true;
}
}
return result = false;
}
2.创建excel workbook
/// <summary>
/// 创建excel workbook,无sheet
/// </summary>
/// <param name="filePath"></param>
/// <returns></returns>
public bool CreateExcelWorkbook(string filePath)
{
bool result = false;
IWorkbook workbook = new XSSFWorkbook();
using (FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate))
{
workbook.Write(fs);
}
return result;<