python3/bristol.py at main · nogizakapython/python3 · GitHub

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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
#######   bristol 決算ニュース情報取得ツール　###########
#######   新規作成  2024/03/21  ##########
#######   Author  takao.hattori ###########


# 時間を計るライブラリをインポート
import datetime
import re
import os
# WebDriverライブラリをインポート
from selenium import webdriver
from selenium.webdriver.common.by import By
import openpyxl as op
import codecs
from time import sleep
import shutil
import selenium
import sys
from openpyxl.styles.fonts import Font


dt = datetime.datetime.now()
date1 = dt.strftime('%Y%m%d%H%M%S')
date2 = dt.strftime('%Y')
date3 = dt.strftime('%Y%m%d')
w_ymd = dt.strftime('%Y年%m年%d日')


input_file = "bristol" + date1 + ".txt"
out_file = "bristol.txt"
date_str = ""
w_title = ""
base_url = 'https://www.bms.com'
web_url = 'https://www.bms.com/jp/media/press-releases.html'
max_row = 5
base_file = "【IR】検索結果_yyyymmdd.xlsx"
export_file = "【IR】検索結果_" + date3 + ".xlsx"
row_count = 0
write_flag = 0
xpath_str1 = ""
w_url = ""


# Chromeを指定する
driver = webdriver.Chrome()

# Chromeを開いて企業HPにアクセスする
target_url = web_url
try:
    driver.get(target_url)
    sleep(5)
    for t in range(3):
        for i in range(1,11):
            try:
                xpath_str1 = '//*[@id="main-content"]/div[2]/div[2]/div/div[3]/div[' + str(i) + ']'
            except:
                break
            element_str1 = driver.find_element(by=By.XPATH,value=xpath_str1)
            print(element_str1.get_attribute("outerHTML"),file=codecs.open(input_file,'a','utf-8'))

        button_xpath = '//*[@id="main-content"]/div[2]/div[2]/div/div[4]/div[1]/button[3]'
        button1 = driver.find_element(By.XPATH,button_xpath)
        driver.execute_script('arguments[0].click();',button1)

except EnvironmentError as e:
    str100 = e
except:
    str100 = ""

# 画面を閉じる
driver.quit()
file_exist = os.path.isfile(out_file)
if file_exist:
   os.remove(out_file)

shutil.copy2(input_file,out_file)


fileobj = open(out_file,encoding="utf-8")
while True:
    line1 = fileobj.readline()

    line1 = line1.replace("\n","")
    if line1:
        row_count += 1
    else:
        break

    result1 = re.search('zebra-listing-date',line1)
    result2 = re.search("<a href",line1)

    if result1:
       w_array1 = line1.split(">")
       w_ymd = w_array1[1]
       w_ymd = w_ymd.replace('</div','')
    #    print(w_ymd)

    if result2:
       w_array2 = line1.split("=")
       w_urlstr = w_array2[1]
       w_urlstr = w_urlstr.replace(' title',"")
       w_urlstr = w_urlstr.replace('"',"")
       w_url = base_url + w_urlstr
    #    print(w_url)

       w_titlestr = w_array2[5]
       w_titlestr = w_titlestr.replace('"body-1">',"")
       w_titlestr = w_titlestr.replace('</a></div>',"")
       w_titlestr = w_titlestr.replace('<br>',"")
       w_titlestr = w_titlestr.replace('<sup>',"")
       w_titlestr = w_titlestr.replace('</sup>',"")
       w_title = w_titlestr
    #    print(w_title)
        # 検索ワードに「業績」を追加(2024/8/10)
       key_word = r"(業績|決算|株主総会|説明会|IR説明会|中期経営計画|報告書|レポート|財務目標|経営)"
       title_result = re.search(key_word,w_title)
       if title_result:
           wb = op.load_workbook(export_file)
           sh_name = 'BRISTOL-MYERS'
           ws = wb[sh_name]
           ws.cell(row=max_row,column=2).value = w_title
           ws.cell(row=max_row,column=3).value = w_url
           ws.cell(row=max_row,column=4).value = w_ymd
           ws.cell(row=max_row,column=6).value = w_url
           ws.cell(row=max_row,column=6).hyperlink = w_url
           ws.cell(row=max_row,column=6).font = Font(color='0000FF',underline='single')

           max_row += 1
           # エクセルファイルの保存
           wb.save(export_file)