Excel Interop – Efficiency and performance

by

When using C# or VB.Net to either get or set a range, figure out what the total size of the range is, and then get one large 2 dimensional object array…

//get values
object[,] objectArray = shtName.get_Range("A1:Z100").Value2;
iFace = Convert.ToInt32(objectArray[1,1]);

//set values
object[,] objectArray = new object[3,1] {{"A"}{"B"}{"C"}};
rngName.Value2 = objectArray;

Note that its important you know what datatype Excel is storing (text or numbers) as it won’t automatically do this for you when you are converting the type back from the object array. Add tests if necessary to validate the data if you can’t be sure beforehand of the type of data.

More Related Contents:

  1. How do I properly clean up Excel interop objects?
  2. Write Array to Excel Range
  3. Exception from HRESULT: 0x800A03EC Error
  4. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  5. Fastest way to interface between live (unsaved) Excel data and C# objects
  6. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  7. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  8. How to open an Excel file in C#?
  9. Microsoft.Office.Interop.Excel really slow
  10. How to reference Microsoft.Office.Interop.Excel dll?
  11. Fastest function to generate Excel column letters in C#
  12. Excel interop: _Worksheet or Worksheet?
  13. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  14. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  15. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  16. C# – How to copy a single Excel worksheet from one workbook to another?
  17. Resources for learning c# Excel interop [closed]
  18. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  19. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  20. How to know if a cell has an error in the formula in C#
  21. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  22. Excel CustomTaskPane with WebBrowser control – keyboard/focus issues
  23. How do I get an Excel range using row and column numbers in VSTO / C#?
  24. Printing Excel using Interop
  25. .Net Excel Interop Deleting a worksheet
  26. Where is likely the performance bug here? [closed]
  27. Implementing a log viewer with WPF
  28. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  29. Cell color changing in Excel using C#
  30. Detecting network connection speed and bandwidth usage in C#

Leave a Comment