Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def getdata(n):
- n -= 1
- alphabet = ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
- rows = 1000000000
- columns = []
- current_column = 1
- current_row_first_val = 1
- for x in range(1,rows+1):
- if n < (x*702):
- current_column = x
- if x > 1:
- current_row_first_val = x*702-701
- index = current_row_first_val - n
- else:
- index = n
- break
- for x in alphabet:
- columns.append(x)
- for x in alphabet:
- for y in alphabet:
- columns.append(x+y)
- return str(current_column)+columns[index]
Add Comment
Please, Sign In to add comment