devinou971

Excel named table to DataFrame

from openpyxl.worksheet.table import Table
from openpyxl.worksheet.worksheet import Worksheet
import pandas as pd
from openpyxl.utils.cell import range_boundaries

def table_to_dataframe(ws : Worksheet, table_name : str) -> pd.DataFrame:
 if table_name not in ws.tables.keys():

devinou971

import glob 
import json
import os
import shutil

SOURCE_FOLDER = "test_ssas" 
OUTPUT_FOLDER = "test_ssas_copy"

MEASURE_TO_REPLACE = "_tests"
SOURCE_TABLE = "Table"