External Links

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.

āĻāĻ‡ āĻ¨āĻŋāĻ°ā§āĻĻā§‡āĻļāĻžāĻŦāĻ˛ā§€āĻ¤ā§‡ āĻ¸āĻ¨ā§āĻ¨āĻŋāĻŦā§‡āĻļ āĻ•āĻ°āĻ¤ā§‡...

From the menu bar:

Choose Sheet - External Links.

From the tabbed interface:

Choose Data - External Links.

From toolbars:

Icon External Links

External Links


āĻŦāĻšāĻŋāĻƒāĻ¸ā§āĻĨ āĻĄāĻžāĻŸāĻž āĻ‰ā§ŽāĻ¸ā§‡āĻ° 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.

note

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

āĻĒā§āĻ°āĻ¤ā§āĻ¯ā§‡āĻ•āĻŸāĻŋ āĻšāĻžāĻ˛āĻ¨āĻžāĻ—āĻžāĻĻ āĻ•āĻ°āĻž āĻšāĻŦā§‡

āĻŦāĻ°ā§āĻ¤āĻŽāĻžāĻ¨ āĻ¨āĻĨāĻŋāĻ¤ā§‡ āĻŦāĻšāĻŋāĻƒāĻ¸ā§āĻĨ āĻĄāĻžāĻŸāĻž āĻĒā§āĻ¨āĻ°āĻžāĻ¯āĻŧ āĻ˛ā§‹āĻĄ āĻ•āĻ°āĻžāĻ° āĻĒā§‚āĻ°ā§āĻŦā§‡ āĻ•āĻ¤ āĻ¸ā§‡āĻ•ā§‡āĻ¨ā§āĻĄ āĻ…āĻĒā§‡āĻ•ā§āĻˇāĻž āĻ•āĻ°āĻ¤ā§‡ āĻšāĻŦā§‡ āĻ¤āĻž āĻ¸āĻ¨ā§āĻ¨āĻŋāĻŦā§‡āĻļ āĻ•āĻ°āĻžāĻ¨āĨ¤

Please support us!