Phaniraj

Phaniraj

  • NA
  • 1
  • 0

Export data from DataSet to Microsoft Excel using windows forms

Apr 23 2007 7:51 AM
I want to Export data from DataSet to Microsoft Excel using windows forms. This is very urgent please reply if you have any idea.

I had tried the following code, But it is throwing a fatal error saying it could not able to load
excel DLL even after adding it in reference.

Excel.
ApplicationClass excel = new Excel.ApplicationClass();
Excel.Workbooks workbooks = excel.Workbooks;
Excel.
Workbook workbook = workbooks.Add(true);
excel.Cells[0,0] =
"TestData";
Excel.
Worksheet worksheet = (Excel.Worksheet)excel.ActiveSheet;
excel.Visible = true;


Answers (1)