excel 如何绘制边框

矫情吗；* 2022-08-03 00:15 168阅读 0赞

//绘制外边框
    void XlsDrawOutBorders(const CString &Row, const CString &Col,XlBordersLineStyle xlLineStyle, XlBorderWeight XlsWeight,long coloIndex)
    {
    	if (!xlsAppIsInit())
    	{
    		return;
    	}
    	if (Row.IsEmpty() || Col.IsEmpty())
    	{
    		return;
    	}
    	LPDISPATCH  lpDisp = NULL;
    	lpDisp = m_xlsAppLication.get_ActiveSheet();//主excel接口
    	CWorksheet    xlsSheet;
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    	xlsSheet.AttachDispatch(lpDisp);
    	if (xlsSheet.m_lpDispatch == NULL)
    	{
    		return;
    	}
    	lpDisp = xlsSheet.get_Range(_variant_t(Row), _variant_t(Col));
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    	CRange  rang; 
    	rang.AttachDispatch(lpDisp);
    	lpDisp = rang.get_Borders();
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    	CBorders xlsBords;   //外
    	xlsBords.AttachDispatch(lpDisp);
    	//边框
    	CBorder xlsBordTmp;
    
    	//绘制Left边框
    	lpDisp = xlsBords.get_Item(_variant_t((long)xlEdgeLeft));
    	if (lpDisp == NULL)
    	{
    		return;
    	}
     	xlsBordTmp.AttachDispatch(lpDisp);  
     	xlsBordTmp.put_ColorIndex(_variant_t(coloIndex));  
     	xlsBordTmp.put_Weight(_variant_t((long)XlsWeight));
    	xlsBordTmp.put_LineStyle(_variant_t(xlLineStyle));
        
    	//绘制Top边框
    	lpDisp = xlsBords.get_Item(_variant_t((long)xlEdgeTop));
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    	xlsBordTmp.AttachDispatch(lpDisp);  
    	xlsBordTmp.put_ColorIndex(_variant_t(coloIndex));  
    	xlsBordTmp.put_Weight(_variant_t((long)XlsWeight));
    	xlsBordTmp.put_LineStyle(_variant_t(xlLineStyle));
    
    	//绘制Bottom边框
    	lpDisp = xlsBords.get_Item(_variant_t((long)xlEdgeBottom));
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    	xlsBordTmp.AttachDispatch(lpDisp); 
    	xlsBordTmp.put_ColorIndex(_variant_t(coloIndex));  
    	xlsBordTmp.put_Weight(_variant_t((long)XlsWeight));
    	xlsBordTmp.put_LineStyle(_variant_t(xlLineStyle));
    
    	//绘制Right边框
    	lpDisp = xlsBords.get_Item(_variant_t((long)xlEdgeRight));
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    	xlsBordTmp.AttachDispatch(lpDisp); 
     	xlsBordTmp.put_ColorIndex(_variant_t(coloIndex));  
     	xlsBordTmp.put_Weight(_variant_t((long)XlsWeight));
        xlsBordTmp.put_LineStyle(_variant_t(xlLineStyle));
    
    	xlsBordTmp.ReleaseDispatch();
    	xlsBords.ReleaseDispatch();
    	xlsSheet.ReleaseDispatch();
    	rang.ReleaseDispatch();
    	lpDisp = NULL;
    }

//判断Excel是否初始化
    BOOL xlsAppIsInit()
    {
    	LPDISPATCH lpDisp = NULL;
    	BOOL bRec = FALSE;
    	lpDisp = m_xlsAppLication.m_lpDispatch;
    	if (lpDisp == NULL)
    	{
    		AfxMessageBox(_T("请新建文件Excel未初始化!"));
    		bRec = FALSE;
    	}
    	else
    	{
    		bRec = TRUE;
    	}
    	lpDisp = NULL;
    	return bRec;
    }