Setting a cell's format using Excel 2007 Interop and C#

Posted by CVertex on Stack Overflow See other posts from Stack Overflow or by CVertex
Published on 2009-03-03T02:54:57Z Indexed on 2010/05/10 3:08 UTC
Read the original article Hit count: 385

Filed under:

excel-2007

|

office-interop

|

primary-interop-assembly

|

c#

I'm using the office 2007 interop assemblies to create some excel spreadsheets.

There are plenty of questions on here about getting started and MSDN contains heaps of articles, like this one.

The API is funky, and sometimes a bit confusing.

When I set a value of a cell, is there a way to set it's format? I'd like to mark particular fields as Date's so my customer can run excel macros on them. Also, numbers would be useful.

Thanks!

© Stack Overflow or respective owner

Related posts about excel-2007

Inserting (jpg) pic inside MS Excel 2007 cell

as seen on Super User - Search for 'Super User'
Is it possible to insert a jpg image INSIDE a cell .... or do cell ONLY excel alphaNum char (or ref) ? >>> More
Conditional formatting using cell styles in Excel 2007?

as seen on Super User - Search for 'Super User'
Excel 2007 has added support for cell styles, which I find very useful. I love it when I can change formatting in one place and the change propagates throughout the spreadsheet. I also love conditional formatting. Can the two be combined? Can I conditionally apply a cell style? >>> More
FileSystemWatcher.Changed fires immediately when Excel 2007 opens XLS file in compatibility mode

as seen on Stack Overflow - Search for 'Stack Overflow'
We use a FileSystemWatcher to monitor documents opened from our Document Management system, and if the user saves the document, we ask if they would also like them updated in our system. We have a problem with XLS files in Excel 2007 (have not verified that the problem does not exist in 2003, but… >>> More
How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In

as seen on Super User - Search for 'Super User'
(cloning from question on SO) I created a function in VBA. I want Excel 2007 to show the Autocomplete when writing this function in the cell's Excel. Detail as How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In (.xlam)? ps. In Excel 2010, the autocomplete works In… >>> More
Excel 2003 charts not looking right in 2007

as seen on Super User - Search for 'Super User'
I'm not exactly sure this goes here but I don't know where else to look for help. I have some Excel files containing charts made with Excel 2003. When I open the file in Excel 2007 and save it (non 2007) is messes up the charts. However, when in Excel 2007 and I Save as a .xlsx type the charts… >>> More

Related posts about office-interop

Merge Word Documents (Office Interop & .NET), Keeping Formatting

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having some difficulty merging multiple word documents together using Microsoft Office Interop Assemblies (Office 2007) and ASP.NET 3.5. I'm able to merge the documents, but some of my formatting is missing (namely the fonts and images). My current merge code is shown below. private void CombineDocuments()… >>> More
Microsoft.Office.Interop.Word documentation

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to use the Microsoft.Office.Interop.Word namespace to extract if a Word document contains macros, and which ones. The MSDN documentation for this namespace doesn't give much information compared to the documentation on other .Net classes. Where can I get more informations about this namespaces… >>> More
Microsoft.Office.Interop.Excel.ListObject vs Microsoft.Office.Tools.Excel.ListObject

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to access the Selected Event of all the listobjects in all the worksheets of my workbook but when I access worksheet.listobject, that object apparently belongs to Microsoft.Office.Interop.Excel.ListObject and so doesn't have any events where as the table list object belongs to Microsoft.Office… >>> More
Using Microsoft.Office.Interop to save created file with C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the this code that will create excel file and work sheet then insert same values. The problem I'm facing that I'm not able to save the file with name giving ten colse it. I used SaveAs but did not work: wb.SaveAs(@"C:\mymytest.xlsx", missing, missing, missing, missing, missing, XlSaveAsAccessMode… >>> More
Worksheet.Unprotect - Office Interop - Difference between 2003 and 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password from a database To… >>> More