Leonid Maliutin
Leonid Maliutin
> I wrote a simple programm (ExcelApiPerformanceTests) to compare both ways of excel access. `Range` class contains functionality to work with the array and give the possibility to avoid `for`...
For example: ```VB.NET For colIdx As Integer = 1 To cols For rowIdx As Integer = 1 To rows newInputSheet.Cells(colIdx, rowIdx).Value = inputSheet.Cells(colIdx, rowIdx).Value newInputSheet.Cells(colIdx, rowIdx).FormulaLocal = inputSheet.Cells(colIdx, rowIdx).FormulaLocal Next...
> `Dim valueArray(,) As Object = usedRange.Value2()` In this case, you should allocate an additional part of the memory. It is often the situation when a user has Excel x86,...
@ErrCode You did not implement one of the main points of NetOffice. You did not implement `using`, especially for range objects. See my example.