Last post Aug 03, 2017 07:34 AM by Billy Liu
Jul 27, 2017 01:27 PM|Jyothirmayi|LINK
My requirement is to read the Excel binary file content into a data table and then process the content further. I am trying to do it using EPPlus library but it is accepting only .XLS or .XLSX files. But it is not taking .XLSB file.
Are there any such dlls where I want to re ad the content of the excel file on the PC where MSOffice is not installed and excel file is not stored in the disk. I.e. without using any Interop.Excel or Office.OLED etc. Any such dlls which are not a trial
version dlls or any code piece is highly appreciable. Please help me to resolve the issue.
Jul 27, 2017 01:55 PM|mgebhard|LINK
you asked the same question here...
Did you try the solution provided and it did not work?
Jul 28, 2017 06:43 AM|Jyothirmayi|LINK
Yes I tried that solution but I am looking for a solution where the end user PC doesn't have any Office installed or the excel file should not be saved on the physical drive just as EPPlus works.
EPPlus works fine for .XLS and .XLSX file but it is not reading .XLSB file.. Looking for any other alternative
Jul 28, 2017 09:21 AM|Billy Liu|LINK
I think you could try to use LinqToExcel to read xlsb.
You could use following command in Package Manager Console to install it:
Install-Package LinqToExcel -Version 1.11.0
And you could use codes below to read the content:
using (var excelQueryFactory = new ExcelQueryFactory(Server.MapPath("abc.xlsb")))
//access your worksheet LINQ way
var worksheet = excelQueryFactory.Worksheet("Sheet1");
Aug 02, 2017 02:39 AM|Leon Davis|LINK
You can use Spire.XLS to read .xlsb files. Spire.XLS is an independent Excel component, it enables user to perform a wide range of excel processing tasks such as create, read, write, convert and print without installing MS Office. It supports .xls, .xlsx,
.xlsb, .xlsm along with .ods file formats.
Aug 03, 2017 07:14 AM|Jyothirmayi|LINK
Thanks for showing me the alternative but I guess Spire.XLS is not a free download. It is paid I guess or we are getting free trial versions which we cannot rely on such type of dlls.
Could you please provide me any website where it is not a free trial.
Aug 03, 2017 07:34 AM|Billy Liu|LINK
Have you tried LinqToExcel? It is free.
Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites;
therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from the Internet.