Open excel from local or from server and save to server - EJ2

Question

I'm trying Spreadsheet control to display excel file where the file can be opened from server or local computer. When saving the file I want to save it to the server although it's opened from local computer. When the page is loaded, it will automatically open excel file from server where users can replace the file by opening from local computer and save back to server. I just see "Save As" instead of "Save". I'm using ASP.NET Core Razor Pages. This is the code and it failed

_Layout.cshtml

<body>

..

<ejs-scripts></ejs-scripts>

@await RenderSectionAsync("Scripts", required: false)

</body>

Index.chstml

<ejs-spreadsheet id="spreadsheet"

enableContextMenu="true"

openUrl="/LoadExcel" saveUrl="/SaveExcel"

allowOpen="true" allowSave="true"

created="onCreated">

</ejs-spreadsheet>

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], "Book.xlsx");

spreadsheetObj.open({ file: file });

}

request.open("GET", "/Index/LoadExcel");

request.send();

}

Index.chstml.cs (IndexModel class)

public IActionResult OnPostSaveExcel(SaveSettings saveSettings)

{

Workbook.Save(saveSettings);

ExcelEngine excelEngine = new ExcelEngine();

IApplication application = excelEngine.Excel;

// Convert Spreadsheet data as Stream

Stream fileStream = Workbook.Save<Stream>(saveSettings);

IWorkbook workbook = application.Workbooks.Open(fileStream);

var filePath = "path_to_excel\Book.xlsx";

FileStream outputStream = new FileStream(filePath, FileMode.Create);

workbook.SaveAs(outputStream);

return Content("Spreadsheet saved in server");

}

public IActionResult OnGetLoadExcel()

{

var filePath = "path_to_excel\Book.xlsx\Book1.xlsx";

ExcelEngine excelEngine = new ExcelEngine();

IWorkbook workbook;

FileStream fs = System.IO.File.Open(filePath, FileMode.Open); // converting excel file to stream

workbook = excelEngine.Excel.Workbooks.Open(fs, ExcelOpenType.Automatic); // coverting stream to XlsIO workbook

MemoryStream outputStream = new MemoryStream();

workbook.SaveAs(outputStream);

IFormFile formFile = new FormFile(outputStream, 0, outputStream.Length, "", "Book1.xlsx"); // converting MemoryStream to IFormFile

OpenRequest open = new OpenRequest();

open.File = formFile;

fs.Close();

var json = Workbook.Open(open);

return Content(json);

}

Sangeetha Priya Murugan · Accepted Answer

Hi Moh, Thank you for your update. We have checked your reported requirement “To get the filename of the imported excel file and save it again with the same name”. And it can be achievable in our spreadsheet by using beforeOpen event and save method as like as below.

Sample Link: https://www.syncfusion.com/downloads/support/forum/160963/ze/PdfViewer_RazorPages2037260969 Could you please check the above link and get back to us, if you need any further assistance on this. Regards, Sangeetha M

Sangeetha Priya Murugan · Answer

Hi Moh, Thank you for contacting Syncfusion support. We have checked your reported requirement and it can be achievable in our spreadsheet by using save method. For your convenience, we have prepared the sample that save the excel file to the server with the entered filename input in a button click event as like as below.

public void OnPostSave(SaveSettings saveSettings) { ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; // Convert Spreadsheet data as Stream Stream fileStream = Workbook.Save(saveSettings); IWorkbook workbook = application.Workbooks.Open(fileStream); var filePath = _hostingEnvironment.WebRootPath + @"\" + saveSettings.FileName + ".xlsx"; FileStream outputStream = new FileStream(filePath, FileMode.Create); workbook.SaveAs(outputStream); workbook.Close(); outputStream.Dispose(); } Sample Link: https://www.syncfusion.com/downloads/support/forum/160963/ze/PdfViewer_RazorPages801528925 Could you please check the above link and get back to us, if you need any further assistance on this. Regards, Sangeetha M

Ramzi · Answer

When saving to server the file name is always Sample.xls although I open from local with different name. function saveToServer() {        var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');        var element = document.getElementById("fileName"); // it's always null        if (element)            spreadsheetObj.save({ fileName: element.value }); // To save the filename with the entered file name input        else            spreadsheetObj.save();    }

Ramzi · Answer

This is the sample code I've created. The only problem now is when saving back to server using custom button or spreadsheet control the file name in saveSettings.FileName is always "Sample" event when I open an excel file locally. It should keep original file name without specifying one.

Attachment: SyncfusionExcelWeb_cb3be3e1.zip

Sangeetha Priya Murugan · Answer

Hi Moh, 
 
Thank you for your update. 
 
We have checked your reported requirement and we would like to let you know that in our previously updated sample, you need to enter the file name in the input. After that you need to save the file with the entered filename input in a button click event. For your convenience, we have prepared the video demonstration of this requirement. Please find the link below. 
 
Video Link: https://www.syncfusion.com/downloads/support/forum/160963/ze/export-file1877027284  
 
Could you please check the above link and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M

Ramzi · Answer

No, that's not what I need. In the video I have to specify the file name. All I need is getting the original file name opened both from server or local computer.

Ramzi · Answer

Thank you for the great support. It's now working as expected

Sangeetha Priya Murugan · Answer

Hi Moh, 
 
Thanks for your update. 
 
We are happy to hear that your issue has been resolved. Kindly get back to us if you need any further assistance. 
 
Regards, 
Sangeetha M