Alle Farben

# Change directory to my blog in the most extravagant way.
function blog {
    Set-Location -Path (Join-Path -Path $env:USERPROFILE -ChildPath "code\blog")
}

import openpyxl
import json

# Load the Excel workbook with macros
workbook_path = "Rose Pine Colorscheme.xlsm"
workbook = openpyxl.load_workbook(workbook_path, read_only=True, data_only=True)

# Specify the sheet name where your data is located
sheet_name = "Rosé Pine"

# Get the active worksheet
worksheet = workbook[sheet_name]

# Extract data from the first column (column A) starting from the second row (row 2)
data = []
for row in worksheet.iter_rows(min_row=2, max_col=1, values_only=True):
    cell_value = row[0]
    if cell_value is not None:
        data.append(cell_value)

# Create a dictionary to store the data
data_dict = {"colors": data}

# Save the data as JSON
output_json_path = "output.json"
with open(output_json_path, "w") as json_file:
    json.dump(data_dict, json_file, indent=4)

print("Data extracted and saved as JSON successfully.")

# Create a dictionary to store data from all sheets
all_data = {}

# Loop through all sheets in the workbook
for sheet in workbook:
    # Extract data from the first column (column A) starting from the second row
    data = []
    for row in sheet.iter_rows(min_row=2, max_col=1, values_only=True):
        cell_value = row[0]
        if cell_value is not None:
            data.append(cell_value)

    # Store the data in the dictionary using the sheet name as the key
    # Use sheet.title.encode('utf-8') to encode the sheet name to UTF-8
    all_data[sheet.title.encode('utf-8').decode('utf-8')] = data

# Save all data as JSON with ensure_ascii=False to preserve Unicode characters
output_json_path = "output.json"  # Replace with the desired output path
with open(output_json_path, "w", encoding="utf-8") as json_file:
    json.dump(all_data, json_file, indent=4, ensure_ascii=False)

print("Data from all sheets extracted and saved as JSON successfully.")

# Loop through all sheets in the workbook
for sheet in workbook:
    # Extract data from columns A and B starting from the second row (row 2)
    data = {}
    for row in sheet.iter_rows(min_row=2, max_col=2, values_only=True):
        color_name, color_value = row[0], row[1]
        if color_name is not None and color_value is not None:
            data[color_value] = color_name  # Reversed order

import openpyxl
import colorsys

# Load the Excel workbook with macros
workbook_path = "Rose Pine Colorscheme.xlsm"
workbook = openpyxl.load_workbook(workbook_path, read_only=True, data_only=True)

# Specify the sheet name where your data is located
sheet_name = "Rosé Pine"

# Get the active worksheet
worksheet = workbook[sheet_name]

# Iterate through the rows starting from the second row (row 2)
for row in worksheet.iter_rows(min_row=2, max_col=1, values_only=True):
    cell_value = row[0]
    if cell_value is not None:
        # Convert hex color value to RGB
        hex_color = cell_value.lstrip('#')
        rgb_color = tuple(int(hex_color[i:i+2], 16) for i in (0, 2, 4))

        # Convert RGB to HSL
        r, g, b = [x / 255.0 for x in rgb_color]
        h, l, s = colorsys.rgb_to_hls(r, g, b)

        # Format HSL values as integers in the range 0-360 (hue) and 0-100 (saturation and lightness)
        h = int(h * 360)
        s = int(s * 100)
        l = int(l * 100)

        # Print Hex, RGB, and HSL values
        print(f"Hex: {cell_value}, RGB: {rgb_color}, HSL: {h}, {s}, {l}")

print("Conversion from hex to RGB and HSL completed.")