title: List<custom> to Excel c#
body: <p>can anyone help me?</p>
  
  <p>I have a structure</p>
  
  <pre><code>    public struct Data
      {
  
          public string aaaAAA;          
          public string bbbBBB;          
          public string cccCCC; 
          ...
          ...
       }
  </code></pre>
  
  <p>then some code to bring in a data into a List, creaitng new list etc.</p>
  
  <p>I want to then transport this to excel which I have done like this,</p>
  
  <pre><code>        for (int r = 0; r &lt; newlist.Count; r++)
          {
              ws.Cells[row,1] = newlist[r].aaaAAA;
              ws.Cells[row,2] = newlist[r].bbbBBB;
              ws.Cells[row,3] = newlist[r].cccBBB;
          }
  </code></pre>
  
  <p>This works, but it is painfully slow. I am inputting over 12,000 rows and my structure has 85 elements (so each row has 85 columns of data).</p>
  
  <p>Can anyone help make this quicker??</p>
  
  <p>Thanks,
  Timujin</p>