excelactor 0.2.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 (leave empty if you want all sheets searched)

    Specify the folder containing Excel files

    Results will be saved in results.xlsx