Wes Aday - wrote: "As far as I can see you are not saving the excel file." And he's absolutly right!
Because you create new workbook, after writing data, save the workbook, like this:
xlWorkBook.SaveAs("C:\\Documents and Settings\\narasiman\\Desktop\\Excel\\export.xls");
You can write data in to existing file, but you need to open it before:
xlWorkBook = xlapp.Workbooks.Open("C:\\Documents and Settings\\narasiman\\Desktop\\Excel\\export.xls");
and then call method
xlWorkBook.Save;
In the
Button1_Click
procedure i don't see the part of code, where you close an Excel.
Every created workbook exists in the memory (but you can't see it). Open Task Maneger (ALT+CTRL+DEL), find Excel application and choose "Go to" or "Kill process".