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
1
vote
1 answer

Jupyter notebook can't find pyxlsb module

I'm trying to use the pyxlsb module in Jupyter Notebook but it comes up with: ModuleNotFoundError: No module named 'pyxlsb' for the line of code: from pyxlsb import open_workbook as open_xlsb Would anyone be able to tell me why, and ideally a fix…
James Salmon
  • 205
  • 3
  • 6
1
vote
1 answer

vba routine to save workbook does not have desired result

I have a workbook which is updated every 4 weeks with new data. When updated, it has to be saved with a specific name and with specific options. I already had a script which saves workbook to a new file for me so I used that script and modified…
DutchArjo
  • 319
  • 3
  • 8
  • 29
1
vote
0 answers

Parsing Binary File to JSON from Excel xlsb file in Javascript

I actually got this working once but then I lost the code to do it and haven't been able to get it working again. I am able to get the file pretty easily using a $.get(server filepath) and it gives me a bunch of crazy looking data...I've tried…
MattE
  • 1,044
  • 1
  • 14
  • 34
1
vote
1 answer

XLSB Personal Macro file Variable Error

Disclaimer: This is not my code. I took a macro from a regular xlsm file and placed it on a xslb file to have it handy for analysis. The macro works correctly in the xlsm, but encounters a variable issue on the xlsb file. ColumnToFormat identifies a…
Nahuatl_C137
  • 132
  • 1
  • 13
1
vote
1 answer

Error when changing file extension VBA

I have a VBA code that opens a .csv file, changes its name and extension and then closes it saving the changes (as a summary). The code works fine, but when I try to open the new file, I get a message that says that the file cannot be opened because…
N. Pavon
  • 821
  • 4
  • 15
  • 32
1
vote
0 answers

Read an xlsb file in R sheet wise and merge based on conditions

I have many xlsb files looks like with multiple sheets File 1 sheet 1 NA NA NA NA NA 3 NA NA A B C D 23 12 24 23 ....... File 1 sheet 2 NA NA NA NA 3 1 NA 1 NA B C A 23 12 21 ..... each file has 2 sheets, some first 2-3 rows with…
Rahul Kumar Vij
  • 21
  • 3
1
vote
1 answer

Converting XLSB to XLSX without using Microsoft.Interop.Excel

As mention in title, is there any other ways I can use to convert XLSB to XLSX without using Microsoft.Interop.Excel? I have check ExcelDataReader, EPPlus, CSharpJExcel, and NPOI and it does not support XLSB.
Pukaries Alex
  • 23
  • 1
  • 3
1
vote
0 answers

Read/Write data in Excel (XLSB) in java

Are there any libraries available for writing large amounts of data in Excel (XLSB) in java? Thanks.
Sam
  • 189
  • 2
  • 10
1
vote
0 answers

VBA Advanced Filter works in local Workbook, but not when placed in Personal.xlsb

This code works in the local Workbook perfectly, but I can not figure out how (and I tried a couple of suggestions here on S.O.F.) to get it to work in the Personal.xlsb file. Any help is much appreciated. 'This macro works locally - need to get it…
XLmatters
  • 376
  • 1
  • 16
1
vote
0 answers

how to reduce time taken in reading large .xlsb format file in R ShinyApp

I am making an Shiny App in which input is xlsb format file and output is prediction based on the model developed. Code is working fine on 22kb xlsb file. But as the file size becomes 2000kb the R server takes total 7mins to just read. Converting…
Ashita
  • 11
  • 1
1
vote
1 answer

Reading a binary file from the file system as a BLOB to use in rhino with javascript

I'm planing to use SheetJS with rhino. And sheetjs takes a binary object(BLOB if i'm correct) as it's input. So i need to read a file from the system using stranded java I/O methods and store it into a blob before passing it to sheetjs. eg :- var…
HarshaXsoad
  • 776
  • 9
  • 30
1
vote
1 answer

XLSB with SpreadsheetGear2012 - Excel cannot open the file 'test.xlsb' because the file format or file extension is not valid

I am evaluating SpreadsheetGear2012 and I want to be able to open/save all types of Excel files: .xls, .xlsx, .xlsm and .xlsb. All extensions are working fine except for .xlsb. Here is the code for creating a simple .xlsb file: …
Andrei Petrut
  • 390
  • 2
  • 15
1
vote
1 answer

C++ VCL Interrogating .xlsb Excel database

I need some help for interrogating an xlsb database (file) from a VCL C++ program; (using C++Builder XE2) mainly, i would like to query the data inside for simple viewing (its on the same machine, no networking involved), and i don't need to modify…
Acemad
  • 3,241
  • 3
  • 23
  • 29
0
votes
1 answer

Do we need to adapt the VBA excel solver to work with German excel?

I'm working on an excel tool which calls an Excel solver from VBA. This tool is used by colleagues in different countries. I'm trying to improve the old VBA code so that: it uses the range names instead of hardcode cell (so that the code will be…
stf_xa
  • 1
  • 1
0
votes
1 answer

How to save an excel file from xlsx to xlsb to make file smaller using vba and ms-access?

I currently am ingesting excel files through a button on ms-access. The issue I am facing is that the excel files are rather large (~20MB). I noticed that if I change the file format to xlsb the files are significantly smaller (~2MB). However, I am…
bmfy131
  • 41
  • 5
1 2
3
4 5 6 7