You must Sign In to post a response.
  • Category: ASP.NET

    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
    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
    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
    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
    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]


Sign In to post your comments