This repository demonstrates how to host and integrate Open and Save services for the EJ2 Spreadsheet component using ASP.NET Core, ASP.NET MVC, and Web API. These examples are intended for developers building secure, scalable, and production-ready spreadsheet applications without relying on demo endpoints.
The EJ2 Spreadsheet allows users to view, edit, and manage Excel-like data directly in the browser. While demo endpoints (openUrl and saveUrl) are useful for showcasing features, they are not suitable for production due to limitations in security, scalability, and customization.
This repository offers a self-hosted solution using ASP.NET Core, ASP.NET MVC, and Web API, giving developers full control over file handling, data privacy, and performance.
The Open and Save services are powered by the Syncfusion XlsIO library on the server side:
- Open Service: Accepts an uploaded Excel file, reads it on the server, and converts it into a JSON workbook format that the Spreadsheet component can render on the client.
- Save Service: Receives the modified JSON workbook from the client, converts it back into an Excel file, and returns it for download.
All operations are performed in memory during the request lifecycle, ensuring no data is persisted on the server.
- Host your own Open and Save services using ASP.NET Core.
- Full control over data flow and file processing.
- Enhanced security and privacy for enterprise applications.
- Compatible with the Spreadsheet’s
openUrlandsaveUrlconfiguration.
- Clone this repository.
- Navigate to the respective project folder and ensure to update the Syncfusion packages with latest version in the project file.
- Build and Run the project locally.
- Update the Spreadsheet component's
openUrlandsaveUrlto point to your hosted endpoints.
For a detailed guide, refer to the official blog post:
Host Open and Save Services for JavaScript Spreadsheet with ASP.NET Core