Spreadsheet Import: Difference between revisions

From FreeCAD Documentation
(Marked this version for translation)
(Updated the Description paragraph in connection with Spreadsheet_Preferences.)
 
(9 intermediate revisions by 3 users not shown)
Line 11: Line 11:
|IconC=Workbench_Spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}
}}



<!--T:1-->
<!--T:1-->
Line 19: Line 18:
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]]
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]]
|Version=0.17
|Version=0.17
|SeeAlso=[[Spreadsheet_Export|Spreadsheet Export]]
}}
}}


Line 24: 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 31:
# Press the {{Button|[[File:Spreadsheet_Import.svg|16px]] [[Spreadsheet_Import|Spreadsheet Import]]}} button.
# Press the {{Button|[[File:Spreadsheet_Import.svg|16px]] [[Spreadsheet_Import|Spreadsheet Import]]}} button.
# 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-->
<!--T:7-->
Line 41: 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.