Python workbooknavigator 예제들

예제 #1

def filter_by__current_worksheet_month(day, raw_hours):
    workbook = workbooknav.workbooknavigator(day)
    month = max(1, workbook.startofmonthnumber)

    hours = filter_by_month(raw_hours, month)
    hours.extend( filter_by_month(raw_hours, month - 1) )
    return hours

예제 #2

파일: xlsreport.py 프로젝트: charlesarmitage/Timesheet-Moose

	def gettimesheetcell(self, day, column):
		rowposition = workbooknav.workbooknavigator(day)
		cell = "%s%s" % (column.upper(), rowposition.row())
		print rowposition.sheetname()
		print cell
		sheet = self.workbook.Sheets(rowposition.sheetname())
		actualCell = sheet.Range(cell)
		return actualCell

예제 #3

 def gettimesheetcell(self, day, column):
     rowposition = workbooknav.workbooknavigator(day)
     cell = "%s%s" % (column.upper(), rowposition.row())
     print rowposition.sheetname()
     print cell
     sheet = self.workbook.Sheets(rowposition.sheetname())
     actualCell = sheet.Range(cell)
     return actualCell

예제 #4

파일: test_hours_filtering.py 프로젝트: charlesarmitage/Timesheet-Moose

 def test_will_use_default_date_from_workbooknav(self):
     workbook = workbooknav.workbooknavigator(datetime(3000, 3, 22))
     
     assert workbook.startofmonthnumber == 0
     assert workbook.sheet_name == "January"
     assert workbook.startofmonthdate == datetime(datetime.now().year, 1, 1)

예제 #5

    def test_will_use_default_date_from_workbooknav(self):
        workbook = workbooknav.workbooknavigator(datetime(3000, 3, 22))

        assert workbook.startofmonthnumber == 0
        assert workbook.sheet_name == "January"
        assert workbook.startofmonthdate == datetime(datetime.now().year, 1, 1)