Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- func columnIndexFromGenericToSpreadsheet(columnIndex int) (string, error) {
- return columnIndexFromGenericToSpreadsheetImpl(columnIndex, "ABCDEFGHIJKLMNOPQRSTUVWXYZ")
- }
- func columnIndexFromGenericToSpreadsheetImpl(columnIndex int, spreadsheetColumnIndexList string) (string, error) {
- var (
- genericColumnIndex = ""
- listLength = len(spreadsheetColumnIndexList)
- )
- for {
- div := columnIndex / listLength
- if div > 0 {
- prefix, err := columnIndexFromGenericToSpreadsheetImpl(div, " ABCDEFGHIJKLMNOPQRSTUVWXYZ")
- if err != nil {
- return "", err
- }
- genericColumnIndex = prefix + genericColumnIndex
- columnIndex -= div * listLength
- spreadsheetColumnIndexList = strings.TrimSpace(spreadsheetColumnIndexList)
- continue
- }
- remain := columnIndex % listLength
- res := spreadsheetColumnIndexList[remain : remain+1]
- genericColumnIndex += res
- break
- }
- return genericColumnIndex, nil
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement