Modify Aspose Cell on Export to Xlsx/Csv

Aspose.Cells Product Family
1

I am exporting all the data from a report. I can successfully make a workbook and save it like so:

	Workbook workbook;
	string fileName = "output";
	workbook.Save(HttpContext.Current.Response, fileName, ContentDisposition.Attachment, new OoxmlSaveOptions(SaveFormat.Xlsx));

How can I modify each cell value in the response? Is this possible?

2

@bradberkobien,

You may add/update data/values to the cells in the worksheets by using PutValue method of Cell class. See the document on adding/updating values in the cells for your reference.

Feel free to write us back if you have further queries or comments, we will be happy to assist you soon.

1 Like
3

Thank you this worked seamlessly!

4

@bradberkobien,
You are welcome. If you have any questions, please feel free to contact us.

1 Like