Update Excel Documents via .NET
Modify Microsoft Excel XLSX, XLS files within .NET based applications without installing Microsoft Office®.
It’s common for organization to update their data, stored in excel files such as students data, patients records and warehouse items list etc via company software. Aspose.Total for .NET API provides the functionality of modifying the spreadsheets using the software. Programmers can enhance the software with the modification capabilities by just writing few lines of API code. Aspose.Cells for .NET API that is part of Aspose.Total for .NET package makes this modification process easy. Below is the process of updating the Excel document.
Update Excel Documents using .NET
Aspose.Cells for .NET API provides Workbook class that handles the loading of Excel spreadsheets. Process is simple. Create the Workbook object by providing the source file as parameter. Access the relevant Worksheet by providing its index using Worksheets[0].Cells[column] method. Use the PutValue(data) method to modify the content in the accessed cell and finally call the save() method to save the document.