-
Notifications
You must be signed in to change notification settings - Fork 0
/
MultiPullDataFromWord.py
61 lines (50 loc) · 2.06 KB
/
MultiPullDataFromWord.py
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
52
53
54
55
56
57
58
59
60
61
import docx
import csv
import tkinter as tk
from tkinter import filedialog
# Create a GUI window
window = tk.Tk()
window.title('Word Table to CSV Converter')
# Create a label for the paths to the Word documents
doc_label = tk.Label(window, text='Path to Word Document(s):')
doc_label.pack()
# Create a listbox to display the chosen Word documents
doc_listbox = tk.Listbox(window, width=50, height=5)
doc_listbox.pack()
# Create a button to open a file dialog to choose the Word documents
def choose_docs():
doc_paths = filedialog.askopenfilenames(filetypes=[('Word Documents', '*.docx')])
doc_listbox.delete(0, tk.END)
for doc_path in doc_paths:
doc_listbox.insert(tk.END, doc_path)
doc_button = tk.Button(window, text='Choose', command=choose_docs)
doc_button.pack()
# Create a label for the output file name
csv_label = tk.Label(window, text='Output File Name:')
csv_label.pack()
# Create an entry field for the output file name
csv_entry = tk.Entry(window, width=50)
csv_entry.pack()
# Create a button to open a file dialog to choose the output file name and convert the Word tables to CSV
def convert():
doc_paths = doc_listbox.get(0, tk.END)
csv_path = csv_entry.get()
if not csv_path.endswith('.csv'):
csv_path += '.csv'
with open(csv_path, 'w', newline='') as f:
writer = csv.writer(f)
for doc_path in doc_paths:
doc = docx.Document(doc_path)
for table in doc.tables:
headers = [cell.text.strip() for cell in table.row_cells(0)]
if 'Vulnerability' in headers and 'Root Cause' in headers and 'Rating' in headers:
for row in table.rows:
writer.writerow([cell.text for cell in row.cells])
result_label.config(text='Conversion complete!')
csv_button = tk.Button(window, text='Convert', command=convert)
csv_button.pack()
# Create a label to show the result of the conversion
result_label = tk.Label(window, text='')
result_label.pack()
# Run the GUI window
window.mainloop()