HSSFWorkbook workbook = null;
MemoryStream ms = null;
ISheet unionSheet = null;
HSSFRow headerRow = null;
string templetFileName = Application.StartupPath + @"\\Imxx\xx.xls";
FileStream file = new FileStream(templetFileName, FileMode.Open, FileAccess.Read);
workbook = new HSSFWorkbook(file);
try
{
ms = new MemoryStream();
unionSheet = workbook.GetSheet("Sheet1");
int Row = 2;
foreach (DataGridViewRow row1 in myDataGridView1.Rows)
{
if (row1.Cells["xxx"].Value != null && !string.IsNullOrEmpty(row1.Cells["xxx"].Value.ToString().Trim()))
{
if (Employeesdt != null)
{
Row[] ydr = (Row[])Employeesdt.Select("xxx=" + Convert.ToInt32(row1.Cells["xxx"].Value).ToString());
if (ydr != null && ydr.Length > 0)
{
unionSheet.GetRow(Row).GetCell(2).SetCellValue(ydr[0].xxx.ToString());
}
}
Row++;
}
workbook.Write(ms);
ms.Flush();
if (this.saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
using (FileStream fs = new FileStream(this.saveFileDialog1.FileName, FileMode.OpenOrCreate))
{
ms.WriteTo(fs);
ms.Close();
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
ms.Close();
unionSheet = null;
headerRow = null;
workbook = null;
}