Convert spreadsheet number to column letter

by 
start_index = 1   #  it can start either at 0 or at 1
letter=""
while column_int > 25 + start_index:   
    letter += chr(65 + int((column_int-start_index)/26) - 1)
    column_int = column_int - (int((column_int-start_index)/26))*26
letter += chr(65 - start_index + (int(column_int)))

More Related Contents:

  1. Configure Flask dev server to be visible across the network
  2. Install a Python package into a different directory using pip?
  3. Remove duplicate dict in list in Python
  4. hexadecimal string to byte array in python
  5. How to scp in Python?
  6. Printing all instances of a class
  7. Passing functions with arguments to another function in Python?
  8. Get a list of all the encodings Python can encode to
  9. Python 3.5 – “Geckodriver executable needs to be in PATH”
  10. How do I use pdfminer as a library
  11. How to equalize the scales of x-axis and y-axis in matplotlib
  12. pip is not able to install packages correctly: Permission denied error [duplicate]
  13. Why use sys.path.append(path) instead of sys.path.insert(1, path)?
  14. Vectorized look-up of values in Pandas dataframe
  15. Removing the timestamp from a datetime in pandas dataframe
  16. Why is json.loads an order of magnitude faster than ast.literal_eval?
  17. Python Class Members
  18. How do you get the magnitude of a vector in Numpy?
  19. python order of elements in set
  20. How to safely write to a file?
  21. Script to change ip address on windows
  22. Detect duplicate MP3 files with different bitrates and/or different ID3 tags?
  23. OSError geos_c could not be found when Installing Shapely [duplicate]
  24. Creating a custom categorized corpus in NLTK and Python
  25. TypeError: attack() missing 1 required positional argument: ‘self’
  26. Python: How to sort a list of dictionaries by several values?
  27. Why is my static CSS not working in Django?
  28. printing slowly (Simulate typing)
  29. aiohttp: rate limiting parallel requests
  30. Can variable names in Python start with an integer?

Leave a Comment