By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,035 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

How to set format to cell in Excel?

P: 1
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.

Expand|Select|Wrap|Line Numbers
  1. using Acey.ExcelX
  2.  
  3.  
  4.  
  5. IWorkbook workbook = ExcelxApplication.CreateWorkbook();
  6.  
  7. IWorksheet worksheet = workbook.Worksheets[0];
  8.  
  9. ICell cell = worksheet.Cells[0, 0];
  10.  
  11. cell.Value = 12;
  12.  
  13.  workbook.SaveAs(@"d:\book1.xls", FileFormat.Excel97To2003);

If you know, please help me, Thanks.
Sep 22 '13 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,031
That is a commercial product, so why not contact the sellers directly?
http://www.aceyoffice.com/contact.aspx
Sep 22 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.