I do not wish to enter data into Excel cell by cell. Is there any way to enter the data by using an array? Using Interop, I can do this:
object[,] data = new object[length, ColumnHeaders.Count];
...
dynamic rg = excelApp.Sheets[p].Range[excelApp.Sheets[p].Cells[top, left], excelApp.Sheets[p].Cells[bottom, right]]; rg.Value = data;
But I would like to use IG Excel, so that I do not have to have Excel installed alongside my application
Hello Travis,
Thank you for contacting Infragistics.
The functionality you described is not currently available in our Excel engine. I would recommend posting a new product idea at http://ideas.infragistics.com.
well this is very disapointing. honestly i am done submitting new ideas, it never helps me get anything done.