设置Excel数据的边框

最新推荐文章于 2020-07-27 16:18:46 发布

原创

最新推荐文章于 2020-07-27 16:18:46 发布 · 3.9k 阅读

1 ·

CC 4.0 BY-SA版权

本文介绍了如何使用代码为Excel中的特定数据范围设置边框，帮助读者掌握在电子表格中添加边框的方法。

下面是设置一个range里的数据的边框代码

//设置数据的边框
        BordersPtr pBorders = pThisRange->GetBorders();
        BorderPtr  pDiagonalDownBorder = pBorders->GetItem(Excel::XlBordersIndex::xlDiagonalDown);
        pDiagonalDownBorder->PutLineStyle(xlNone);
        pDiagonalDownBorder.Release();


        BorderPtr  pDiagonalUpBorder = pBorders->GetItem(Excel::XlBordersIndex::xlDiagonalUp);
        pDiagonalUpBorder->PutLineStyle(xlNone);
        pDiagonalUpBorder.Release();


        BorderPtr  pEdgeLeftBorder = pBorders->GetItem(Excel::XlBordersIndex::xlEdgeLeft);
        pEdgeLeftBorder->PutLineStyle(xlContinuous);
        pEdgeLeftBorder->PutWeight(xlThin);
        pEdgeLeftBorder->PutColorIndex(xlAutomatic);
        pEdgeLeftBorder.Release();


        BorderPtr  pEdgeTopBorder = pBorders->GetItem(Excel::XlBordersIndex::xlEdgeTop);
        pEdgeTopBorder->PutLineStyle(xlContinuous);
        pEdgeTopBorder->PutWeight(