C# (CSharp) MooseXLSReports WorkbookNavigator Exemples

Exemple #1

        private dynamic GetTimesheetCell(DateTime date, string column)
        {
            var rowPosition = new WorkbookNavigator(date, WorksheetDates.GetStartDatesForWorksheets());

            Console.WriteLine("Row: {0}", rowPosition.Row);
            var cell       = string.Format("{0}{1}", column, rowPosition.Row);
            var worksheets = excel.Worksheets;
            var sheet      = worksheets[rowPosition.SheetName];
            var actualCell = sheet.Range[cell];

            return(actualCell);
        }

Exemple #2

Fichier : XLSReport.cs Projet : charlesarmitage/Timesheet-Moose

        private dynamic GetTimesheetCell(DateTime date, string column)
        {
            var rowPosition = new WorkbookNavigator(date, WorksheetDates.GetStartDatesForWorksheets());
            Console.WriteLine("Row: {0}", rowPosition.Row);
            var cell = string.Format("{0}{1}", column, rowPosition.Row);
            var worksheets = excel.Worksheets;
            var sheet = worksheets[rowPosition.SheetName];
            var actualCell = sheet.Range[cell];

            return actualCell;
        }