Example #1
0
        public static void SetPrintTitles()
        {
            //Instantiating a Workbook object
            Workbook workbook = new Workbook();

            //Obtaining the reference of the PageSetup of the worksheet
            Aspose.Cells.PageSetup pageSetup = workbook.Worksheets[0].PageSetup;

            //Defining column numbers A & B as title columns
            pageSetup.PrintTitleColumns = "$A:$B";

            //Defining row numbers 1 & 2 as title rows
            pageSetup.PrintTitleRows = "$1:$2";
        }
        public static void Run()
        {
            // ExStart:1
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            // Instantiating a Workbook object
            Workbook workbook = new Workbook();

            // Obtaining the reference of the PageSetup of the worksheet
            Aspose.Cells.PageSetup pageSetup = workbook.Worksheets[0].PageSetup;

            // Defining column numbers A & B as title columns
            pageSetup.PrintTitleColumns = "$A:$B";

            // Defining row numbers 1 & 2 as title rows
            pageSetup.PrintTitleRows = "$1:$2";

            // Save the workbook.
            workbook.Save(dataDir + "SetPrintTitle_out.xls");
            // ExEnd:1
        }