Write Array to Excel Range

by

This is an excerpt from method of mine, which converts a DataTable (the dt variable) into an array and then writes the array into a Range on a worksheet (wsh var). You can also change the topRow variable to whatever row you want the array of strings to be placed at.

object[,] arr = new object[dt.Rows.Count, dt.Columns.Count];
for (int r = 0; r < dt.Rows.Count; r++)
{
    DataRow dr = dt.Rows[r];
    for (int c = 0; c < dt.Columns.Count; c++)
    {
        arr[r, c] = dr[c];
    }
}
Excel.Range c1 = (Excel.Range)wsh.Cells[topRow, 1];
Excel.Range c2 = (Excel.Range)wsh.Cells[topRow + dt.Rows.Count - 1, dt.Columns.Count];
Excel.Range range = wsh.get_Range(c1, c2);
range.Value = arr;

Of course you do not need to use an intermediate DataTable like I did, the code excerpt is just to demonstrate how an array can be written to worksheet in single call.

More Related Contents:

  1. How do I properly clean up Excel interop objects?
  2. Excel Interop – Efficiency and performance
  3. Exception from HRESULT: 0x800A03EC Error
  4. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  5. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  6. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  7. Microsoft.Office.Interop.Excel really slow
  8. Excel interop: _Worksheet or Worksheet?
  9. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  10. C# – How to copy a single Excel worksheet from one workbook to another?
  11. Resources for learning c# Excel interop [closed]
  12. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  13. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  14. Printing Excel using Interop
  15. .Net Excel Interop Deleting a worksheet
  16. Reading excel file using OLEDB Data Provider
  17. Closing Excel Application Process in C# after Data Access
  18. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  19. What is the algorithm to convert an Excel Column Letter into its Number?
  20. How to use use late binding to get excel instance?
  21. Cell color changing in Excel using C#
  22. Passing a vector/array from unmanaged C++ to C#
  23. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  24. Windows Forms window changes its size when I create a WPF window
  25. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  26. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  27. Query excel sheet in c#
  28. Marshal C++ struct array into C#
  29. Making a C# kill event for a vb6 app?
  30. Send message to a Windows process (not its main window)

Leave a Comment