Metadata-Version: 2.1
Name: excel_template_app
Version: 0.1.1
Summary: An application for applying Excel templates to transcript data for a research project.
Home-page: https://github.com/larrygrpolanco/transcript-excel-converter
Author: Larry Grullon-Polanco
Author-email: larrygrpolanco@gmail.com
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas
Requires-Dist: xlwings
Requires-Dist: python-docx

# Excel Template App

Excel Template App is a Python-based desktop application designed to streamline the process of converting transcript files to Excel format and applying predefined templates. This tool is particularly useful for research assistants working with transcript data.

## Features

- Convert .docx transcript files to raw Excel format
- Apply Excel templates to processed data
- Batch processing capabilities
- User-friendly graphical interface

## Installation

### Prerequisites

- Python 3.6 or higher
- pip (Python package installer)

### Steps

1. Open a command prompt or terminal.
2. Run the following command to install the Excel Template App:

   ```
   pip install excel_template_app
   ```

## Usage

After installation, you can run the application using one of the following methods:

1. From the command line:
   ```
   excel_template_app
   ```

2. From Python:
   ```python
   from excel_template_app import ExcelTemplateApp
   import tkinter as tk

   root = tk.Tk()
   app = ExcelTemplateApp(root)
   root.mainloop()
   ```

## Application Workflow

1. **Stage 1: Transcript to Raw Excel**
   - Select multiple .docx transcript files
   - Process the transcripts to convert them to raw Excel format
   - View processing results in the application window

2. **Stage 2: Apply Template**
   - Select an Excel template file
   - Select multiple raw Excel files generated from Stage 1
   - Apply the template to all selected files
   - Choose a directory to save the processed files

## Troubleshooting

- If you encounter any issues, ensure you have the latest version of the app:
  ```
  pip install --upgrade excel_template_app
  ```
- Check that all dependencies are correctly installed
- For persistent problems, please contact [Your Contact Information]

## Contributing

If you'd like to contribute to the project, please contact me

## License

This project is licensed under the MIT License - see the LICENSE file for details.

## Contact

Larry Grullon-Polanco - larrygrpolanco@gmail.com

Project Link: https://github.com/larrygrpolanco/transcript-excel-converter
