Esempi in C# (CSharp) per MooseXLSReports WorkbookNavigator

Esempio n. 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);
        }

Esempio n. 2

File: XLSReport.cs Progetto: 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;
        }