We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to save and retrieve the Spreadsheet data in database

This Knowledge Base explains the way to save and retrieve the Spreadsheet data as a byte array in Database. You can use “Open()” and “Save()” server methods to achieve this requirement.

 

API Documentation link: https://help.syncfusion.com/js/spreadsheet/open-and-save

 

JavaScript Solution

 

[JS]

 

 

 [Web API]

 

 

 

MVC Solution

 

[CSHTML]

 

 

[Controller]

 

 

 

ASP Solution

 

[ASPX]

 

 

[C#]

 

 

 

 

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
7567 03/15/2017 03/15/2017 JavaScript ejSpreadSheet
Did you find this information helpful?
Comments
Pradeep Kumar May 17, 2017
Can you please attach sample code here.
Reply
Shanmugaraja K [Syncfusion] May 18, 2017

Hi Pradeep,

 

We have attached the sample with the above codes, please find the below attachment,

 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/Spreadsheet_With_DB1404410855

 

Regards,

Shanmugaraja K

Pradeep Kumar May 19, 2017
Hi Shanmugaraja K,

Thanks for reply , can we open SQL Table Data eg. I have a to load a SQL Table of Orders in Spreadsheet and save that sheet data back to Order Table.

Thanks,
Reply
Shanmugaraja K [Syncfusion] May 22, 2017

Hi Pradeep,

 

Please refer the below forum link to achieve your requirement,

 

https://www.syncfusion.com/forums/130584/open-and-save-data-from-sql-table-in-spreadsheet

 

Regards,

Shanmugaraja K

Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon