I would like to convert xlsb format file into google sheets using google app script.
Convert xlsb to google sheets using google app script
8.6k views Asked by Harish Batchu At
2
There are 2 answers
0
iansedano
On
This is not possible
Referring to the documentation here, Google Docs supports:
.xls (if newer than Microsoft® Office 95)
.xlsx
.xlsm
.xlt
.xltx
.xltm
.ods
.csv
.txt
.tsv
.tab
If you need to use an XSLB file, first convert it using Office or another converter to one of the above formats.
Alternatively, if you are skilled and brave, you can tackle the XLSB Specs to see if there is a way to convert the binary to something understandable using Apps Script!
If this is important to you and your business, I suggest you file a well justified feature request so that Google might consider implementing it.
Related Questions in GOOGLE-APPS-SCRIPT
- How to use custom font during html to pdf conversion?
- parameter values only being sent to certain columns in google sheet?
- AppScript to replace image in google slides
- Email Sent Using AppScript Appears in Sent Box, but does not appear in Recipient's Inbox
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- Would like the script to return the PDF letter via email with the sheet name not the spreadsheet name
- App script to prevent duplicate form submission
- Redirect Users to another website using GAS
- How do I create a Line Graph on App Script?
- Error (Status of 500) and X-Frame-Options with google apps script redirect function
- How do I add the Luxon library google sheet script
- AppScript For Google Form
- google sheet script to convert the Scientific notation in the selected area to number
- onEdit() 'row is not defined' error using checkboxes
- Regex expression not working on Google Form
Related Questions in GOOGLE-SHEETS
- google sheets, search and replace for next colum
- AppScript to replace image in google slides
- Regex to match repeated substring in Google Sheets
- How to append row to specific columns with gspread?
- Find a value in a range of cells (multiple rows and columns)
- Create date column based on range
- Look up a value using month of the date
- Data recovery based on other data
- Gsheet - Automatically send an email using a date & time in a Cell
- google sheet script to convert the Scientific notation in the selected area to number
- How can I limit the number of dropdown entries in a column in Google Sheets
- Parse tag in html via Google Sheets (importxml)
- Why is the background color of my google sheet web app not being applied?
- Google Sheets script that automatically locks a sheet 24 hours after a cell is edited
- My Google Sheets formulas mysteriously break as time passes, fix themselves when refreshed
Related Questions in GOOGLE-DRIVE-API
- Can you use the Drive API to share a file in Google Drive to an oath2 subject rather than email address?
- Write R pin to Google Drive without authentication
- Google Drive Service Account gets googleapiclient.errors.HttpError: 401 "Request is missing required authentication credential" when authenticating
- How to set expiry dates for Google Drive
- Trying to fetch images from a Google Drive folder
- How to programmatically zip/download google drive folder?
- google drive file missing
- Trigger Warning: Mysterious Memory Spike on Google Drive Upload using Google Cloud Run
- can replace file in google drive by c#?
- Images stored on google drive are not loading on a website hosted on heroku
- FileNotFoundError while trying to load dataset from drive
- Search in GDrive only the first 5 topics
- Issue with Google Drive API Integration: Unexpected HTML Response from Backend in Production Environment
- Can Google Drive act as a DB for Mobile App?
- java.lang.NoSuchMethodError: 'boolean com.google.api.client.http.HttpTransport.isMtls()'
Related Questions in XLSB
- How to add a gradle ODBC driver to connect with xlsb files
- Using python to add an additional sheet with formulas to each xlsb file in a folder
- Why does setting the range of cells to read in read_xlsb yield the error Error in is.null(range) || is.na(range)?
- Convert protected XLSB file to XLSX. Golang
- removing the password from an XLSB file with Python
- VBA code crush when it's saved xlam or xlsb
- how to read fast xlsb files with dask any libraries of python
- Do we need to adapt the VBA excel solver to work with German excel?
- How to save an excel file from xlsx to xlsb to make file smaller using vba and ms-access?
- Open .xlsb with ExcelDataReader
- Read files in XLSB format in scala
- Date type convert error in Python (XLSB to CSV): year 2022 --> 2092
- Error when accessing .xlsb file using xlwings
- In a ms-xlsb worksheet what are the undocumented 6 bytes between brtcolortab and rwsync
- How to read .xlsb file in Azure Data Factory
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I think it's not possible.
You need to use some MS's tools for converting xlsb to xlsx before anything.