excel2table2.py

# converts excel spreadsheet to double quotation 

import pandas as pd

def write2textSingle(file_name):
    df = pd.read_excel(file_name) 
    numOfRows = df.shape[0]
    numOfColumns = df.shape[1]
    #print(numOfRows)
    #print(numOfColumns)
    #if 5 == numOfColumns -1:
    #    print("BRUH!")

    #print(df.loc[0][1])
    #print(len(df.loc[0]))

    #first_cell_empty = False
    #wb_obj = openpyxl.load_workbook(file_name)
    #sheet_obj = wb_obj.active
    #cell_1_1 = sheet_obj.cell(row = 1, column = 1)
    #if cell_1_1.value == None:
    #    print("BRUUUH!")
    #    first_cell_empty = True

    #print(cell_1_1.value)


    f = open("output.txt", "w")
    f.write("{| class=\"wikitable\"\n")
    count = 0
    for col in df.columns:
        #print(count)
        if count == 0:
            f.write("! " + col)
        elif count != 0 and count != numOfColumns - 1:
            f.write(" !! " + col)
        elif count == numOfColumns - 1:
            print("Reaches here!")
            f.write(" !! " + col + "\n|-\n") 
        count = count + 1  
    for i in range(numOfRows):     
        for x in range(numOfColumns):
            #if first_cell_empty == False:
                if x == 0:
                    f.write("| " + str(df.loc[i][x]) + "\n| ")
                elif x != 0 and x != numOfColumns - 1:
                    f.write(str(df.loc[i][x]) + "\n| ")
                elif x == numOfColumns - 1:
                    print("Reaches herw!")
                    f.write(str(df.loc[i][x]) + "\n|-\n")
            #elif first_cell_empty == True:
            #    if x == 0:
            #        f.write("! " + str(df.loc[i][x]) + "\n|| ")
            #    elif x != 0 and x != numOfColumns - 1:
            #        f.write(str(df.loc[i][x]) + " || ")
            #    elif x == numOfColumns - 1:
            #        print("Reaches herw!")
            #        f.write(str(df.loc[i][x]) + "\n|-\n")
    f.write("|} \n")