excel讀取SQL資料庫檔案並以圖形顯示

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">1.目的:抓取SQL資料庫的資料,並透過excel圖形來顯示

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">2.預計要顯示最近200天資料(你可以把天數縮小)

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">3.圖形有三大法人 主力 融資融券 大戶內部人等

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">4.資料如果不能更新那就沒有什麼作用了,你可以透過此網頁下載最新三天的更新,把網頁資料貼到excel再寫到資料庫(可參考讀取15個巳下載15個excel表影片附件中寫入的部份):

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">網址:http://220.134.245.185:8888/webchart/yudownload

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">檔案附件存放在雲端硬碟如下: https://drive.google.com/drive/folders/1W2_6PonfeCRBBnuEO1Uv3shMdVRm41ix?usp=sharing

<span style="-webkit-text-stroke-width:0px; background-color:rgb(255, 255, 255); color:rgb(13, 13, 13); display:inline !important; float:none; font-family:roboto,noto,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-decoration-thickness:initial; text-indent:0px; text-transform:none; white-space:pre-wrap; widows:2; word-spacing:0px">網頁版:http://220.134.245.185:8888/fishnew5/trend 提供2020701~20200923區間的四張資料表的Access檔,並附上Access匯回SQL的短影片,你也可以直接改由Access檔直接做來源

zen2965的部落格

歡迎光臨zen2965在痞客邦的小天地

excel讀取SQL資料庫檔案並以圖形顯示

個人資訊

熱門文章

文章分類

最新文章

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

留言板