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

Free Support Forum - aspose.com

[Smart Marker] FormatCell

Dear Aspose.Cells,


I’m using smart marker to export excel. I want to format number/date/currency,… cell of worksheets by string-format that get from server.

Can you recommend for me a solution, please?

Thank and regards.

Hi,


Well, you may try any option to accomplish your task:

1) Format/apply style manually in MS Excel to those cells (Smart Markers cells), so when the markers are processed, the filled data cells would be automatically formatted accordingly.

2) After the markers are processed, you may use Aspose.Cells APIs to apply numbers formatting to your desired cells, see the document for your reference on how to apply formattings:
http://www.aspose.com/docs/display/cellsnet/Setting+Display+Formats+of+Numbers+and+Dates

Hope, this helps a bit.

Thank you.