Spreadsheet Import: Difference between revisions

From FreeCAD Documentation
(Added info about *.xlsx.)
(Updated the Description paragraph in connection with Spreadsheet_Preferences.)
 
(8 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=[[Std_Import|Std Import]]
|SeeAlso=[[Spreadsheet_Export|Spreadsheet Export]]
}}
}}


Line 25: 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 33: Line 32:
# Choose the right CSV file.
# Choose the right CSV file.


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


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



<!--T:7-->
<!--T:7-->
Line 46: 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.