contact me at:

Email: khaledsfax03@gmail.com

LinkedIn: linkedin.com/in/khaledkammoun

GitHub: github.com/KhaledKammoun

Excel2XML

Excel2XML is a powerful and user-friendly tool designed to convert XML files to Excel and vice versa. This tool is particularly useful for Archicad users, allowing seamless integration with the Classification Manager.

Features

Convert XML to Excel: Easily transform XML data into an organized Excel file. Convert Excel to XML: Generate XML files from structured Excel data, suitable for use in Archicad's Classification Manager. User-Friendly Interface: Intuitive and easy to navigate.

Requirements

Python 3.12 or higher Libraries: tkinter, pandas, lxml

Installation

Extract the Zip File: Download and extract the provided zip file. Navigate to the Directory: Open your terminal or command prompt and navigate to the extracted folder.

Usage

1. Run the Application:

python template.py

2. Using the Interface:

• Convert XML to Excel: Click the "Convert XML to Excel" button and select your XML file.
• Convert Excel to XML: Click the "Convert Excel to XML" button and select your Excel file. Ensure the Excel file contains the following columns in the first row: ID, Name, Description, Level (with Level being 1, 2, 3, ...).

Sample Data

The Excel file must contain the following columns in the first row:

• `ID`
• `Name`
• `Description`
• `Level`

Example:

ID	Name	Description	Level
1	Item1	Description1	1
2	Item2	Description2	2
3	Item3	Description3	2
4	Item4	Description4	2
5	Item5	Description5	3
6	Item6	Description6	3
7	Item7	Description7	3
8	Item8	Description8	3
9	Item9	Description9	3
10	Item10	Description10	2
11	Item11	Description11	1

Here is a simple flow chart:

graph TD;
    X --> Item_1_Level_1;
    Item_1_Level_1 --> Item_2_Level_2;
    Item_1_Level_1 --> Item_3_Level_2;
    Item_1_Level_1 --> Item_4_Level_2;

    Item_2_Level_2 --> Item_5_Level_3;
    Item_2_Level_2 --> Item_6_Level_3;

    Item_3_Level_2 --> Item_7_Level_3;
    Item_3_Level_2 --> Item_8_Level_3;
    Item_3_Level_2 --> Item_9_Level_3;
    Item_1_Level_1 --> Item_10_Level_2;
    X --> Item_11_Level_1;

Loading

Screenshots

Main Page

Convert EXCEL TO XML

Convert XML TO EXCEL

Contribution

We welcome contributions to improve the functionality and usability of this tool. Please fork the repository and submit your pull requests.

License

This project is licensed under the MIT License.

Contact

For any queries or feedback, please contact me at:

Email: khaledsfax03@gmail.com

LinkedIn: linkedin.com/in/khaledkammoun

GitHub: github.com/KhaledKammoun

COPYRIGHT

EXCEL2XML is released into the public domain by the copyright holders.

This README file was originally written by Khaled Kammoun and is likewise released into the public domain.