Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. func columnIndexFromGenericToSpreadsheet(columnIndex int) (string, error) {
  2. return columnIndexFromGenericToSpreadsheetImpl(columnIndex, "ABCDEFGHIJKLMNOPQRSTUVWXYZ")
  3. }
  4.  
  5. func columnIndexFromGenericToSpreadsheetImpl(columnIndex int, spreadsheetColumnIndexList string) (string, error) {
  6. var (
  7. genericColumnIndex = ""
  8. listLength = len(spreadsheetColumnIndexList)
  9. )
  10.  
  11. for {
  12. div := columnIndex / listLength
  13. if div > 0 {
  14. prefix, err := columnIndexFromGenericToSpreadsheetImpl(div, " ABCDEFGHIJKLMNOPQRSTUVWXYZ")
  15. if err != nil {
  16. return "", err
  17. }
  18. genericColumnIndex = prefix + genericColumnIndex
  19. columnIndex -= div * listLength
  20. spreadsheetColumnIndexList = strings.TrimSpace(spreadsheetColumnIndexList)
  21. continue
  22. }
  23.  
  24. remain := columnIndex % listLength
  25. res := spreadsheetColumnIndexList[remain : remain+1]
  26. genericColumnIndex += res
  27. break
  28. }
  29.  
  30. return genericColumnIndex, nil
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement