Hi,

I guess either we doing the right think or there is noone out there to
answer it.
I found that my coding the fastest way to doing things. The each row
contains nearly 7-9 columns and if I reduce it to say 2-3 column per row it
writes 2 row in per second.

Unfortunetly to me that I need to use 9 column for each row. So it is normal
to me to have 1sec for per row. 9000 row means 9000s / 60 = 150 min / 60 =
2.5 Hr

Plus I need to work with data before sending in to Result Table and that
takes nearly 10-15 min. Creating a Report in 3 Hrs its okay.

For the XML you should send your data first into Data Table in VB.NET and
use that data table and insert in Excel might be faster whatever you doing
now.

- Read from XML to dtRESULTTABLE
- Work with data whatever you want / Or if you don't want to work with data
 then skip this section
- Create a new Excel sheet with using VB.NET + Excel.Interop and send the
  dtRESULTTABLE data into Excel row by row. if your output has some pre
define  
  format or as template might takes a while but, say 2 sec or  less per
row. Or if
  you just insert it in Excel starting from A1 cell then it will take 2 row
in 1 sec.

reading from XML and sending it to Excel is much faster. You should avoid to
read per xml line and insert into Excel. Read all the XML line into dataTable
and then send it to Excel.

I hope this will help you.

Rgds,
Niyazi