Last post Jan 17, 2019 12:41 AM by callykalpana
Jan 14, 2019 08:35 AM|callykalpana|LINK
What are the best practices in reading an excel file into a web application form, say if I have the cells named and I would like to read the named cells and just for now display them.
Jan 14, 2019 10:17 AM|Mikesdotnetting|LINK
My recommendation is to use EPPlus (https://github.com/JanKallman/EPPlus) to work with your Excel file, if it is a .xlsx file (Nuget: Install-Package EPPlus). It means that nothing needs to be installed
on the server.
Jan 16, 2019 02:18 AM|Jamesbr|LINK
I used spire.xls.dll from nuget to read named ranges, it worked fine for me, hope it can help you as well.
static void Main(string args)
Workbook workbook = new Workbook();
foreach (INamedRange namedRange in workbook.NameRanges)
foreach (CellRange cell in namedRange.RefersToRange.Cells)
Jan 16, 2019 07:44 AM|Mikesdotnetting|LINK
I used spire.xls.dll
Free version is limited to 5 sheets per workbook and 200 rows per sheet.
Jan 16, 2019 08:15 AM|Jamesbr|LINK
Thanks Mike for pointing out the limitations. I learned from the website that the "5 sheets per workbook and 200 rows per sheet limitation" is for .xls format, there is no such limitation for .xlsx format, I will keep that in mind :-)
Jan 17, 2019 12:41 AM|callykalpana|LINK