0

My task:

  • Get data from a website and write it to an Excel file with real time (0.5 - 1s use Microsoft.Office.Interop.Excel)

  • While the program write data to the Excel file, I want to open this file with (Excel or something like it) to see the data, chart...

So how can I read and write the Excel file in the same time? Or can I use the other way?

knyL
  • 27
  • 1
  • 8
  • InterOp services may not give you tight control over read and write locks on the file... It might be tricky. Or impossible. (Depending how fast you read and write etc) – Grantly Dec 10 '17 at 19:08
  • But in theory it is possible...Albeit very difficult. You might be better with Google Apps like Excel or whatever its called – Grantly Dec 10 '17 at 19:09
  • Show us what you have tried so far.. also there are other options to use besides `InterOp` – MethodMan Dec 10 '17 at 19:09
  • @Grantly it about 0.5 - 1 second – knyL Dec 10 '17 at 19:10
  • 1
    As @MethodMan said, show us what you have tried so far... Then more people might join in and assist – Grantly Dec 10 '17 at 19:13
  • Are you getting data to a DataTable or DataGridView? I have solution where it export dataGrid to a Excel using Interop and Opens it using Office Excel.. If You want i can share it with you... – Selaka Nanayakkara Dec 11 '17 at 04:46

0 Answers0