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 best solutions below
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 display a Google Document inline image on HTML page?
- How to add Named Ranges to sub-paragraph elements in Google apps-script
- Output API data to a csv file
- automated email sending - variable in Htmlbody
- union data in multiple tabs
- How to real-time monitor the emails?
- How to pass function arguments to another function?
- Google sheers: On edit event trigger
- TypeError: Cannot read property "length" from undefined
- How to upload any file to FTP Server using Google Apps Script
- Authentication Error while using google SpreadSheet API
- Javascript on Google Sheets - Get Column Number from Prompt Input
- Apps Script, Count BG Color function on conditionally formatted cells
- Edit a google spreadsheet using javascript/client side code
- Import google spreadsheet data to google doc app script
Related Questions in GOOGLE-SHEETS
- Ignore #VALUE! error in SORT function
- Count Unique Values Repeated Dates
- Skyscanner Flights API and Google script
- Not able to access spreadsheet using google spreadsheet API
- SPLIT using " " delimiter in Google Sheets won't always preserve period following number
- union data in multiple tabs
- Google sheers: On edit event trigger
- Conditionally formatting multiple rows with the same conditions
- Authentication Error while using google SpreadSheet API
- Javascript on Google Sheets - Get Column Number from Prompt Input
- Apps Script, Count BG Color function on conditionally formatted cells
- Unable to authenticate with Google through the Java SDK for reading spreadsheet data
- Edit a google spreadsheet using javascript/client side code
- Google Spreadsheets, match/lookup in ALL rows, except the current one
- Google apps script for Spreadsheet - russian symbol substitute as a question mark
Related Questions in GOOGLE-DRIVE-API
- Google Drive API VB.NET Parent Folder of a Folder
- RealTime getCollaborators() method returning only 1 Collaborators
- Directory sandboxed access for Google Drive / Dropbox API / RemoteStorage apps?
- How can I make a copy of a file in Google Drive via Python?
- Google Drive APi and Google Maps in the same application
- Google Drive API: Change Slide During The Presentation
- How to sign out of a Google Drive account?
- Automated OAuth2 token not working - Google Apps Script
- Google Drive Sync + Read-only access
- Google Drive Progress Upload/Download Status
- ng-repeat list doesn't update immediately after api call
- Insert file using Google Drive API?
- Google drive PHP API: unable to insert files or folders into subfolders
- 401 Unauthorized - Google Drive API
- Convert docx to gdoc ( OpenWithLinks = null )
Related Questions in XLSB
- Read a particular sheet in a xlsb file using java
- removing the password from an XLSB file with Python
- Convert protected XLSB file to XLSX. Golang
- Why does setting the range of cells to read in read_xlsb yield the error Error in is.null(range) || is.na(range)?
- When should the xlsm or xlsb formats be used?
- Convert xlsb to google sheets using google app script
- Convert .xls to .xlsb Running PowerShell Script from Python, ERROR: "You cannot call a method on a null-valued expression"
- Read .xls file with Python pandas read_excel not working, says it is a .xlsb file
- How to append rows in Excel Binary Worksheet (xlsb)
- Python XLSB to CSV conversion data types
- Nifi processor for converting xlsb to csv
- How can i get merge cell info from xlsb
- Loading .xlsb file through power query from share point
- Is it possible for python to directly save and close an .xlsb file?
- Open .xlsb with ExcelDataReader
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)
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?
I think it's not possible.
You need to use some MS's tools for converting xlsb to xlsx before anything.