質問編集履歴

1

スクリプトを更新しました

2019/08/07 11:34

投稿

donadona999s
donadona999s

スコア16

test CHANGED
File without changes
test CHANGED
@@ -11,6 +11,8 @@
11
11
  どなたか、なぜVBからだとファイルが見つからないかわかりますでしょうか?
12
12
 
13
13
 
14
+
15
+ *スクリプトを変更しました。
14
16
 
15
17
  ---------------------------
16
18
 
@@ -58,38 +60,48 @@
58
60
 
59
61
  import PyPDF2
60
62
 
63
+ import xlwings as xw
61
64
 
62
65
 
63
- with open('part_num.csv') as f:
64
66
 
65
- reader = csv.reader(f)
67
+ def property_check():
66
68
 
67
- for row in reader:
69
+ path = os.getcwd()
68
70
 
69
- filename = row[0]
71
+ path = path + '/part_num.csv'
70
72
 
71
- pdf = PyPDF2.PdfFileReader('DATASHEET/' + filename)
73
+ # print(path)
72
74
 
73
- Pdf_name = filename
75
+ with open(path) as f:
74
76
 
75
- for k in pdf.documentInfo.keys():
77
+ reader = csv.reader(f)
76
78
 
77
- if k == '/ModDate':
79
+ for row in reader:
78
80
 
79
- ModDate = pdf.documentInfo[k]
81
+ filename = row[0]
80
82
 
81
- if k == '/CreationDate':
83
+ pdf = PyPDF2.PdfFileReader('DATASHEET/' + filename)
82
84
 
83
- CreationDate = pdf.documentInfo[k]
85
+ Pdf_name = filename
84
86
 
85
- l = [Pdf_name,ModDate,CreationDate]
87
+ for k in pdf.documentInfo.keys():
86
88
 
87
- print(l)
89
+ if k == '/ModDate':
88
90
 
89
- with open('result.csv', 'a') as f:
91
+ ModDate = pdf.documentInfo[k]
90
92
 
91
- writer = csv.writer(f, lineterminator='\n')
93
+ if k == '/CreationDate':
92
94
 
95
+ CreationDate = pdf.documentInfo[k]
96
+
97
+ l = [Pdf_name,ModDate,CreationDate]
98
+
99
+ # print(l)
100
+
101
+ with open('result.csv', 'a') as f:
102
+
103
+ writer = csv.writer(f, lineterminator='\n')
104
+
93
- writer.writerow(l)
105
+ writer.writerow(l)
94
106
 
95
107
  ```