excel 设置单元格对齐方式

谁践踏了优雅 2022-05-19 07:44 327阅读 0赞

enum CellHorizonAlignment
    	{
    		xlCenter = -4108,
    		xlLeft   = -4131,
    		xlRight  = -4152,
    		xlFill   = 5,
    		xlJustify= -4130,
    		xlCenterAcrossSelection = 7,
    		xlDistributed= -4117
    	};
    	enum CellVerticalAlignment
    	{
           xlTop = -4160,
    	   xlBottom = -4107,
    	   xlvJustify= -4130,
    	   xlvDistributed= -4117
    	};
    
    
    //设置单元格对齐方式
    void COperExcel::XlsSetCellAlignment(int row, int colum, CellHorizonAlignment horizon, CellVerticalAlignment vertical)
    {
    	if (!xlsAppIsInit())
    	{
    		return;
    	}
    	/*
    	row  colum  判断
    	*/
    	if (!(row >= 1 && colum >= 1))
    	{
    		;
    		return;
    	}
    
    	CWorksheet xlsWorkSheet = m_xlsAppLication.get_ActiveSheet();
    	if (xlsWorkSheet.m_lpDispatch == NULL)
    	{
    		return;
    	}
    	CRange range;
    	LPDISPATCH lpDisp = NULL;
    	lpDisp = xlsWorkSheet.get_Cells();  //所有表格
    	if (lpDisp == NULL)
    	{
    		return;
    	}
    
    	range.AttachDispatch(lpDisp);
    	if (range.m_lpDispatch == NULL)
    	{
    		return;
    	}
    	
    	range.get_Item(_variant_t((long)row), _variant_t((long)colum));
    	switch(horizon)
    	{
    	case COperExcel::xlLeft:
    		range.put_HorizontalAlignment(_variant_t(xlLeft));
    		break;
    	case COperExcel::xlRight:
    		range.put_HorizontalAlignment(_variant_t(xlRight));
    		break;
    	case COperExcel::xlCenter:
    		range.put_HorizontalAlignment(_variant_t(xlCenter));
    		break;
    	case COperExcel::xlFill:
    		range.put_HorizontalAlignment(_variant_t(xlFill));
    		break;
    	case COperExcel::xlJustify:
    		range.put_HorizontalAlignment(_variant_t(xlJustify));
    		break;
    	case COperExcel::xlCenterAcrossSelection:
    		range.put_HorizontalAlignment(_variant_t(xlCenterAcrossSelection));
    		break;
    	case COperExcel::xlDistributed:
    		range.put_HorizontalAlignment(_variant_t(xlDistributed));
    		break;
    	default:
    		break;
    	}
    	switch (vertical)
    	{
    	case COperExcel::xlTop:
    		range.put_VerticalAlignment(_variant_t(xlTop));
    		break;
    	case COperExcel::xlBottom:
    		range.put_VerticalAlignment(_variant_t(xlBottom));
    		break;
    	case COperExcel::xlJustify:
    		range.put_VerticalAlignment(_variant_t(xlJustify));
    		break;
    	case COperExcel::xlDistributed:
    		range.put_VerticalAlignment(_variant_t(xlDistributed));
    		break;
    	default:
    		break;
    	}
    	range.ReleaseDispatch();
    	xlsWorkSheet.ReleaseDispatch();
    	lpDisp = NULL;
    }