Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set color (vc++)
Hi, I have to write an application in vc++ which will be processing exce files. I already know how to put something in specific cell but I hav no idea how to change a color of the cell. Do you know how to do this Thanks for any tips and advices. Below I paste piece of code which use to put somthing in the cell A1. _Application objApp; _Workbook objBook; Workbooks objBooks; Worksheets objSheets; _Worksheet objSheet; Range range; COleVariant VOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); objBooks = objApp.GetWorkbooks(); objBook = objBooks.Add(VOptional); objSheets = objBook.GetWorksheets(); objSheet = objSheets.GetItem(COleVariant((short)1)); range = objSheet.GetRange(COleVariant("A1"),COleVariant("A 1")); range.SetValue(COleVariant("aaa")) -- vavshe ----------------------------------------------------------------------- vavshek's Profile: http://www.excelforum.com/member.php...fo&userid=1651 View this thread: http://www.excelforum.com/showthread.php?threadid=31372 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set color (vc++)
Don't know vc++, but to set a colour, use
range.Interior.Colorindex=35 the number is the colour pallette index number. -- HTH RP (remove nothere from the email address if mailing direct) "vavshek" wrote in message ... Hi, I have to write an application in vc++ which will be processing excel files. I already know how to put something in specific cell but I have no idea how to change a color of the cell. Do you know how to do this? Thanks for any tips and advices. Below I paste piece of code which I use to put somthing in the cell A1. _Application objApp; _Workbook objBook; Workbooks objBooks; Worksheets objSheets; _Worksheet objSheet; Range range; COleVariant VOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); objBooks = objApp.GetWorkbooks(); objBook = objBooks.Add(VOptional); objSheets = objBook.GetWorksheets(); objSheet = objSheets.GetItem(COleVariant((short)1)); range = objSheet.GetRange(COleVariant("A1"),COleVariant("A 1")); range.SetValue(COleVariant("aaa")); -- vavshek ------------------------------------------------------------------------ vavshek's Profile: http://www.excelforum.com/member.php...o&userid=16518 View this thread: http://www.excelforum.com/showthread...hreadid=313721 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |