Spreadsheet Import: Difference between revisions
No edit summary |
(Updated the Description paragraph in connection with Spreadsheet_Preferences.) |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 18: | Line 18: | ||
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]] |
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]] |
||
|Version=0.17 |
|Version=0.17 |
||
|SeeAlso=[[ |
|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 |
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 36: | Line 36: | ||
<!--T:9--> |
<!--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
- Press the Spreadsheet Import button.
- Choose the right CSV file.
Notes
- Use the Std Import command to import Excel *.xlsx files.
Spreadsheet
- Creation: Create sheet, Import, Export, Merge cells, Split cell, Set alias
- Aligment: Align left, Align center, Align right, Align top, Align vertical center, Align bottom
- Style: Style bold, Style italic, Style underline
- Additional: Preferences
User documentation
- Getting started
- Installation: Download, Windows, Linux, Mac, Additional components, Docker, AppImage, Ubuntu Snap
- Basics: About FreeCAD, Interface, Mouse navigation, Selection methods, Object name, Preferences, Workbenches, Document structure, Properties, Help FreeCAD, Donate
- Help: Tutorials, Video tutorials
- Workbenches: Std Base, Arch, Assembly, CAM, Draft, FEM, Inspection, Mesh, OpenSCAD, Part, PartDesign, Points, Reverse Engineering, Robot, Sketcher, Spreadsheet, Surface, TechDraw, Test Framework
- Hubs: User hub, Power users hub, Developer hub