[Google Sheet] 更換檔案而不修改URL

2019-01-09 C.H. Ling Computing, End User Environment 用戶環境, Google Sheet 0

利用Google sheet 修改及share 出去後, 有時若在local 機修改或有大改要換掉檔案的話, 正常upload 會當成另一檔案, URL 亦需要再修改. 其實在sheet 中可以直接將檔案換掉. 

  1. 於Google Sheet 中開啟檔案, 並複制連結作檢查用;
  2. 在Sheet 中選取File > Import;
  3. 選取指定檔案. 示範中會上傳另一檔案.
  4. 選取Replace spreadsheet 後 按Import data;
  5. 匯入後檢查連結是否正確; /edit 後為controller 的parameter, 無需檢查;
        
About C.H. Ling 262 Articles
a .net / Java developer from Hong Kong and currently located in United Kingdom. Thanks for Google because it solve many technical problems so I build this blog as return. Besides coding and trying advance technology, hiking and traveling is other favorite to me, so I will write down something what I see and what I feel during it. Happy reading!!!
Website LinkedIn

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.