from typing import Any

from openpyxl.workbook.workbook import Workbook
from openpyxl.worksheet.worksheet import Worksheet


def create_worksheet(values: list[list[Any]]) -> Worksheet:
    """Create sheet from values."""
    workbook = Workbook()
    worksheet: Worksheet = workbook.create_sheet(index=0)
    for row in range(len(values)):
        for column in range(len(values[row])):
            worksheet.cell(row=row + 2, column=column + 1, value=values[row][column])
    return worksheet


def create_workbook(value_list: list[tuple[str, list[list[Any]]]]) -> Workbook:
    """Create workbook from values."""
    workbook = Workbook()
    for sheet_name, values in value_list:
        worksheet: Worksheet = workbook.create_sheet(sheet_name)
        for row in range(len(values)):
            for column in range(len(values[row])):
                worksheet.cell(
                    row=row + 2, column=column + 1, value=values[row][column]
                )

    return workbook