Articles in this section
Category / Section

How to get Spreadsheet Blob data on save action?

3 mins read

This article explains how to get blob data of JavaScript Spreadsheet component on save action. You can trigger the saveComplete event by setting isFullPost property as false in the beforeSave event. Your can get the blob data of spreadsheet in the saveComplete event by setting needBlobData property as true in the beforeSave event. Using the below code, you can get the blob data in console window.

[HTML]

<div id="spreadsheet"></div>

 

[JS]

var spreadsheet = new ej.spreadsheet.Spreadsheet({
  sheets: [
    {
      name: 'Car Sales Report',
      ranges: [{ dataSource: defaultData }],   
    },
  ],
  openUrl:
    'https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/open',
  saveUrl:
    'https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/save',
  beforeSave: function (args) {
    args.needBlobData = true; //To trigger saveComplete event
    args.isFullPost = false; // To get blob data of Spreadsheet
  },
  saveComplete: function (args) {
    console.log(args.blobData); // returns blob data
  },
});
 

 

Sample: https://stackblitz.com/edit/m1yktv?file=index.js

 

Please find the below documentation to know more about Spreadsheet open/save action.

 

https://ej2.syncfusion.com/javascript/documentation/spreadsheet/open-save/

 

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied