Save Excel file on Server

Question

Hi there , I need to know how to Save Excel file on server by using Javascript . Please also provide me some sample code for this. Thanks & Regards ,

Sangeetha Priya Murugan · Answer

Hi Vikash Kumar, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported requirement and it can be achievable in our spreadsheet by using the openFromJson and saveAsJson client side methods. For open and saving the excel file we have used ASP.NET workbook server side action (Open, Save). For more details regarding your requirement. Please refer the below link. 
 
Knowledge base link: https://www.syncfusion.com/kb/11970/how-to-open-and-save-an-excel-file-to-server-in-the-spreadsheet 
 
In the above link, we have done the open/save functionality in a button click event. Please check the above link and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M

Vikash Kumar · Answer

Can you please send me sample with Php .. I am using Php + Javascript and I need to save Excel file on server .

Sangeetha Priya Murugan · Answer

Hi Vikash Kumar 
 
Thank you for your update. 
 
We have checked your reported requirement and we would suggest you to use JavaScript (ES5) spreadsheet in your end. For your convenience, we have prepared the sample that loads the excel file from the server and save the modified file in the server using open and save methods as like as below.  
 




 
public IActionResult Open(IFormCollection openRequest) 
        { 
            OpenRequest open = new OpenRequest(); 
            open.File = openRequest.Files[0]; 
            return Content(Workbook.Open(open)); 
        } 
 
        public string Save(SaveSettings 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); 
            FileStream filePath = new FileStream(Startup._env.WebRootPath.ToString() + "/Sample1.xlsx", FileMode.Create); 
            workbook.SaveAs(filePath);  // you can use this stream as your need.  
            fileStream.Dispose(); 
            filePath.Dispose(); 
            return "Spreadsheet saved in server"; 
        } 
 created() { 
    fetch("http://localhost:55367/" + "Sample1.xlsx").then(response => { 
      response.blob().then(fileBlob => { 
        var file = new File([fileBlob], "Sample.xlsx"); // to open the blob file 
        this.spreadsheetObj.open({ file: file }); 
      }); 
    }); 
  } 
   
 
Sample Link: https://stackblitz.com/edit/6ikfl5?file=index.js 
 
Service Link: https://www.syncfusion.com/downloads/support/forum/160432/ze/core-sample-1055477443 
 
Note: launch the service first and then open the stackblitz sample for import and export. 
 
Documentation Link: https://ej2.syncfusion.com/javascript/documentation/spreadsheet/getting-started/ 
 
Demos Link: https://ej2.syncfusion.com/javascript/demos/#/material/spreadsheet/default.html 
 
Could you please check the above link and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M