title: What is the best and fastest way to write into Excel file using C#?
body: <p>I am trying to write into excel file using OLEDB (without automation).
  I have around 500 rows of data which I get from some other application and then write into Excel file one by one using 'INSERT INTO..' Query.
  I am sure that there is no delay in reading data from the other application. I checked that.
  The total time taken to write into the excel file for 500 rows in around 3 minutes.
  This is too much. This is definitely because of the file write operation.</p>
  
  <p>What would be the best way to make this fast?
  Should I use some other technique for writing?
  Should I try a technique with automation?</p>
  
  <p><a href="http://support.microsoft.com/kb/306023" rel="noreferrer">http://support.microsoft.com/kb/306023</a>
  This link show many techniques, but not sure which one to use.</p>