Category: ASP.NET

27 Jan 2016 22:46

Joined:	01/02/2012
Level:	Silver
Points:	101

Points:	2

How to read xlsb format excel file in asp.net using DLL

Hai All,

May i know how to read xlsb format excel file in asp.net
Please suggest free DLL's to read xlsb format

Thanks and Regards,
A.L.Chellappan

#764311

28 Jan 2016 01:33

Joined:	15/12/2015
Level:	Gold
Points:	1308

Points:	2

Hi chellappan,

Please go through this ongoing thread on same issue:
http://www.dotnetspider.com/forum/343921-How-to-read-xlsb-file-in-c.aspx
Regards,
Shashikant Gurav
shashikantgurav22@gmail.com

#764322

28 Jan 2016 18:39

Joined:	28/04/2006
Level:	Gold
Points:	30353

Points:	2

Hai Chellappan,
The solution of this issue is already provided before in the question link 'http://www.dotnetspider.com/forum/343921-How-to-read-xlsb-file-in-c.aspx', you can go through it and if still you are not getting you can reply back to the same thread.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#764329

28 Jan 2016 22:51

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	3

Following are some tips to read the excel

1. You can use "Microsoft.Office.Interop.Excel"

2. install "PM> Install-Package LinqToExcel "
and try to access your excel as follows


using (var excelQueryFactory = new ExcelQueryFactory(filePath))
{
      var YourWorksheet = excelQueryFactory.Worksheet("YourWorksheetName").Where("Your query");
}

By Nathan
Direction is important than speed

#764334

29 Jan 2016 20:50

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	0

I think this question has already been answered in below thread
http://www.dotnetspider.com/forum/343921-How-to-read-xlsb-file-in-c.aspx
Please mark it as best answer if it resolved your issue

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

How to read xlsb format excel file in asp.net using DLL

Email subscription

About dotnetspider.com

Quick Links

General

Services