npoi在单元格里嵌套单元格_使用NPOI导出Excel，并在Excel指定单元格插入图片

public enumStyleXlsEnum

{

Head,

ColumnHead,

Default

}private staticIWorkbook m_workbook;private staticISheet m_sheet;private static List m_sheets = new List();private staticICellStyle m_cellStyle;private staticIDataFormat m_dataStyle;private staticIFont m_font16;private staticIFont m_font12;private staticIFont m_font;///

///导出Excel///

/// DataTable数据

/// Excel文件全路径

/// Sheet名称

/// 标题名称

///

private bool ExportExcel(DataTable dt, string saveFileName, string sheetName, stringheaderName)

{

ICellStyle cellStyle= null;try{#region 创建Excel对象

//如果Excel存在就获取IWorkbook对象，否则就重新创建

if(File.Exists(saveFileName))

{

FileStream fs= newFileStream(saveFileName, FileMode.Open, FileAccess.Read);

m_workbook= newXSSFWorkbook(fs);if (saveFileName.IndexOf(".xlsx") > 0) //2007版本

m_workbook = newXSSFWorkbook(fs);else if (saveFileName.IndexOf(".xls") > 0) //2003版本

m_workbook = newHSSFWorkbook(fs);

}else{//创建一个工作簿

m_workbook = newHSSFWorkbook();

}if (m_workbook != null)

{//获取所有SheetName

int count =m_workbook.NumberOfSheets;if (count < 1)

{

m_sheet=m_workbook.CreateSheet(sheetName);

}else{

m_sheets.Clear();for (int i = 0; i < count; i++)

{

m_sheet= m_workbook.GetSheetAt(1);

m_sheets.Add(m_sheet.SheetName);

}if(m_sheets.Contains(sheetName))

{