I've an OutOfmemory problem again.
Our customers are asking more and more data to export to Excel.
In the code below, the program is breaking during the loop or during the Save.
At that moment the error message 'OutOfmemory' is appearing.

Is there a way to avoid this?
Saving in between gives no solution. The memory stays increasing.
Can I avoid somehow that I need to much memory?
Also, I still need still to format some cells. This will also increase the request to memory.

I'm using :
Infragistics3.excel.v10.2 (v.10.2.20102.1004)
on a Windows XP with 2Gb of memory.

Here is the code :
------------------

Dim workbook As New Infragistics.Excel.Workbook(Infragistics.Excel.WorkbookFormat.Excel2007)
Dim wks As Infragistics.Excel.Worksheet = Nothing
Dim wksRow As Infragistics.Excel.WorksheetRow
Dim RowsCount As Integer = 0

workbook.SaveExternalLinkedValues = False
workbook.CalculationMode = Infragistics.Excel.CalculationMode.Manual
workbook.RecalculateBeforeSave = True

wks = workbook.Worksheets.Add("Sheet0")

With wks
  For rowi As Long = 1 To 150000

    RowsCount += 1
    wksRow = wks.Rows(rowi)
    With wksRow
     For i As Integer = 1 To 350
         .Cells(i).Value = "VALUE" & i & "-" & rowi
     Next
    End With
    wksRow = Nothing
  Next
End With
wks = Nothing

workbook.Save("c:\ABC11.xlsx")