We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cannot add text

The documentation says to add text to a cell to use cell.Value. This comes back with an error that it cannot be used because it is read only. I cannnot find a way to add text to a cell.

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please use the Cell.PutValue() method to add text in the cell. Please see the following code for your reference. The code adds some text in cell A1. We have also attached the output xlsx file generated by this code.

C#


Workbook workbook = new Workbook();


Worksheet worksheet = workbook.Worksheets[0];


Cell cell = worksheet.Cells[“A1”];


cell.PutValue(“Some text”);


workbook.Save(“output.xlsx”, SaveFormat.Xlsx);

Hi,


Moreover, please see the document for your complete reference on now to add data to the cells:
http://www.aspose.com/docs/display/cellsnet/Adding+Data+to+Cells

Thank you.