Guys, I've always believed that DataTable would consume more memory than a generic List. I am testing loading a DataTable and loading a List from a SQL Server query. In this case, the DataTable is consuming less memory. I'm getting the top 2000 rows and there are 134 fields per row. One binary field and the rest are standard varchar, in...
Hello, I'm trying to update the information of a listObject hosted in a Workbook created by an Excel Addin (example Code1) with an commandline application. I've tried creating an instance of Excel and accessing at all the listObjects but GetVstoObject always returns null objects. I think is a security problem, but I don't know how to r...
I'm probably missing something simple, but ListRows.Add is giving me grief. Here's the function: Sub addEmployee(employeeName As String, tableToAddTo As ListObject) Dim newRow As ListRow Set newRow = tableToAddTo.ListRows.Add() newRow.Range.Cells(1, 1).Value = employeeName tableToAddTo.Sort.Apply End Sub In most cases, t...