# QtTool

**Repository Path**: iyechen/qt-tool

## Basic Information

- **Project Name**: QtTool
- **Description**: Python pyQt6 做GUI桌面工具。Python处理Excel工具
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 0
- **Created**: 2024-10-13
- **Last Updated**: 2026-01-30

## Categories & Tags

**Categories**: Uncategorized

**Tags**: Python, Excel, 工具, tool, Qt

## README

# Excel Tool (Qt Tool)

A data processing tool for Excel files developed using the Qt framework, providing convenient functions such as opening and saving Excel files, and advanced filtering.

## Features

- **File Operations**: Supports opening and saving Excel files
- **Advanced Filtering**: Provides filtering functions for unique values and duplicate values
- **Data Preview**: Displays Excel data intuitively in a table
- **Sheet Management**: Supports selecting different sheets and loading their column headers
- **Graphical Interface**: User-friendly menu bar and toolbar design

## System Requirements

- Python 3.x
- PyQt5 or PyQt6
- pandas
- openpyxl (for reading and writing Excel files)

## Install Dependencies

```bash
pip install PyQt5 pandas openpyxl
```

## Usage Instructions

### Basic Operations

1. **Open File**: Click "File" → "Open" in the menu bar, or use the toolbar icon to select an Excel file to edit
2. **Save File**: Click "File" → "Save" in the menu bar, or use the toolbar icon to save current data

### Advanced Filtering

1. Click "Tools" → "Advanced Filter" in the menu bar to open the filter dialog
2. Select the sheet to filter
3. Choose the filtering method:
   - **Unique Values Filter**: Remove duplicates and retain only unique records
   - **Duplicate Values Filter**: Retain only duplicated records
4. Choose the processing method:
   - **Filter In Place**: Modify the source data directly
   - **Output to New Location**: Save the filtered results to a new location
5. Click "OK" to execute the filter operation

## Project Structure

```
excelTool/
├── ExcelTool.py      # Main window implementation
├── ExcelFilter.py    # Advanced filter dialog
├── util.py           # Utility functions
├── banner.txt        # Program banner
└── README.md         # This document
```

## Main Modules

### ExcelTool.py
The main window class, providing:
- Creation of menu bar and toolbar
- File open and save functionality
- Entry point for advanced filtering

### ExcelFilter.py
The filter dialog class, providing:
- Sheet selection and column header loading
- Unique and duplicate value filtering
- Preview and saving of filter results

### util.py
General utility functions, providing:
- Text file reading functionality

## License

This project is licensed under an open-source license.

## Contribution Guidelines

Issues and pull requests are welcome to improve this project.