Excel sheet save

Question

Hi I want to know, how can i alter a cell value of a particular excel sheet, in an already existing excel file without changing the other sheets and values.

Rajeesh Menoth · Answer

Hi Lili, Please refer the following examples : http://stackoverflow.com/questions/23168657/modify-excel-cell www.aspose.com/docs/display/cellsnet/Accessing+and+Modifying+the+Value+of+a+Cell http://www.aspose.com/docs/display/cellsnet/Accessing+and+Modifying+the+Value+of+a+Cell

Praveen Dhatrika · Answer

you are welcome. Go through more in detail about www.aspose.com. It will also have some sample code that helps you in majority of your coding

Rahul Prasad · Answer

You could also try free Spire.XLS to load and modify data in an existing Excel sheet. http://www.e-iceblue.com/Introduce/free-xls-component.html Workbook workbook = new Workbook(); //load existing Excel file workbook.LoadFromFile(@"existing.xlsx"); Worksheet sheet = workbook.Worksheets[0]; //Write string values in a cell sheet.Range["A3"].Text = "xxxxx"; //Save workbook to disk workbook.SaveToFile("result.xlsx");

Praveen Dhatrika · Answer

Aspose.cell Look for www.aspose.com and that should give an answer. There will be some sample code even available in the website

Lili R · Answer

Yes Praveen, I found really good stuff to learn from.. thank u so much..

Lili R · Answer

Thank you Rajeesh and Praveen that was really helpful.

Excel sheet save

Answers (6)