外部データへのリンク

Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. The data must be located within a named range.

このコマンドの見つけ方

Choose Sheet - Link to External Data.


外部データソースの URL

Enter the URL or the file name that contains the data that you want to insert, and then press Enter. Alternatively, click Browse button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system.

注マーク

A dialog for CSV data import appears when linking to external CSV file.


使用できる表と範囲

Select the table or the data range that you want to insert. If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and OK button will remain inactive

次の時間間隔で更新

ここで、何秒おきに外部データを読み込んで新しく表示するかを入力します。

ご支援をお願いします!