回答編集履歴
1
コード修正
test
CHANGED
|
@@ -4,18 +4,16 @@
|
|
|
4
4
|
|
|
5
5
|
import openpyxl
|
|
6
6
|
|
|
7
|
+
import pandas as pd
|
|
7
8
|
|
|
8
9
|
|
|
9
|
-
book = openpyxl.load_workbook('test.xlsx')
|
|
10
10
|
|
|
11
|
-
|
|
11
|
+
book = openpyxl.load_workbook('test.xlsx') # ['おもちゃ１', 'おかし', 'おもちゃ２']
|
|
12
12
|
|
|
13
|
-
for name in book.sheetnames
|
|
13
|
+
names = [name for name in book.sheetnames if name.find('おもちゃ') >= 0]
|
|
14
14
|
|
|
15
|
-
if name.find('おもちゃ') >= 0:
|
|
16
15
|
|
|
17
|
-
sheets.append(book.get_sheet_by_name(name))
|
|
18
16
|
|
|
19
|
-
pr
|
|
17
|
+
dfs = pd.read_excel('test.xlsx',sheet_name=names)
|
|
20
18
|
|
|
21
19
|
```
|