Spreadsheet Import/pt-br: Difference between revisions

From FreeCAD Documentation
(Updating to match new version of source page)
(Updating to match new version of source page)
 
Line 20: Line 20:
==Description==
==Description==


The {{Button|[[File:Spreadsheet_Import.svg|16px]] [[Spreadsheet_Import|Spreadsheet Import]]}} tool allows you to import a tab-separated values file (loosely denoted as CSV) 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==
==Usage==
Line 30: Line 30:


* 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.



{{Docnav
{{Docnav
Line 39: Line 40:
|IconC=Workbench_Spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}
}}



{{Spreadsheet_Tools_navi{{#translation:}}}}
{{Spreadsheet_Tools_navi{{#translation:}}}}

Latest revision as of 20:17, 3 October 2021

Other languages:

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.