Spreadsheet Import: Difference between revisions

From FreeCAD Documentation
No edit summary
(Updated the Description paragraph in connection with Spreadsheet_Preferences.)
 
(11 intermediate revisions by 5 users not shown)
Line 2: Line 2:
<translate>
<translate>


<!--T:6-->
{{Docnav
{{Docnav
|[[Spreadsheet_CreateSheet|CreateSheet]]
|[[Spreadsheet_CreateSheet|CreateSheet]]
Line 10: Line 11:
|IconC=Workbench_Spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}
}}



<!--T:1-->
<!--T:1-->
{{GuiCommand
{{GuiCommand
|Name=Spreadsheet Import
|Name=Spreadsheet Import
|Workbenches=[[Spreadsheet_Module|Spreadsheet]]
|MenuLocation=Spreadsheet → Import spreadsheet
|MenuLocation=Spreadsheet → Import spreadsheet
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]]
|Version=0.17
|Version=0.17
|SeeAlso=[[Spreadsheet_Export|Spreadsheet Export]]
}}
}}


Line 23: Line 24:


<!--T:3-->
<!--T:3-->
The {{Button|[[File:Spreadsheet_Import.svg|16px]] [[Spreadsheet_Import|Spreadsheet Import]]}} tool allows you to import a comma-separated values (CSV) file into a spreadsheet so that it can be modified and used with [[expressions|expressions]].
The {{Button|[[File:Spreadsheet_Import.svg|16px]] [[Spreadsheet_Import|Spreadsheet Import]]}} tool allows you to import a CSV file into a spreadsheet so that it can be modified and used with [[expressions|expressions]]. Note that the {{Value|tab}} character, and not the {{Value|comma}}, is the default field delimiter. But this can be changed in the [[Spreadsheet_Preferences|Spreadsheet Preferences]] ({{Version|0.20}}).


==Usage== <!--T:4-->
==Usage== <!--T:4-->
Line 31: Line 32:
# Choose the right CSV file.
# Choose the right CSV file.


==Notes== <!--T:8-->

<!--T:9-->
* Use the [[Std_Import|Std Import]] command to import Excel {{FileName|*.xlsx}} files.


<!--T:7-->
{{Docnav
{{Docnav
|[[Spreadsheet_CreateSheet|CreateSheet]]
|[[Spreadsheet_CreateSheet|CreateSheet]]
Line 39: Line 47:
|IconC=Workbench_Spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}
}}



</translate>
</translate>

Latest revision as of 20:16, 3 October 2021

Spreadsheet Import

Menu location
Spreadsheet → Import spreadsheet
Workbenches
Spreadsheet
Default shortcut
None
Introduced in version
0.17
See also
Spreadsheet Export

Description

The Spreadsheet Import tool allows you to import a CSV file into a spreadsheet so that it can be modified and used with expressions. Note that the tab character, and not the comma, is the default field delimiter. But this can be changed in the Spreadsheet Preferences (introduced in version 0.20).

Usage

  1. Press the Spreadsheet Import button.
  2. Choose the right CSV file.

Notes

  • Use the Std Import command to import Excel *.xlsx files.