NPOI.XSSF.UserModel.XSSFWorkbook.GetReferencePrintArea C# (CSharp) Method

XSSFWorkbook Class Documentation Usage Examples Of NPOI.XSSF.UserModel.XSSFWorkbook::GetReferencePrintArea Mostra file Open project: tonyqus/npoi

GetReferencePrintArea() private static method

private static GetReferencePrintArea ( String sheetName, int startC, int endC, int startR, int endR ) : String
sheetName	String
startC	int
endC	int
startR	int
endR	int
return	String

        private static String GetReferencePrintArea(String sheetName, int startC, int endC, int startR, int endR)
        {
            //windows excel example: Sheet1!$C$3:$E$4
            CellReference colRef = new CellReference(sheetName, startR, startC, true, true);
            CellReference colRef2 = new CellReference(sheetName, endR, endC, true, true);

            return "$" + colRef.CellRefParts[2] + "$" + colRef.CellRefParts[1] + ":$" + colRef2.CellRefParts[2] + "$" + colRef2.CellRefParts[1];
        }

Usage Example

Esempio n. 1

Mostra file

        public void SetPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow)
        {
            string referencePrintArea = XSSFWorkbook.GetReferencePrintArea(this.GetSheetName(sheetIndex), startColumn, endColumn, startRow, endRow);

            this.SetPrintArea(sheetIndex, referencePrintArea);
        }

XSSFWorkbook

Add

AddPicture

AddPivotCache

AddSheet

AddToolPack

BeforeDocumentRead

Clear

CloneSheet

Commit

Contains

ContainsSheet