Secret Page 2

https://manus.im/share/file/104b5d27-8b5b-4602-87ce-52b59941d830

<thead>

<tr>

<th style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;">Top Level</th>

<th style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;">Subpage</th>

<th style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;">Sub-Subpage</th>

<th style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;">Comments</th>

<th style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;">Links</th>

<th style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;">Description</th>

</tr>

</thead>

<tbody>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; ">Quicklinks, Shortcut to Directory, News Blog</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #D9E1F2;">About</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #D9E1F2;">Corporate Culture</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #D9E1F2;">Org Chart</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">Policies</td>

</tr>

<tr>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">Finance</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">Onboarding</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">1-2 Weeks</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">2-4 Weeks</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">Professional Development</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FFF2CC;">Devices</td>

</tr>

<tr>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FCE4D6;">Contact</td>

</tr>

<tr>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #FCE4D6;">By Location</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; ">Operations</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; ">Accounts Receivable</td>

</tr>

<tr>

<td style="border: 1px solid #ddd; padding: 8px; text-align: left; ">Accounts Payable</td>

</tr>

<tr>

</tr>

<tr>

</tr>

</tbody>

</table>

import pandas as pd

from openpyxl import load_workbook

# Load the Excel file

excel_file = "/home/ubuntu/Sample_Sitemap.xlsx"

wb = load_workbook(excel_file)

sheet = wb.active

# Read data and colors

data = []

colors = []

# Get headers

headers = [cell.value for cell in sheet[1]]

for row_idx in range(2, sheet.max_row + 1):

row_data = []

row_colors = []

for col_idx, cell in enumerate(sheet[row_idx]):

row_data.append(cell.value if cell.value is not None else '')

if cell.fill.patternType == 'solid':

# Get the RGB color from the fill object

rgb_color = cell.fill.fgColor.rgb

if rgb_color and len(rgb_color) == 8: # ARGB format

hex_color = '#' + rgb_color[2:] # Remove alpha channel

elif rgb_color and len(rgb_color) == 6: # RGB format

hex_color = '#' + rgb_color

else:

hex_color = ''

row_colors.append(f'background-color: {hex_color};')

else:

row_colors.append('')

data.append(row_data)

colors.append(row_colors)

# Generate HTML table with inline styles

html_content = """<table style="width:100%; border-collapse: collapse;">

<thead>

<tr>

"""

for header in headers:

html_content += f" <th style=\"border: 1px solid #ddd; padding: 8px; text-align: left; background-color: #f2f2f2; color: #555;\">{header}</th>\n"

html_content += """ </tr>

</thead>

<tbody>

"""

for r_idx, row_data in enumerate(data):

html_content += " <tr>\n"

for c_idx, cell_value in enumerate(row_data):

style = colors[r_idx][c_idx]

html_content += f" <td style=\"border: 1px solid #ddd; padding: 8px; text-align: left; {style}\">{cell_value}</td>\n"

html_content += " </tr>\n"

html_content += """ </tbody>

</table>"""

# Save the HTML to a file

with open("/home/ubuntu/sitemap_google_sites.html", "w") as f:

f.write(html_content)

# Also provide the CSS for general styling, though inline is used for colors

css_content = """

body {

font-family: Arial, sans-serif;

margin: 20px;

background-color: #f4f4f4;

}

h1 {

color: #333;

}

table {

width: 100%;

border-collapse: collapse;

margin-top: 20px;

background-color: #fff;

box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);

}

th, td {

border: 1px solid #ddd;

padding: 8px;

text-align: left;

}

th {

background-color: #f2f2f2;

color: #555;

}

tr:nth-child(even) {

background-color: #f9f9f9;

}

"""

with open("/home/ubuntu/sitemap_google_sites.css", "w") as f:

f.write(css_content)