Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
149335 | Nov 22,2019 02:58 AM UTC | Dec 2,2019 01:27 PM UTC | ASP.NET Core - EJ 2 | 6 |
![]() |
Tags: Spreadsheet |
<button class="e-btn" onclick="saveToServer()">Save Back to Server</button>
<ejs-spreadsheet id="spreadsheet" openUrl="Home/Open" saveUrl="Home/Save" created="onCreated"></ejs-spreadsheet>
<script>
function onCreated() {
var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
var request = new XMLHttpRequest();
request.responseType = "blob";
request.onload = () => {
var file = new File([request.response], "Sample1.xlsx");
spreadsheetObj.open({ file: file });
}
request.open("GET", "/Files/" + "Sample1.xlsx");
request.send();
}
function saveToServer() {
var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
spreadsheetObj.save();
}
</script> |
public string Save(SaveSettings saveSettings)
{
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
try
{
// Convert Spreadsheet data as Stream
Stream fileStream = Workbook.Save<Stream>(saveSettings);
IWorkbook workbook = application.Workbooks.Open(fileStream);
var filePath = Startup._env.ContentRootPath.ToString() + "/Files/Sample1.xlsx";
FileStream outputStream = new FileStream(filePath, FileMode.Create);
workbook.SaveAs(outputStream);
return "Spreadsheet saved in server";
}
catch (Exception ex)
{
return "Failure";
}
} |
<script src="https://cdn.syncfusion.com/ej2/17.3.16/dist/ej2.min.js"></script> |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.