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.
If you know, please help me, Thanks.
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.
Comment