معرفی شرکت ها

تبلیغات ما

مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.

مشاهده بیشتر

تبلیغات ما

مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.

مشاهده بیشتر

تبلیغات ما

مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.

مشاهده بیشتر

تبلیغات ما

مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.

مشاهده بیشتر

تبلیغات ما

مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.

مشاهده بیشتر

توضیحات

Generating network configuration with Excel sheets which include Jinja2 templates and data tables

ویژگی	مقدار
سیستم عامل	-
نام فایل	excel2config-2023.2.20
نام	excel2config
نسخه کتابخانه	2023.2.20
نگهدارنده	[]
ایمیل نگهدارنده	[]
نویسنده	Umur Arslan
ایمیل نویسنده	-
آدرس صفحه اصلی	-
آدرس اینترنتی	https://pypi.org/project/excel2config/
مجوز	MIT License Copyright (c) 2022 umurarslan Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

# Excel2Config Excel2Config simple CLI tool generates network configuration based on Excel sheets which include Jinja2 template and data tables. --- ## Requirements [Python >= 3.9](https://www.python.org/downloads/) > For Windows, select the **Add Python 3.x to PATH** checkbox during installation. --- ## Installation **Option 1:** From Python Package Index (PyPI) Repo: ``` pip install excel2config ``` **Option 2:** Download project ZIP file and run below command: ``` pip install excel2config-X.zip ``` ### Installation Check After installation **excel2config** command added to **System Path** and can be executed from any path easily as below: ``` > excel2config -h usage: excel2config [-h] [excelfile] positional arguments: excelfile excel file path [e.g. srlinux_config_1.xlsx] (OPTIONAL, default: config.xlsx) options: -h, --help show this help message and exit ``` --- ## Usage ### Simple Usage Run **excel2config** command with **Excel File Path** from any path and check text output files in **Output Folder**: ``` excel2config <Excel_File_Path> ``` Example for Windows: ``` PS C:\Users\alg\desktop> excel2config C:\Users\alg\Desktop\test\config.xlsx 2022-07-17 09:07:40.275 INFO : OUTPUT FOLDER CREATED <OUTPUTS_config_20220717-090740> 2022-07-17 09:07:40.447 INFO : [C:\Users\alg\Desktop\test\config.xlsx] / [<Worksheet "NETWORK_INSTANCE">] START! 2022-07-17 09:07:40.463 INFO : [C:\Users\alg\Desktop\test\config.xlsx] / [<Worksheet "NETWORK_INSTANCE">] DONE! 2022-07-17 09:07:40.479 INFO : ALL DONE! !!! ALL DONE! Press any key to exit... PS C:\Users\alg\desktop> dir OUTPUTS_config_20220717-090740 Directory: C:\Users\alg\desktop\OUTPUTS_config_20220717-090740 Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 17/07/2022 09:07 426 leaf1.txt -a---- 17/07/2022 09:07 258 leaf2.txt PS C:\Users\alg\desktop> ``` ### Excel File > Only **.xlsx** Excel file format supported. > For new features (e.g. Custom Jinja Function) check latest example Excel in project **/examples** folder. In Excel File first sheet is **GLOBAL_VARS**, this sheet optional and only for global template variables such as host-based (**e.g. leaf1**), all-host (**ALL**) and generator (**GEN**). ***GLOBAL_VARS Excel Sheet:*** ![GLOBAL_VARS Excel Sheet](https://raw.githubusercontent.com/umurarslan/excel2config/main/img/img1.PNG) Besides GLOBAL_VARS sheet, other sheets have two parts: - **Jinja2 Template (A2 cell):** Jinja2 "IF", "FOR" and Filters can be used in template cell. - **Data Tables (Header rows start with B2 cell, Variable rows start with B3 cell):** Range and generator supported in variable rows. > Sheet name and Data Header name must have only **[A-Za-z0-9_]** (alphanumeric with underscore) characters and **not start with numeric** characters. > Sheet name starts with underscore "_" will be ignored. (e.g. **_TEST**) As below example Jinja template render with every data table line and append **host** (e.g. leaf1) output text file. ***INTERFACE_CONFIG Excel Sheet:*** ![INTERFACE_CONFIG Excel Sheet](https://raw.githubusercontent.com/umurarslan/excel2config/main/img/img2.PNG) ***INTERFACE_CONFIG "leaf1.txt" outputs:*** ``` interface ethernet 1/1/1 description red_1 no shutdown mtu 1500 vrf member red no ip redirects ip address 10.1.1.100/24 ``` ***OTHER_CONFIG Excel Sheet:*** ![OTHER_CONFIG Excel Sheet](https://raw.githubusercontent.com/umurarslan/excel2config/main/img/img3.PNG) Example Excel file and outputs are in project **/examples** folder. *EOF*

نیازمندی

مقدار	نام
>=3.0	Jinja2
>=3.0	openpyxl

زبان مورد نیاز

مقدار	نام
>=3.9	Python

نحوه نصب

نصب پکیج whl excel2config-2023.2.20:

pip install excel2config-2023.2.20.whl

نصب پکیج tar.gz excel2config-2023.2.20:

pip install excel2config-2023.2.20.tar.gz