excelactor 0.1.0

Batch extracting data from many excel files based on input keyword
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

Excelactor

A Rust tool for bulk searching and extracting data from multiple Excel files

Overview

This tool  processes a folder of Excel files (.xlsx), searches for rows containing a specified keyword, and exports the results to an excel file..
Key Features

✔ Bulk processing - Scan multiple Excel files in one operation

✔ Keyword search - Extract rows containing your search term

✔ Fast Performance: Rust's concurrency features are fully utilized for max performance

✔ Merged cell support - Properly handles merged rows/columns

✔ Output is exported as an excel file

Current Status

✅ Implemented:

    Row extraction with keyword matching

    Merged row support

    Multi-threading for fast process



🛠 In Development:

    Column extraction functionality


🛠 How to build (install cargo if you dont already have it):

    cargo install --release excelactor

Usage

    Run the executable(type excelactor in command line)

    Enter your search keyword

    Enter Sheet name

    Specify the folder containing Excel files

    Results will be saved in results.xlsx