Apache OpenOffice Community Forum

Code: Select all

"""This script is to create a macro for libreoffice calculator, in order to calculate the final score of a single
student."""

import uno
import openpyxl
import os
from openpyxl.utils import column_index_from_string



def score_cal(col, row, N):  # get the coodinate of the first cell in the format like 'C4', and N is the number of weeks
    desktop = XSCRIPTCONTEXT.getDesktop()
    model = desktop.getCurrentComponent()    # access the current writer document
    sheet = model.CurrentController.ActiveSheet
    startingCol = column_index_from_string(col)  # Get the column index
    count_A = 0  # initial grades count to 0
    count_B = 0
    count_C = 0
    count_D = 0
    count_K = 0
    count_J = 0
    for col in sheet.iter_cols(min_row=row, min_col=startingCol, max_col=startingCol + N * 2,
                               max_row=row):
        for cell in col:
            if cell.value == 'A':
                count_A = count_A + 1
            elif cell.value == 'B':
                count_B = count_B + 1
            elif cell.value == 'C':
                count_C = count_C + 1
            elif cell.value == 'D':
                count_D = count_D + 1
            elif cell.value == 'K':
                count_K = count_K + 1
            elif cell.value == 'J':
                count_J = count_J + 1
    final_score = int((count_A * 95 + count_B * 85 + count_C * 75 + count_D * 65) / N  - count_K * 5 - count_J)
    return final_score