如何设置Excel的背景颜色并在Excel中对某些行进行分组 [英] how to set the background color of Excel and group some lines in Excel

问题描述

我有两个问题，希望你能帮助我，非常感谢你！



1）例如，我得到了范围

I have two questions, hope you can help me, thank you very much!

1)for example, I have gotten the range

range = sheet.get_Range(COleVariant(_T("A1")),COleVariant(_T("A1"+intToCString2)));

，我该如何设置单元格A1的背景颜色？



2）

, how can i set cell A1's background color?

2)

range = sheet.get_Range(COleVariant(_T("A1")),COleVariant(_T("A5")));

，我想将行A1分组为A2，我知道类CRange有一个方法组（parameter1，parameter2，parameter3，parameter4），但是我不知道如何调用它。

, I want to group row A1 to A2, I know class CRange has a method group(parameter1,parameter2,parameter3,parameter4), but i don't know how to invoke it.

推荐答案

设置bg颜色：

set bg color:

	CApplication app;
	CWorkbooks books;
    CWorkbook book;
    CWorksheets sheets;
	CWorksheet sheet;
	CRange range;
	CInterior interior;

......

		// Commonly used OLE variants.
	COleVariant  covTrue((short)TRUE),  covFalse((short)FALSE),  covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);	
	// Start Excel and get an Application object.
	if(!app.CreateDispatch(TEXT("Excel.Application"))) {
		AfxMessageBox(TEXT("Couldn't start Excel and get Application object.\nPlease (re)install MS Excel.",MB_OK|MB_ICONSTOP));
		return;
	}

books = app.get_Workbooks();  // Get an IDispatch pointer.

if(m_bFromFile)
    book = books.Open(m_strFile, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional,covOptional,covOptional );   // Return Workbook's IDispatch pointer.
else
    book = books.Add (covOptional);// Open a new workbook and attach that IDispatch pointer to the Workbook object.

sheets =book.get_Sheets();   //CWorksheets get a pointer to CWorksheets pools
sheet = sheets.get_Item(COleVariant((short)1));   //CWorksheet get 1st sheet from the pool
//upto here is all regular excel instance. Now the bg colour
range = sheet.get_Range(COleVariant(TEXT("A1")), COleVariant(TEXT("G1")));
interior=range.get_Interior();
interior.put_ColorIndex(COleVariant((short)36)); //color by index
interior.put_Color(COleVariant(long(RGB(0xFF,0xC4,0xC4))));  //colour by RGB

这里是如何合并：

here is how to merge:

range = sheet.get_Range(COleVariant(TEXT("A1")),COleVariant(TEXT("G1")));
range.Merge(covOptional);  //merge A1 - G1

这篇关于如何设置Excel的背景颜色并在Excel中对某些行进行分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！