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

Reading data from .xlsb in Clojure

How can I read data from .xlsb file in Clojure? I have tried incanter.excel which uses apache.poi which doesn't support binary format. I have seen some examples of reading .xlsb in Java using ODBC but as far as I understand JDBC-ODBC bridge was…
Artem
  • 107
  • 1
  • 6
0
votes
0 answers

Personal.xlsb file not opening when excel is opened from application

I'm opening excel files from a application form. I have a personal.xlsb file that is loaded when any excel files is opened located in C:\Users\"myusername"\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xlsb. Problem is, if I open excel directly,…
user6430691
0
votes
1 answer

Why would a macro from a different workbook be inaccesible after allowing macro's?

I have an .xlsb file, which I'm running on a different computer, after defining the paths variable and dependent on its current location. I added the VBA Project of a different xlsm file to the .xlsb. And I'm trying to run a macro from Module 2 of…
0
votes
0 answers

Cell reference to non-existent sheet - can't jump to precedent

Slightly odd question, but couldn't find anything on it: I have an .xlsb file in which data is displayed by groups, which have to be selected via a drop down menu, so that only part of the entire data set is displayed at any given time. I'd like to…
Nils Gudat
  • 13,222
  • 3
  • 39
  • 60
0
votes
0 answers

Is it possible to update .xslb file format without cleaning existing data through java?

i have a .xlsb file with data in it. I need to update the file by opening and writing new data in it through java language. Is it possible to update a .xlsb file without clearing existing data ?? how to do it?
pradpalnis
  • 11
  • 3
0
votes
1 answer

ODBC driver on Unix for MS Excel?

Does anyone know whether there is an ODBC driver for Unix ,out there (free or commercial) that connects to MS Excel files? Thanks in advance, Martin
Martin
  • 81
  • 1
  • 1
  • 5
-1
votes
0 answers

Jupyter Notebook cannot read original .xlsb

my problem is that i cannot read a .xlsb File but it does work when I copy everything in a new xlsb file. What can be the problem? I think it is an excel problem? Would like it if you could help me. Thanks :) see the written text above
Marvin
  • 1
-1
votes
1 answer

How to append rows in Excel Binary Worksheet (xlsb)

I tried using openpyxl library to read and write data in excel. But later did I know that I need to manipulate an excel binary worksheet. openpyxl doesn't support xlsb. Is there any other libraries that I can use to be able to read and write data in…
Tenserflu
  • 520
  • 5
  • 20
-1
votes
1 answer

How do I get rid of decimals in binary excel sheet when reading with Python?

I am trying to read a binary Excel file, but when I do, it turns all of the integer values into floats, adding ".0" at the end of each one. I've tried moving everything to a list and just printing everything out before adding it to the list. df =…
Raj Patel
  • 11
  • 1
  • 9
-1
votes
1 answer

XLSB To CSV error through PHP

I am having trouble find the problem with the php script that supposed to convert the XLSB file to CSV. For some reason, it's throwing this parse error. I tried looking at the code but I don't understand what I did wrong. I encountered the…
-1
votes
1 answer

using MS XLSB instead of MS XLS

I need opinion on switching from MS XLS to XLSB. I have several models on MS xls file (Microsoft Excel 97-2003 Worksheet .xls) and have been using those models since many years. The xls files has lot of data, it has formula, macros, add-ins, formula…
Manya Mohan
  • 31
  • 2
  • 2
  • 8
-3
votes
1 answer

Huge excel file... any advice?

I work for a company where all our daily reporting is done off one mammoth excel xlsb spreadsheet. Throughout the month it varies is size from 500,000KB to 950,000KB It has a main data tab with maybe 800k rows, with lots of vlookups, ifs etc. …
ratherstrange
  • 117
  • 4
  • 10
1 2 3 4 5 6
7