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

    How to read xlsb format excel file in using DLL

    Hai All,

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

    Thanks and Regards,
  • #764311
    Hi chellappan,

    Please go through this ongoing thread on same issue:
    Shashikant Gurav

  • #764322
    Hai Chellappan,
    The solution of this issue is already provided before in the question link '', 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.

    Pawan Awasthi(DNS MVM)
    +91 8123489140 (whatsApp), +60 14365 1476(Malaysia)

  • #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
    Please mark it as best answer if it resolved your issue

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

Sign In to post your comments