How to set format to cell in Excel?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kerry Warret
    New Member
    • Sep 2013
    • 1

    How to set format to cell in Excel?

    I have known to set value to cell in Excel, but I have not know to set number format to the cell.
    for example I need to 12 show 12.00%, How to do using Acey.ExcelX which downloaded in www.aceyoffice.com.

    This is my code.

    Code:
    using Acey.ExcelX
    
    
         
    IWorkbook workbook = ExcelxApplication.CreateWorkbook();
    
    IWorksheet worksheet = workbook.Worksheets[0];
    
    ICell cell = worksheet.Cells[0, 0];
    
    cell.Value = 12;
    
     workbook.SaveAs(@"d:\book1.xls", FileFormat.Excel97To2003);

    If you know, please help me, Thanks.
    Last edited by Rabbit; Sep 22 '13, 05:22 PM. Reason: Please use code tags when posting code or formatted data.
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    That is a commercial product, so why not contact the sellers directly?

    Comment

    Working...