Mar 28, 2011 at 10:33 AM
Edited Mar 28, 2011 at 1:31 PM
I have a problem and need some help! :)
Do I need to have something installed on the server for EPPlus.dll to work?
I have used EPPlus when creating an application that reads data from an excel document and populates a database. The uploaded Excel document must follow a specified template. If this template is not followed the user will recieve error messages, depending on
what was wrong with the document. One of the things the template requires is for the Excel-document to have 4 worksheets. If the document uploaded by the user doesn't have 4 worksheets an error message is displayed telling the user that the document should
have 4 worksheets.
Now, when running the application on my local machine everything works fine. But after having deployed it to my server I get my error message for when the document doesn't have 4 worksheets. So it seems that when on the server EPPlus cannot see that my .xlsx
file has 4 worksheets (although it does). It does however pass the part of the code where I check if Workbook is null or not... so it seems like it understand that there is a workbook, but not that there are worksheets... workbook.Worksheets.Count is 0...
On my local machine I have Office excel installed, on my server I do not. Do I need to have something installed on the server for EPPlus.dll to work properly?