I am just trying to get some information. Currently we have a C sharp code,looking into a trading, which drags real time date of a stock and stores it into a data base as a CSV file. However I require this live data to be autopopulated into an Open excel file. i.e every time new data comes in, it should add another row into excel for me to perform historical (real time) calculations. Is this possible? If so kindly provide some information. Thanks

You must open the excel and leave it open to avoid the need to close(destroy object) and reopen (recreate) - if its real time updates you need.. try this link http://www.codeproject.com/KB/cs/WriteDataToExcel.aspx

a ready made class used to write data to excel. In this case, instantiate the class, and keep sending updates. When done, dispose of it.