Member Avatar for Sajeelchaudhry

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

  • 2 Contributors
  • 1 Reply
  • 140 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by jfarrugia
Member Avatar for jfarrugia

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.