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
2 answers

How to read specific columns in an xlsb in Python

I'm trying to read spreadsheets in an xlsb file in python and I've used to code below to do so. I found the code in stack overflow and I'm sure that it reads every single column in a row of a spreadsheet and appends it to a dataframe. How can I…
gvak6421
  • 1
  • 1
  • 2
0
votes
0 answers

importing xlsb into R

I downloaded a bunch of xlsb files from a public database. Each file is about 60MB. How can I import these files into R without having access to Microsoft Excel? I tried opening them with LibreOffice and converting them from the command line…
Garbellini Nadia
  • 1
  • 1
0
votes
0 answers

XLSB won't save changes to Macros

I have been working on an .xlsb file in Office Excel 2016. I have developed Macros within the VBA project and it has worked fine (up to v25 of the file) with over 3 months of work. Now I need to make some adjustments to the VBA Macros. When I save…
Sercho
  • 305
  • 2
  • 9
0
votes
0 answers

Error at importing xlsb file into R using excel.link

I am using excel.link package to read a xlsb excel file, but I am receiving a error. The code: library(excel.link) D = xl.read.file("filename.xlsb", xl.sheet = "sheet1") The error: Error in COMCreate("Excel.Application", existing = FALSE) : …
Rodrigo de Sá
  • 1
0
votes
0 answers

vba to save xltm file as xlsb file

I have a script which opens an external file to execute a script and after finishing the script, it saves as an xlsb file. The code worked perfectly for saving from xlsb file to xlsb file. But because I want to have some security for the original…
DutchArjo
  • 319
  • 3
  • 8
  • 29
0
votes
2 answers

Oracle XML Report File Size Issue

The xml report generates a huge file (xls) of arounf 800 MB- 1 GB. The system hangs when trying to open the file. Tried opening a 400 MB xls file and saved it as xlsb which reduced the file size to 4.5 MB. Is there a way to generate the output in…
little_amb
  • 84
  • 5
0
votes
1 answer

How to export data to XLSB file in PHP using shared server

I am using shared server i have a cpanel access but not finding any way to implement. i'm getting this error but can't found any solution for shared server. PHP Fatal error: Class 'COM' not found Below code php file code: //…
Jaydip Patel
  • 1
  • 2
0
votes
1 answer

Python XLSB to CSV conversion data types

I've been working on creating a script which converts Excel files into csv for further processing in some of our tools. For xls, xlsx and xlsm i've found solutions in opening the file as text object or using pandas. When encountering xlsb files i…
Gamb
  • 11
  • 6
0
votes
1 answer

How can i get merge cell info from xlsb

I use POI to read xlsb file. But i can't get the merge cell info. I use the module in this page. Please review below source code file…
BigEggs
  • 29
  • 3
0
votes
1 answer

Reading XLSB file - Apache POI

I have referred all post in stack overflow related to reading XLSB file using apache POI. I tried many ways to read XLSB file using available links/example mentioned in post. But I am ended up in issues. I am using latest Apache POI 3.17 and used…
vmk
  • 9
  • 1
  • 5
0
votes
0 answers

Disabling workbookopen Event for XLSB file

I have the following issue: I created an Excel sheet in XLSB format. To protect that sheet, password generated by performing some operations on present month and year which would be a numeric value. Used input box to get a password from the user in…
parikshit verma
  • 1
  • 1
0
votes
1 answer

reading XLSB from apache poi

I've read it stated on multiple SO questions that Apache POI 3.16-beta3 has read-only support for xlsb files. I am using poi 3.17 and cannot find any documentation or examples of this feature. The best I can find is an example of extracting raw…
mebassett
  • 111
  • 5
0
votes
1 answer

How to convert XLSB files to XLSX or CSV with a script in macOS? I've tried R and JavaScript without success?

I've tried R and a JavaScript library j without success. I saw a way to do it with libreoffice CLI, so should I try with bash? With j I did: j file.xlsb --xlsx --output file.xlsx
forkfork
  • 415
  • 6
  • 22
0
votes
1 answer

C# dataTable/Html to xls When export the file format changes to xlsb how to prevent this?

C# dataTable/Html to xls When export and then opened by Excel and using the save and send as attachments the file format changes to xlsb how to prevent this? My code is similar to the working exemple in this links Export HTML Table to Excel using…
Mozy
  • 1
0
votes
1 answer

Code not working as `Add-In or Personal XLSB` [The same code works fine in workbook where it was created]

Below code is working fine and doing what I want to do. But when I use it as Add-In to run on all other workbooks it says subscript out of range. There may be object related confusion or the add-in gets confused which workbook to refer. I'm new to…
Ashwendra
  • 23
  • 5
1 2 3 4 5
6
7