Find last filled column in openpyxl

[Irv1n]

I work with excel file and know filename and sheet name of this file. How i can search last filled column and insert my data in next column of this file? I work with openpyxl library.

[BashBedlam]

This will illustrate the basic concept.

1 2 3 4 5 6 7 8 9 10 11 12 13 14

from openpyxl import load_workbook   reference_letters = [chr (x) for x in range (65, 91)] workbook_name = 'sample.xlsx' workbook = load_workbook (filename = workbook_name) sheet = workbook.active   for letter in reference_letters :     cell = letter + '1'     if sheet [cell].value == None :         sheet [cell] = 'New Data'         break   workbook.save (filename = 'new_' + workbook_name)

[Pedroski55]

These 2 give you the maximum column and row:

1 2	maxRowSourceFile = sourceFile[sheet].max_row maxColSourceFile = sourceFile[sheet].max_column

This will copy the last column and put it in the column after that.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

def myApp():     import openpyxl       # the folder with the XL file     folder = 'temp'     # the course     course = '20BE'     pathToTT = f'/home/pedro/{folder}/{course}/'     tt = f'{folder}_{course}latestPyMade_newest.xlsx'     sourceFile = openpyxl.load_workbook(pathToTT + tt)     sourceSheetNames = sourceFile.sheetnames     for sheet in sourceSheetNames:               maxRowSourceFile = sourceFile[sheet].max_row         maxColSourceFile = sourceFile[sheet].max_column         print('Maximum row for sheet', sheet, 'is', maxRowSourceFile)         print('Maximum column for sheet', sheet, 'is', maxColSourceFile)               for sheet in sourceSheetNames:               maxRowSourceFile = sourceFile[sheet].max_row         maxColSourceFile = sourceFile[sheet].max_column         for rowNum in range(1, maxRowSourceFile + 1): # +1 to get the last row             # get the value in the last column             last_col_value = sourceFile[sheet].cell(row=rowNum, column=maxColSourceFile).value             # write the value of the last column to the next column             # the values will be written without any kind of formatting             sourceFile[sheet].cell(row=rowNum, column=maxColSourceFile+1, value=last_col_value)       # openpyxl does not have a file.close() open files remain open until your program is finished     savename = 'changed_sourceFile.xlsx'     sourceFile.save(pathToTT + savename)     print('Last column copied to the next column up and saved to', pathToTT + savename)     print('All done!')

For formatting from openpyxl look at:

1 2 3 4 5

from openpyxl.styles import PatternFill from openpyxl.styles import Font from openpyxl.utils import get_column_letter from openpyxl.styles import Alignment  from openpyxl.drawing.image import Image