Questions tagged [xlsb]

Microsoft File Extension for Excel Binary Workbook file

Excel Binary Workbook (.xlsb) files store information in binary format instead of the Open XML format of standard Excel 2007+ workbooks. Since .xlsb files are binary, they can be read from and written to much faster, making them extremely useful for very large spreadsheets. They also tend to be smaller than their or counterparts.

Other types of files may also use the .xlsb file extension.

Questions using the tag are expected to relate to programming. For example, specific questions about programmatically opening or creating .xlsb files are encouraged.

Links:

102 questions
112
votes
5 answers

When should the xlsm or xlsb formats be used?

Since Excel 2007, Microsoft has split the classical .xls format to several formats (in particular, .xlsx, .xlsm, .xlsb). I've got no problem to understand the use and purpose of .xlsx format but I am still wondering whether we should use a .xlsm or…
JMax
  • 26,109
  • 12
  • 69
  • 88
23
votes
5 answers

How to open an .xlsb file in R?

I'm trying to open an .xlsb file in R and keep getting similar errors. Any recommendations on how to solve this issue without having to download the data and save it in a different formate? read.xlsx(paste(OutputLocation,FileName, sep=""),…
user2946746
  • 1,740
  • 3
  • 21
  • 36
14
votes
7 answers

How can I convert a XLSB file to csv using python?

I have been provided with a xlsb file full of data. I want to process the data using python. I can convert it to csv using excel or open office, but I would like the whole process to be more automated. Any ideas? Update: I took a look at this…
IordanouGiannis
  • 4,149
  • 16
  • 65
  • 99
7
votes
1 answer

Pandas read_excel doesn't parse dates correctly - returns a constant date instead

I've read a .xlsb file and parsed date columns using a code below: dateparser = lambda x: pd.to_datetime(x) data = pd.read_excel(r"test.xlsb", engine="pyxlsb", parse_dates=["start_date","end_date"], …
Roberto
  • 649
  • 1
  • 8
  • 22
7
votes
5 answers

How to read data from Excel (.xlsb) Binary File Format?

I am using the POI 3.9 to read data from xlsx. But now I face an issue, the POI don't support the xlsb files, and I need to read data from xlsb programly. Does anybody know how to read data from xlsb programly? Appreciated.
Martin
  • 81
  • 1
  • 1
  • 5
6
votes
3 answers

Exception reading XLSB File Apache POI java.io.CharConversionException

Im developing a Java aplication that reads an excel xlsb file using Apache POI, but I got an exception while reading it, my code is as follows: import java.io.IOException; import java.io.InputStream; import…
Angel Zero
  • 63
  • 1
  • 1
  • 4
5
votes
1 answer

How to read XLSB file with ODBC

I have this code, which I would like to convert .xlsb file to DataTable public static class Utils { public static DataTable ImportExceltoDatatable(string filepath) { string connectionString = "Driver ={Microsoft…
Muflix
  • 6,192
  • 17
  • 77
  • 153
5
votes
2 answers

How to read xlsb files?

I am trying to read a range into a data frame from a xlsb workbook. Can I do this with the xlsx package in R? If not, does anyone know of a way to do it?
Satya
  • 51
  • 1
  • 1
  • 3
4
votes
3 answers

Is there a library for manipulating Excel .xlsb (BIFF12) files without the (slow) COM API (Interop)?

I found many Excel 2007/2010 file manipulation libraries on the web, some of them independent of MS Office's COM API. Some free, some for (lots of) cash. Most if not all support the old binary .xls (Excel 97-2003 BIFF8) format as well as the…
Aaron Thoma
  • 3,820
  • 1
  • 37
  • 34
3
votes
2 answers

Write output in xlsb file format (Excel binary file format) using pandas and pyxlsb

I've read a lot of stackoverflow and other threads where it's been mentioned how to read excel binary file. Reference: Read XLSB File in Pandas Python import pandas as pd df = pd.read_excel('path_to_file.xlsb', engine='pyxlsb') However, I can not…
3
votes
1 answer

How to convert *.xlsb to array or *.csv using php

I am trying to convert *.xlsb file into php array or *.csv file (or at least *.xls). I tried to use PHPExcel, but looks like it can not recognize what's inside this file. I noticed, that you can rename *.xlsb file into *.zip file and then unzip it…
Vittore Gravano
  • 706
  • 6
  • 22
3
votes
0 answers

Mass conversion of thousand of excel files from xlsb to xls in sub-folders

I have looked for an answer everywhere for this but couldn't find any so hopefully someone might be able to offer some assistance. I have a few thousand of excel files in a folder-subfolder structure and would like to convert them from xlsb to xls.…
2
votes
0 answers

how to write and read .xlsb file in C# without using Excel Interop

I have multiple .xlsb templates that have 5-6 sheets in them. First, 2-3 sheets are where I need to add data dynamically so that the 4th and 5th sheets can generate data based on the macro/formulas written in them. Can you guys help me out with what…
2
votes
0 answers

Xlwings reading range of floats as decimals, and truncates decimals

I am trying to read in a 2 dimensional range of values from a ".xlsb" file using xlwings. The range contains a series of formulas, that returns floats. When I read in the values, it gets read in as Decimals rather than floats. The problem is…
2
votes
3 answers

Create an *.xlsb in linux

Does anyone know how to create or export data to an xlsb file (Binary File Format) in a Linux OS from any programming language? My idea is to execute it from R, but any suggestion in Python, Perl or some other language is very appreciated.
1
2 3 4 5 6 7