Syncfusion React Spreadsheet + Aws Lambda Integration
This repository contains a complete sample demonstrating how to integrate the Syncfusion React Spreadsheet component with an ASP.NET Core Web API deployed to AWS Lambda. It showcases how to open and save Excel files using serverless endpoints for seamless cloud-based spreadsheet management.
?? Live Demo
- React Client Sample (StackBlitz): react-syncfusion-aws-lambda-spreadsheet
?? Project Structure
+-- client/ # React app with Syncfusion Spreadsheet
+-- server/ # ASP.NET Core Web API project
? Features
- Open Excel files via Lambda-hosted endpoint
- Save edited spreadsheets back to local system
- Serverless, scalable, and secure integration
?? Technologies Used
- React + Syncfusion Spreadsheet
- ASP.NET Core Web API
- AWS Lambda Function
?? Getting Started
Clone the Repository
git clone https://github.com/SyncfusionExamples/syncfusion-react-spreadsheet-aws-lambda-integrationConfigure and Deploy ASP.NET Core Web API to AWS Lambda
Follow the steps in our documentation or blog post.
Documentation Link for Open: Open an excel file using a hosted web service in AWS Lambda
Documentation Link for Save: Save an excel file using a hosted web service in AWS Lambda
- Install AWS Toolkit in Visual Studio
- Add Amazon.Lambda.AspNetCoreServer.Hosting NuGet package
- Configure Program.cs and .csproj for Lambda
- Publish to AWS Lambda
- Create and deploy API Gateway for open/save endpoints
Update React Client
In
index.js, update theopenUrlandsaveUrlwith your deployed API Gateway endpoints:<SpreadsheetComponent openUrl="https://your-api-url.amazonaws.com/{your_deployed_stage_Name}/api/spreadsheet/open" saveUrl="https://your-api-url.amazonaws.com/{your_deployed_stage_Name}/api/spreadsheet/save" />Setup the Client
cd client npm install npm startRun the Server
Run the project and test the endpoints directly from the React app
dotnet run
Key Files
- SpreadsheetController.cs: Handles open/save logic in ASP.NET Core
- index.js: React component with Syncfusion Spreadsheet integration
- Program.cs: Configured for AWS Lambda hosting
Resources
- https://help.syncfusion.com/document-processing/excel/spreadsheet/react/overview
- https://help.syncfusion.com/document-processing/excel/spreadsheet/react/open-save
Benefits
- Serverless execution with AWS Lambda
- Auto-scaling and cost-efficient
- Secure integration via API Gateway and IAM
- Cloud-native spreadsheet workflow
Try It Out
Clone the repo, deploy the backend, and run the React app to experience seamless Excel file handling in the cloud!
License and copyright
This is a commercial product and requires a paid license for possession or use. Syncfusion® licensed software, including this control, is subject to the terms and conditions of Syncfusion® EULA. To acquire a license for 140+ JavaScript UI controls, you can purchase or start a free 30-day trial.
A free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.
See LICENSE FILE for more info.