.NET Excel Template Loader and Updater
₹600-1500 INR
Paid on delivery
As a first step in .net,
Load the excel template into the cache (the one i shared it with you the sheet Income allocation).
Write a patch API to update the cell values and convert this as json and see if the formulas are getting evaluated and the value.
If the input row index is greater than the used range, then add a new row by copying it from the original row then write the data.
Here is the full requirement of this implementation
1. API to Load Excel Template:
- Develop an API to read an Excel template from the file system, including specified template and sheet, using SpreadsheetGear.
2. Fetch Data from Database:
- Read data stored as JSON in the database associated with the given project and specified template sheet.
3. Write Data into Excel and Cache Workbook:
- Write the retrieved JSON data into the corresponding Excel sheet.
- Load the Excel workbook into a thread-safe concurrent dictionary, indexed by the user ID extracted from the JWT session token.
4. Send JSON Response:
- Return the JSON data written to the Excel sheet as the API response.
5. Patch API for Cell Updates:
- Implement a PATCH API to update a specific cell in the Excel sheet. Accept parameters for template, sheet, row index, column index, and cell value.
- Load the workbook from the concurrent dictionary using the user ID.
- Update the specified cell. If the row index exceeds the used range, copy the last row as a new row and apply the value to the appropriate cell.
6. Return Updated Row as JSON:
- Read the updated row from the Excel sheet and return it as a JSON response.
7. Commit Data to Database:
- Provide functionality to read all rows from the Excel sheet as JSON upon user confirmation.
- Store the JSON data in the database.
8. Clear User Cache:
- Clear the cached workbook object associated with the user upon data commit or logout.
9. Session Validation and Cache Cleanup:
- Implement a periodic job to validate user sessions.
- Remove workbook objects from the concurrent dictionary for users whose sessions are no longer active.
Project ID: #38854294
About the project
16 freelancers are bidding on average ₹4688 for this job
As an experienced and dedicated data master, I've spent over a decade perfecting my Excel skills and honing the art of transforming raw information into actionable insights. Your project requires the precise handling, More
Experienced .NET developer specializing in Excel integration and API services. I can efficiently manage and update Excel data, ensuring seamless synchronization with your database. Ready to deliver high-quality, scalab More
hi think i am perfect for this role and want this project recently i do this kind of project in my office
Hello sir, my name is Gaurav Sharma, I am 12th pass, I am 18+ ahead of me. Sir, I am in great need of work, please sir, I want to work in your office. Thanks sir
I am excited about the opportunity to work on your project, which involves implementing a robust Excel processing API using .NET. I have carefully reviewed the provided requirements and am confident in delivering a sol More
Hello I’d love to assist you with implementing the Excel-based solution you described. With over eight years of experience delivering bespoke web development solutions, I specialize in crafting efficient APIs and opti More
I'm senior Developer and team leader I'm currently working in MNC company Mt devloped experience 4 year
