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

Open .xlsb with ExcelDataReader

ExcelDataReader documentation says that it can open .xlsb files. using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read)) { // Auto-detect format, supports: // - Binary Excel files (2.0-2003 format; *.xls) // - OpenXml…
Loc Dai Le
  • 1,661
  • 4
  • 35
  • 70
0
votes
1 answer

Read files in XLSB format in scala

We are trying to read an XLSB file in scala, but it does not work. We tried to read the file using spark.read.excel.load("/path/file.xlsb") It works with xlsx files but not xlsb files. Do you have a solution ? Is there any function/ command ...…
Ennar.ch
  • 659
  • 1
  • 8
  • 26
0
votes
1 answer

Date type convert error in Python (XLSB to CSV): year 2022 --> 2092

I have an XLSB file to convert into CSV in Python but the years are changed from 2022 into 2092 in the CSV file. Would like to receive your help and guidance with the issue. Thank you. test = pd.read_excel('./date_error.xlsb', engine='pyxlsb',…
Liam
  • 13
  • 3
0
votes
1 answer

Error when accessing .xlsb file using xlwings

I am building a programme to automate a process in Excel using xlwings. The files I have to access include .xlsx, .xlsb and .xlsm formats I have the following command: wb = xw.Book(r"some_directory\file1.xlsx") which runs fine. But when I run any…
Tipo33
  • 181
  • 13
0
votes
0 answers

Is it possible to generate .xlsb excel file format using NPOI in C#?

We tried with the below code and cannot able to open in Microsoft Excel. Is this the right way to generate the .xlsb file using NPOI? Please advise using (var exportdata = new MemoryStream()) { var name =…
Rajeesh-vr
  • 1
  • 1
0
votes
1 answer

In a ms-xlsb worksheet what are the undocumented 6 bytes between brtcolortab and rwsync

I'm trying to write an application to read a XLSB file. I'm using the specification here https://interoperability.blob.core.windows.net/files/MS-XLSB/%5bMS-XLSB%5d.pdf. My main objective (for now) is to read a worksheets CELLTABLE which requires me…
George
  • 86
  • 6
0
votes
1 answer

How to read .xlsb file in Azure Data Factory

I'm connected to a File System Linked Service where the .xlsb file is and I want to create a CSV file with that information. This .xlsb file has several sheets and I only need one. Is it possible to read .xlsb files and select the sheet that we want…
Dory
  • 19
  • 5
0
votes
1 answer

Is there a way to set weeknumber/year format from a datetime column in pandas

''' 'I'm trying to set a column in datetime format like this and create a new column Week_No in week number/year format but when I write it to excel it converts it to mm/year format' datecolumn = ["Date"] df_2021 =…
Mahesh Katula
  • 3
  • 3
0
votes
1 answer

Read .xls file with Python pandas read_excel not working, says it is a .xlsb file

I'm trying to read several .xls files, saved on a NAS folder, with Apache Airflow, using the read_excel python pandas function. This is the code I'm using: df = pd.read_excel('folder/sub_folder_1/sub_folder_2/file_name.xls', sheet_name=April,…
JCarNav
  • 21
  • 1
  • 5
0
votes
0 answers

Read multiple XLSB files in pandas python

I´m starting on this and i need to read multiple .xlsb files . All files are found in the same directory. I need to take one specific sheet and create a dataframe. Thanks
simon
  • 1
0
votes
1 answer

Python How to convert .xlsx to .xlsb file

I need to convert some XLSX files to XLSB. Before doing this I open each xlsx file with openpyxl (openpyxl to keep the data frame style). Do you have a solution to convert it directly by openpyxl or by a python script ?
Ads
  • 13
  • 3
0
votes
1 answer

Cannot open xlsb workbooks with macros and custom ribbons

Suddenly we are unable to open xlsb Excel workbooks with Excel complaining "Excel cannot open the file because the file format or file extension is not valid." The files are on a network drive but the issue happens if they are copied to a cloud…
ChipsLetten
  • 2,923
  • 1
  • 11
  • 28
0
votes
0 answers

reading Time column in pandas gives float value, how to convert float value to total milliseconds

import pandas as pd import numpy as np data = {'Name':['T1','T2','T3'], 'Time column in excel':['01:57:15', '00:30:00', '05:00:00'], 'Time column in Python':['0.0814236111111111', '0.0208333333333333', '0.208333333333333']} df =…
Sandeep Moholkar
  • 11
  • 1
0
votes
1 answer

How to read time column in pandas and how to convert it into milliseconds

I used this code to read excel file df=pd.read_excel("XYZ.xlsb",engine='pyxlsb',dtype={'Time':str}) This is just to show what i am getting after reading excel file. import pandas as pd import numpy as np data = {'Name':['T1','T2','T3'], 'Time…
Sanju M
  • 15
  • 4
0
votes
0 answers

Saving pandas Dataframe to xlsb format in Python?

I have a dataframe with 5 columns. The Date column is of type Object. df : DATE 0 2020-06-01T00:00:00.000Z 1 2021-08-01T00:00:00.000Z 2 2021-06-01T00:00:00.000Z 3 2021-07-01T00:00:00.000Z 4 2021-01-01T00:00:00.000Z I am trying to convert…
AMIT BISHT
  • 49
  • 1
  • 9
1 2 3
4
5 6 7