AX 2012 Excel sheet copy 和BorderLine

最新推荐文章于 2024-06-26 19:28:54 发布

weixin_30294295

最新推荐文章于 2024-06-26 19:28:54 发布

阅读量109

点赞数

原文链接：http://www.cnblogs.com/fogfog/p/6472070.html

版权

//**********************************************

//sheet copy

abstract class SysExcelWorksheet extends SysExcel
{
MSOfficeVersion version;
}

public SysExcelWorksheet copy()
{
COM newSheet = worksheet.copy(COMArgument::NoValue, this.comObject()); //add

return SysExcelWorksheet::construct(version, newSheet);
}

//**********************************************

//BorderLine

abstract class SysExcelRange extends SysExcel
{
MSOfficeVersion version;
}

public void BorderLine()//Add
{
    Com        borders;
    ComVariant LineStyle,Weight,ColorIndex;
    int        xlEdgeBottom = 9;
    int        xlContinuous = 1;
    int        xlThin =       1;
    int        xlAutomatic = -4105;

   borders    = range.Borders() ;
   LineStyle = borders.LineStyle(xlContinuous);
   Weight     = borders.Weight(xlThin);
   ColorIndex = borders.ColorIndex(xlAutomatic);
}

转载于:https://www.cnblogs.com/fogfog/p/6472070.html