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?

Improve this question
6
  • 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) Commented Dec 10, 2017 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 Commented Dec 10, 2017 at 19:09
  • Show us what you have tried so far.. also there are other options to use besides InterOp Commented Dec 10, 2017 at 19:09
  • @Grantly it about 0.5 - 1 second Commented Dec 10, 2017 at 19:10
  • 1
    As @MethodMan said, show us what you have tried so far... Then more people might join in and assist Commented Dec 10, 2017 at 19:13
Related questions
4
Read and Write Excel Files C#
0
C#.Net Excel Reading and Writing
4
Reading/Writing Excel sheet real time in C#
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.