Metadata-Version: 2.2
Name: excel-dropdown-tool
Version: 1.0.0
Summary: Excel file processor with dynamic dropdown creation
Home-page: https://github.com/romin23/automate-excel-data-validation
Author: Romin Katre
Author-email: romin.katre32.rk@gmail.com
License: MIT
Keywords: excel dropdown automation openpyxl xlsxwriter
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Intended Audience :: Developers
Classifier: Topic :: Office/Business :: Financial :: Spreadsheet
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Requires-Python: >=3.6
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: numpy==2.2.3
Requires-Dist: openpyxl==3.1.5
Requires-Dist: pandas==2.2.3
Requires-Dist: python-dateutil==2.9.0.post0
Requires-Dist: pytz==2025.1
Requires-Dist: six==1.17.0
Requires-Dist: tzdata==2025.1
Requires-Dist: XlsxWriter==3.2.2
Requires-Dist: et_xmlfile==2.0.0
Dynamic: author
Dynamic: author-email
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: keywords
Dynamic: license
Dynamic: requires-dist
Dynamic: requires-python
Dynamic: summary

# Excel Dropdown Tool

  

A Python package for automating dropdown creation in Excel files while preserving formatting and formulas.

  

  

## Features

  

- 🚀 Batch process multiple Excel files

- 📊 Maintain original formatting and merged cells

- ⚙️ Dynamic dropdown creation from configuration sheets

- ✅ Microsoft Excel compatibility guaranteed

- 📁 CLI interface for easy automation

  

## Requirements

  

- Python 3.6+

- Microsoft Excel (for proper dropdown visualization)

- Packages:

-  `openpyxl>=3.0.0`

-  `xlsxwriter>=3.0.0`

  

## Installation

  

### From PyPI

  

```bash

pip  install  excel-dropdown-tool
```

  

Note:  Processed  files  work  best  in  Microsoft  Excel.  Other  spreadsheet  applications (e.g., LibreOffice,  Google  Sheets) may not display dropdowns correctly.

  

### Usage

Command-Line  Interface (CLI)

Process  all  Excel  files  in  a  folder:

```bash

excel-dropdown  --input-folder path/to/your/excel/files
```
  
  

### Command Options

```bash

$  excel-dropdown  --help

usage:  excel-dropdown [-h] --input-folder INPUT_FOLDER
Process  Excel  files  with  dropdown  validations

options:

-h,  --help  show  this  help  message  and  exit

--input-folder  INPUT_FOLDER

Path  to  folder  containing  Excel  files  to  process
```
  

### Output Structure

Processed  files  are  saved  in
```
your-input-folder/
	└──  processed_files/
	├──  processed_file1.xlsx
	└──  processed_file2.xlsx
```

## License

**MIT License**  
Copyright (c) 2025 Romin Rajesh Katre

For full license terms, see  [LICENSE](https://license/).
