wiki練習場所

import sys
import os
import requests
import time
from bs4 import BeautifulSoup
import re
import numpy as np
import pandas as pd
import datetime
import platform

# selenium
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
from selenium.common.exceptions import TimeoutException
from selenium.webdriver.support.ui import Select
from selenium.webdriver.common.action_chains import ActionChains
from selenium.webdriver.common.keys import Keys

# google
import gspread
from oauth2client.service_account import ServiceAccountCredentials

################################################################################

# 設定
json_file = '' #ここでAPIキーの.jsonを指定

file_name = 'sinosou_weekly_schedule'
sheet_name1 = 'Sheet1'

scope = ['https://spreadsheets.google.com/feeds',
         'https://www.googleapis.com/auth/drive']

dt_now = datetime.datetime.now()
w_list = ['月', '火', '水', '木', '金', '土', '日']

title_text = "*&sizex(4){今日の配信}; [#today_schedule]"

# 読み出し
def read_from_spredsheet():
    # スプレッドシートにアクセス
    credentials = ServiceAccountCredentials.from_json_keyfile_name(json_file, scope)
    gc = gspread.authorize(credentials)
    sh = gc.open(file_name)

    wks = sh.worksheet(sheet_name1)

    # pandasのデータフレームに収納
    df = pd.DataFrame(wks.get_all_records())

    df = df[df["year"]==dt_now.year]
    df = df[df["month"]==dt_now.month]
    df = df[df["day"]==dt_now.day]

    df = df.sort_values('hour')
    df = df.reset_index(drop=True)

    return df

# テキスト生成
def generate_text():

    df = read_from_spredsheet()

    all_text=title_text + "\n" + "%s日(%s)\n"%(dt_now.day, w_list[dt_now.weekday()])

    for i in range(len(df)):
        channel = df["channel"][i]
        summary = df["summary"][i]
        text =  "-" + hour + channel + " " + summary +"\n"

        all_text = all_text + text

    return all_text

# 書き込み作業
def auto_fill_to_wiki(url, all_text):
    # seleniumの立ち上げ
    options = webdriver.ChromeOptions()
    options.add_argument('--lang=ja-JP')
    options.add_argument('--blink-settings=imagesEnabled=false')
    driver = webdriver.Chrome(options=options)

    try:
        driver.get(url)
    except:
        pass

    WebDriverWait(driver, 30).until(EC.presence_of_all_elements_located)
    time.sleep(3)

    texts = driver.find_element(By.NAME, "msg")

    # 前日分の記載を今日分の下行に追加
    prev_text = texts.get_attribute('value').replace("*&sizex(4){今日の配信}; [#today_schedule]","")

    try:
        prev_text = prev_text[:prev_text.find("\n\n")]
    except:
            pass

    all_text = all_text + "\n\n" + prev_text

    # 更新処理
    texts.clear()
    texts.send_keys(all_text)
    time.sleep(10)

    driver.find_element(by=By.XPATH, value='//*[@id="panel:r0:0"]/input[4]').click()

    WebDriverWait(driver, 30).until(EC.presence_of_all_elements_located)
    time.sleep(3)

    driver.close()
    driver.quit()

def main_process():
    url = "https://wikiwiki.jp/sinsogumi/?cmd=edit&page=FrontPage&id=today_schedule"
    all_text = generate_text()

    auto_fill_to_wiki(url, all_text)

main_process()

import datetime
from datetime import datetime as dt
import numpy as np
import pandas as pd


def generate_text():

    df = pd.read_excel("深層組非公式wiki　データ管理置き場.xlsx")

    for i in range(len(df)):
        date_text= df["日付"][i].strftime('%#m/%#d')
        member_name = df["メンバー"][i]
        anniversary = df["記念日"][i]
        countdown_text = df["カウントダウン用"][i]
        text = "-&tomorrow_schedule(period=31, %s){ ''%s'' の ''%s'' です。 3/17 まで ''%s''};"%(date_text, member_name, anniversary, countdown_text)

        print(text)

generate_text()