蔡宛庭程式交易

import openpyxl #蔡宛庭 輸入import openpyx1處理EXCEL的函式庫 book = openpyxl.load_workbook(r'wb.xlsx') #開啟EXCEL工作簿wb.xlsx print("1. 列出所有工作表名稱") sheetNames=book.sheetnames #所有工作表集合 for name in sheetNames: print(name) print("2. 針對特定工作表, 列出前面數列") sheet = book["python"] for row in sheet.iter_rows(min_row=1, max_row=3, min_col=1, max_col=5, values_only=True): print(row) print("3. 列出工作表所有內容") x = sheet["A1"].value #將A1的年月日存在X sheet["A1"]="蔡宛庭"+x sheet["F1"], sheet["G1"], sheet["H1"], sheet["I1"]="波段H","波段L","部位","損益" sheet["F2"], sheet["G2"], sheet["H2"], sheet["I2"]=sheet["C2"].value, sheet["D2"].value, 0, 0 for row in sheet.iter_rows(min_row=1, max_row=3, min_col=1, max_col=9, values_only=True): print(row) book.save("蔡宛庭.xlsx")

import openpyxl #蔡宛庭 輸入import openpyx1處理EXCEL的函式庫 book = openpyxl.load_workbook(r'wb.xlsx') #開啟EXCEL工作簿wb.xlsx print("1. 列出所有工作表名稱") #sheetNames=book.sheetnames #所有工作表集合 #for name in sheetNames: # print(name) print("2. 針對特定工作表, 列出前面數列") #sheet = book["python"] #for row in sheet.iter_rows(min_row=1, max_row=3, min_col=1, max_col=5, values_only=True): # print(row) print("3. 列出工作表所有內容") #sheet["F1"], sheet["G1"], sheet["H1"], sheet["I1"]="波段H","波段L","部位","損益" #sheet["F2"], sheet["G2"], sheet["H2"], sheet["I2"]=sheet["C2"].value, sheet["D2"].value, 0, 0 #for row in sheet.iter_rows(min_row=1, max_row=3, min_col=1, max_col=9, values_only=True): # print(row) #book.save() from tkinter import * import pygame root = Tk() root.title("劉任昌") root.geometry("500x400...

w3school學習python math random函式庫 import math #林恆郁  輸入數學函式庫 import random #輸入亂數資料庫 x = math.sqrt(2) print(x) #大樂透是49個號碼開出六個 for i in range(6):    x = random.randint(1,49)    print("開出的第" + str(i+1) + "個號碼: " + str(x)) #str是將數字轉成字串string w3school學習python math random截圖 亂數函數主要用在蒙地卡羅模擬分析，用於衍生性金融商品的定價 w3school學習python math random示範影片 python sanke game python sanke game示範影片