Exception as insufficient memory to continue program while reading excel by using Microsoft.Office.Interop.Excel RRS feed

  • Question

  • excel sheet has 600000 rows and 40 columns.we are reading it by object of Microsoft.Office.Interop.Excel.Rang class


    objArray=(object[,] )objRange3.Value2;

    get exception at above line  as  insufficient memory to continue program.

    please provide solution to it.

    Thursday, May 19, 2016 1:36 PM