This project has moved. For the latest updates, please go here.

Creating excel with 2D array

Apr 14, 2013 at 4:47 PM

am having a huge dataset with 96000 rows and 65 cols. currently am using excel automation to form an excel sheet and download it via application. this is working fine. Am using below code to udpate the data to excel sheet

oRange = oSheet.Range(oSheet.Cells(1, 1), oSheet.Cells(intRecordCount + 1, intColCount))

oRange.Value = strDataArray -- this is my 2d array

am forming 2d array this because, am interacting with excel only once and hence it is faster.

am facing some deployment issues, because this requires excel to be installed in deplymnet server, which we don't want to do. so am looking for alternatives.

I have few quesetions
  1. Can i use EPPlus to solve my problem? do we need to install excel to use EPPlus?
  2. is EPPlus efficient for huge dataset?
  3. can i use 2D arrays and range in EPP to update the cell contents in one single interaction?
kindly help.

Thanks in advance.