473,387 Members | 1,516 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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.

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
1 1492
Luuk
1,047 Expert 1GB
That is a commercial product, so why not contact the sellers directly?
http://www.aceyoffice.com/contact.aspx
Sep 22 '13 #2

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

Similar topics

2
by: DraguVaso | last post by:
Hi, I'm looking for a nice way to format the cell of my datagrid according to some predefined 'rules'. I found a lot on the site of George shepherd, but it wasn't really what I was looking for:...
1
by: desi.american | last post by:
I have a dynamically generates ASPX page with tables and data. Depending on user selection, the same page can be viewed as a simple web page (rendered in HTML) or as an excel spreadsheet. If the...
12
by: kath | last post by:
How do I read an Excel file in Python? I have found a package to read excel file, which can be used on any platform. http://www.lexicon.net/sjmachin/xlrd.htm I installed and working on the...
0
by: Zim Babwe | last post by:
I have an unbound DataGrieView on a Windows form (VS 2005) and I have added a column to a DataGridView Dim textCol As New DataGridViewTextBoxColumn textCol.Name = "ContactPhone1" ...
3
by: Paul | last post by:
I use OpenOffice but I suppose similar formatting rules apply to MS Excel. For example, to format a cell for two digit numbering, the format code is: #,##0.00 I can use formulas (=F$temp + 5)...
3
neo008
by: neo008 | last post by:
Hi all, What is the best way to format cells of an Excel sheet? I have read somewhere "object.range.property" method. but it's tedious if we do it cell by cell. Moreover most of the properties...
1
by: Neo007 | last post by:
**File Conversion from CSV format to Excel(.xsl) C# Detailed Requirement is : Requirements for File Conversion Application: 1.My Application must be command-line it should indicate success...
7
by: Kosmos | last post by:
Howdy...haven't used Access for a while, but now I'm getting back into it and can't seem to figure out how I can import data from an excel table that outputs the date in the formate of MMDDYYYY. I...
4
juve11
by: juve11 | last post by:
hello, i made alot of changes to an excel sheet from visual basic like bordering,setting landscape,margins... but there is a thing a didnt managed to change : the cell format. i have two columns...
3
by: Bface | last post by:
Hi all, Hope everyone had a good holiday. I am having a difficult time changing the date format of a field from Excel. I have never had this problem before. I link the excel spreadsheet to my DB,...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.