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

darjeam nh · 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.