使用google应用程序脚本将xlsb转换为google sheets

function convertXLSBtoSheets() {
  var file = DriveApp.getFileById('XLSB文件的ID');
  var blob = file.getBlob();
  var xlsbData = Utilities.newBlob(blob.getBytes(), blob.getContentType(), file.getName()).setContentTypeFromExtension().getDataAsString();
  var xlsbFile = XLSB.read(xlsbData, {type: 'binary'});
  var sheetData = xlsbFile.Sheets[0].data;
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  for (var i = 0; i < sheetData.length; i++) {
    var rowData = sheetData[i];
    for (var j = 0; j < rowData.length; j++) {
      sheet.getRange(i + 1, j + 1).setValue(rowData[j]);
    }
  }
}