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
2
votes
1 answer

how to read and write in .xlsb file using R? Or do I have to build a package to read/write .xlsb file?

I have been mainly working with .xlsb files(binary file type of xlsx) which I would like to read/write using R. Could you please let me know if there is any package that is available for this or do I need to create package on my own? RODBC did not…
vaibhav
  • 87
  • 2
  • 6
2
votes
1 answer

Import Folder of xlsb files into R

I have a folder of daily report in Excel XLSB format, now I am trying to import all files in the folder and bind into one data frame in R. I have experience with importing a folder of multiple CSV files into R, the code as…
Felix Zhao
  • 459
  • 5
  • 9
2
votes
2 answers

Reading xlsb files throws error - java poi

I'm attempting to use Apache POI and getting the following exception: Exception in thread "main" java.lang.IllegalAccessError: tried to access field org.apache.poi.xssf.eventusermodel.XSSFReader.pkg from class…
saran
  • 23
  • 1
  • 3
2
votes
2 answers

How To Read/Write/Modify Large Excel XLSB/XLSM Files? (C#)

I have a 500mb excel (.xlsb/.xlsm) file. I need a way to read/write/modify large (.xlsb/.xlsm) files using C# without loading the entire file in memory, but load it in chunks instead or at least load a single sheet at a time.
2
votes
1 answer

libreoffice --convert-to xls writes OpenDocument format instead

I use libreoffice to convert .xlsb (new Excel binary format) files to .xls (old Excel format) in order to parse them with other code that expects .xls. The following command line usually works: libreoffice --headless --invisible --convert-to xls…
Ed Avis
  • 1,350
  • 17
  • 36
1
vote
1 answer

Dealing with XSLB Excel files and download on sharepoint

I connected to SharePoint to my Cloud Environment Directory and downloaded it to my current directory. file_url = """/sites/XXXXXX/Shared%20Documents/General/new_name/train_data.xlsx""" response = File.open_binary(ctx,…
matt.aurelio
  • 381
  • 2
  • 9
1
vote
0 answers

How to save my workbook but not on my .xlsb path?

I have a macro that makes a backup. I want the macro to be available for all my workbook so I put it on my personal.xlsb file. But the backup is being save on the .xlsb path not on the path of the workbook I'm actualy working... Maybe it's the…
Max Bridge
  • 331
  • 4
  • 17
1
vote
0 answers

Is it possible for python to directly save and close an .xlsb file?

I have a .py process than opens an existing .xlsb file, reads existing data, undertakes my required analysis and writes results to various sheets on the same .xlsb. This works very effectively, however I cannot see how to add code to automate the…
JBA
  • 11
  • 2
1
vote
1 answer

Using Pandas with XLSB File

Trying to read a xlsb file to create a DF in pandas. import pandas as pd a_data = pd.ExcelFile( r'C:\\Desktop\\a.xlsb') df_data = pd.read_excel(a_data, 'Sheet1', engine='pyxlsb') print(df.head()) When I run the script I keep getting this…
caddie
  • 169
  • 1
  • 3
  • 11
1
vote
0 answers

Evaluate formulas in xlsb worksheet via python?

I have an .xlsb file that contains 5 sheets: Sheet A, Sheet B, Sheet C, Sheet D, Sheet E Sheet A, Sheet B, Sheet C and Sheet D - Contains data in every cell Sheet E: Contains formulas in every cell Note: The formulas that sheet E contains refers to…
1
vote
0 answers

Read sheet names from a xlsb file

I've been trying to read xlsb files into R. I've tried using excel.link and readxlsb packages and they do work for reading the file but i also need to read the sheet names. For a normal xlsx i would go gor GetSheets but it does not work for…
user3639100
  • 336
  • 1
  • 11
1
vote
2 answers

Convert xlsb to google sheets using google app script

I would like to convert xlsb format file into google sheets using google app script.
1
vote
0 answers

Saving standard XLSM Excel with Macros as XLSB (Excel binary)

I have a large project with Excel VBA files. Planning on moving from the xlsm file format to the xlsb (Excel binary). When I save the xlsm file as an xlsb I get warning. It displays "abc.xlsm contains features that this version of Microsoft Excel…
1
vote
1 answer

Editing Connection String in a Boatload of XLSB Documents

I have a couple hundred .xlsb files that need their connection string and command text changed in an easily programmable way. They are all buried in different folders deep in the file system. How can I use Powershell or some other program to go…
1
vote
0 answers

Converting .XLSB file to .XLSX in console with run excelcnv.exe on Windows Server 2012

I'm using following command: "C:\Program Files (x86)\Microsoft Office\Office12\excelcnv.exe" -oice C:\test\test.xlsb C:\test\test.xlsx On my workstation with Windows 10 it's work fine, but when I run it on Windows 2012 Server R2 by Administrator it…
amedv
  • 388
  • 1
  • 16