Databases
StackOverflow2013
Postsdbo
POExport a C# List of Lists to Excel
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExport a C# List of Lists to Excel
    primarykey
    data
    text
    <p>Using C#, is there a direct way to export a List of Lists (i.e., <code>List&lt;List&lt;T&gt;&gt;</code>) to Excel 2003?</p> <p>I am parsing out large text files and exporting to Excel. Writing one cell at a time creates way too much overhead. I chose to use <code>List&lt;T&gt;</code> so that I would not have to worry about specifying the number of rows or columns.</p> <p>Currently, I wait until end of file, then put the contents of my <code>List&lt;List&lt;object&gt;&gt;</code> into a 2-dimensional array. Then the array can be set as the value of an Excel.Range object. It works, but it seems like I should be able to take my List of Lists, without worrying about the number of rows or columns, and just dump it into a worksheet from A1 to wherever.</p> <p>Here's a snippet of the code I'd like to replace or improve on:</p> <pre><code>object oOpt = System.Reflection.Missing.Value; //for optional arguments Excel.Application oXL = new Excel.Application(); Excel.Workbooks oWBs = oXL.Workbooks; Excel._Workbook oWB = oWBs.Add(Excel.XlWBATemplate.xlWBATWorksheet); Excel._Worksheet oSheet = (Excel._Worksheet)oWB.ActiveSheet; int numberOfRows = outputRows.Count; int numberOfColumns = int.MinValue; //outputRows is a List&lt;List&lt;object&gt;&gt; foreach (List&lt;object&gt; outputColumns in outputRows) { if (numberOfColumns &lt; outputColumns.Count) { numberOfColumns = outputColumns.Count; } } Excel.Range oRng = oSheet.get_Range("A1", oSheet.Cells[numberOfRows,numberOfColumns]); object[,] outputArray = new object[numberOfRows,numberOfColumns]; for (int row = 0; row &lt; numberOfRows; row++) { for (int col = 0; col &lt; outputRows[row].Count; col++) { outputArray[row, col] = outputRows[row][col]; } } oRng.set_Value(oOpt, outputArray); oXL.Visible = true; oXL.UserControl = true; </code></pre> <p>This works, but I'd rather use the List directly to Excel than having the intermediary step of creating an array just for the sake of Excel. Any ideas?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UScasperOne
    1. USreverendlarry
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POExport a C# List of Lists to Excel
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POExport a C# List of Lists to Excel
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POExport a C# List of Lists to Excel
      1. USmiccet
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload