Coverage for pyguymer3/convert_spreadsheet_to_datetime.py: 25%

1#!/usr/bin/env python3 

2 

3# Define function ... 

4def convert_spreadsheet_to_datetime( 

5 val, 

6 /, 

7): 

8 """Convert an Excel spreadsheet date to a timezone-aware :class:`.datetime` 

9 object 

10 

11 This function converts an Excel spreadsheet date (which is an integer) to a 

12 timezone-aware :class:`.datetime` object. 

13 

14 Parameters 

15 ---------- 

16 val : int 

17 the Excel spreadsheet date 

18 

19 Returns 

20 ------- 

21 ans : datetime.datetime 

22 the timezone-aware :class:`.datetime` object 

23 

24 Notes 

25 ----- 

26 Copyright 2017 Thomas Guymer [1]_ 

27 

28 References 

29 ---------- 

30 .. [1] PyGuymer3, https://github.com/Guymer/PyGuymer3 

31 """ 

32 

33 # Import standard modules ... 

34 import datetime 

35 

36 # Import sub-functions ... 

37 from .convert_spreadsheet_to_unix import convert_spreadsheet_to_unix 

38 

39 # Return answer .. 

40 return datetime.datetime.fromtimestamp( 

41 convert_spreadsheet_to_unix(val), 

42 tz = datetime.UTC, 

43 )