how to use one file in a few threads

I have applicat开发者_如何学JAVAion where I'm using a tabPage controls. In each of this controls I read data from the excel file and then analyze the data in separate threads. How make to a few threads can read data from one excel file?

read data into memory and synchronize access from different threads by mutex (probably CriticalSection in your case)

Here are links to some samples:

Win API, for C and C++, EnterCriticalSection

Also, in C#, nice threading article

Assuming you are using the COM interface to Excel, and you are working on a single workbook, you can only read/write from/to of Excel from a single thread.

You will have to read the data in the memory. This data in the record format could be put up in a Queue where threads can pick up tasks. You may want to look at the java.util.concurrent package in Java.