CODEWITHSUNDEEP
vb.netepplusepplus-4
Eddy Jawed
Eddy Jawed

Reputation: 457

Can EPPLUS read sections of Excel worksheets?

I use the following code to read in an excel file creating a package:

Public _package As ExcelPackage = Nothing

  Dim flInfo As New FileInfo(FILENAME)
  _package = New ExcelPackage(flInfo) 'load the excel file

This code is great when I want to load an entire file, but sometimes whether due to my local hardware issues or limitations with Epplus itself, if my file size exceeds 100MB then the import process crashes.

Therefore is there a way of loading part of an excel file into an EPPLUS package, in fact is it possible to pick and select certain portions of the Excel file?

Many thanks

Upvotes: 0

Views: 1167

Answers (1)

Ernie S
Ernie S

Reputation: 14250

How many rows and columns of data do you have? EPPlus has trouble when the file gets too big. Version 4 improved it much but did not solve it. Unfortunately, there is no great work around:

EPPlus, handling big ExcelWorksheet

Upvotes: 1

Related Questions