java - How to format number cell in excel by Aspose? -
i using aspose creating excel. getting few difficulties.
1st issue
cells.importresultset
in how insert customdateformatstring
2nd issue
cells.importresultset
in how insert customnumberformatstring
please check below example number
10000 $10,000
1) may put desired custom date/time format string customdateformatstring parameter in cells.importresultset() overloaded method. see sample line of code reference: e.g sample code:
worksheet.getcells().importresultset(rs, 0, 0, true, "d-mmm-yy", true);
2) better once have imported data excel worksheet using cells.importresultset() method, may apply desired number formatting cells in range/column accordingly, see document reference: http://www.aspose.com/docs/display/cellsjava/setting+display+formats+of+numbers+and+dates
in case, should set custom number format string "$#,##0" requirements.
Comments
Post a Comment