private object m_strSampleFolder = "C:\\Projects\\ExcelProject";
private void btnConvertToExcel_Click(object sender, EventArgs e)
{
Excel._Workbook objBook;
Excel.Workbooks objBooks;
Excel.Sheets objSheets;
Excel._Worksheet objSheet;
Excel.Range range;
try
{
Excel.Application objApp;
objApp = new Excel.Application();
objBooks = objApp.Workbooks;
objBook = objBooks.Add(Missing.Value);
objSheets = objBook.Worksheets;
objSheet = (Excel._Worksheet)objSheets.get_Item(1);
range = objSheet.get_Range("A1", Missing.Value);
range = range.get_Resize(c1FlexGrid1.Rows.Count, c1FlexGrid1.Cols.Count);
string sql = "SELECT * FROM AccessHistory";
SqlDataAdapter DA = new SqlDataAdapter(sql, Connstr);
DataSet ds = new DataSet();
DA.Fill(ds);
string[,] tempArray = new string[c1FlexGrid1.Rows.Count, c1FlexGrid1.Cols.Count];
for (int RRow = 0; RRow < c1FlexGrid1.Rows.Count - 1; RRow++)
{
for (int RColm = 0; RColm < c1FlexGrid1.Cols.Count - 1; RColm++)
{
tempArray[RRow, RColm] = ds.Tables[0].Rows[RRow].ItemArray[RColm].ToString();
}
}
range.set_Value(System.Reflection.Missing.Value, tempArray);
object misValue = System.Reflection.Missing.Value;
objBook.SaveAs(m_strSampleFolder + "AccessHistory.xlsx", Excel.XlFileFormat.xlWorkbookDefault, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
objBook.Close(true, misValue, misValue);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
MessageBox.Show("NOw in the finally block");
Process objApp=Process.Start(m_strSampleFolder + "AccessHistory.xlsx");
}
}