Stack Overflow
Stack Overflow

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
0
votes
0 answers

Handling datetime column In pandas

I want to read xlsb file in pandas. and I have 3 datetime column 1st column format is (2021-5-31 01:20:23 ) 2nd column format (total time) is ( 01:20:23 ) 3st column format is ( 01:20:23 am ) but when I am reading the file I am getting column…
San
  • 39
  • 6
0
votes
1 answer

Pandas - concatanation multiple excel files with different names but the same data type

I have about 50 excel sheet with .'xlsb' extension. I'd like to concatanate a specific worksheet into pandas DataFrame (all worksheets names are the same). The problem I have is that the names of columns are not exactly the same in each worksheet. I…
Calle
  • 151
  • 1
  • 7
0
votes
2 answers

Can I save an Excel Workbook as a binary file using R?

In R I am trying to save an Excel workbook as a binary worksheet (.xlsb) instead of the standard (.xlsx or .xls) method. Using packages like openxlsx or xlsx do not work because they do not convert the file into binary format. I have been digging…
CoolWhip94
  • 11
0
votes
0 answers

Loading .xlsb file through power query from share point

I have a bunch of files that are usually updated with power query from other excel files in .xlsx format. But recently they'd become too big (about 250Mb), so I decided to switch them to .xlsb. However, all querys have become extreamly slow:…
agas0077
  • 7
  • 7
0
votes
1 answer

Import worksheet list of xlsb file into R

Is there any way in R to import list or number of worksheets of xlsb excel file? I know that there is similar function for xlsx (excel_sheets) but it doesn't work for xlsb.
Anita
  • 1
0
votes
2 answers

Python Pandas: Input Authorized Excel File into Pandas

I am trying to get data from .xlsb file in an authorized website. But it comes out with error message: 'HTTP Error 401: Unauthorized'. What should I do to authorize so that the data comes out in pandas table in Python? Here the code that I tried so…
Mohamad Nor Hakkim Nor Azlan
  • 1
0
votes
0 answers

Read Excel File with .xlsb extension in vb.net

I need to open and read a binary Excel file with the .xlsb format just to read a few cells from 3 different sheets. I tried this way that I usually use for .xlsx but it is not working on Using workBook As New XLWorkbook(filePath). What is the best…
Bruno Gomes
  • 93
  • 1
  • 9
0
votes
1 answer

Convert .xls to .xlsb Running PowerShell Script from Python, ERROR: "You cannot call a method on a null-valued expression"

I am attempting to run PowerShell script from python to convert .xls files to .xlsb. by looping through a list of file names. I am encountering a PowerShell error "You cannot call a method on a null-valued expression" for command 3 (i.e. cmd3), and…
mlogan914
  • 3
  • 2
0
votes
3 answers

Macro to save copy of Personal.xlsb

I want a macro to save backups of my Personal.xlsb -- Why won't this work for me? Workbooks("Personal.xlsb").SaveCopyAs "C:Users\Tom\Documents\Test.xlsb" I get runtime error 1004 saying Excel cannot access the file "C:Users\Tom\Documents\Test.xlsb"…
TommyExcels
  • 31
  • 3
0
votes
0 answers

Read a particular sheet in a xlsb file using java

I tried using XSSFBEventBasedExcelExtractor class but it reads all of the data in the sheets present. I have many sheets in Binary excel file and I want to extract one sheet. Is there a way to do that? Other approaches are welcome.
Sarthak Mohanty
  • 1
  • 1
0
votes
1 answer

Nifi processor for converting xlsb to csv

I am trying to convert the xlsb files in Nifi to csv. I am using ConvertExcelToCSVProcessor in Nifi at the moment, but it gives me error and does not work. xlsb are the excel binary files. i have googled a lot and tried to make this work, but in…
shzyincu
  • 409
  • 4
  • 21
0
votes
0 answers

Issues while reading .xlsb file in python

I am facing below issue while reading .xlsb file using pd.read_excel df = pd.read_excel('path.xlsb',engine='pyxlsb') Traceback (most recent call last): File "", line 1, in df =…
mpc
  • 25
  • 1
  • 7
0
votes
2 answers

Unable to read xlsb file using pandas

I am trying to read an xlsb file from local using pandas' read_excel but I am getting error. My code: import pandas as pd df3 = pd.read_excel('a.xlsb', engine =…
Syed Afsahul
  • 11
  • 1
  • 1
  • 6
0
votes
1 answer

How to read a specific named range from an xlsb excel file using python?

I am trying to read a specific named range to a dataframe in python. My excel file is in xlsb format. I have tried to look for it online and it seems like doing this on xlsx format is possible but haven't found anything for xlsb format.
shreyans02
  • 9
  • 4
0
votes
0 answers

How to convert an executable excel file to binary (exe to xlsb) with PowerShell?

I'm trying to get data from an executable excel file (which is an excel file compressed and wrapped into an .exe) without success using PowerShell. I can open it, but I can't get the values stored in it. I've been able to get data from binary excel…
daalgi
  • 169
  • 1
  • 14
1 2 3 4
5
6 7