public void ModifySheetCellFormat()
{
#region 打开Excel表格模板,并初始化到NPOI对象中
IWorkbook wk = null;
string extension = System.IO.Path.GetExtension(sExcelFilename);
FileStream fs = File.OpenRead(sExcelFilename);
if (extension.Equals(".xls"))
wk = new HSSFWorkbook(fs);
else
wk = new XSSFWorkbook(fs);
fs.Close();
#endregion
//List<string> SheetNames = new List<string>();
//for (int i = 0; i < wk.NumberOfSheets; i++)
//{
// SheetNames.Add(wk.GetSheetName(i));
//}
string sheetname = SelectedSheetName.Substring(1, SelectedSheetName.Length - 3);
ISheet sheet = wk.GetSheet(shee
nopi设置excel单元格的格式汇总
最新推荐文章于 2023-04-21 17:12:40 发布