Spreadsheet CSV: Difference between revisions

From FreeCAD Documentation
(Created page with "The [http://en.wikipedia.org/wiki/Comma-separated_values CSV format] (Comma-Separated Values) is a plain-text format to exchange spreadsheet data. It can usually be imported a...")
 
(<translate>)
Line 1: Line 1:
<translate>
The [http://en.wikipedia.org/wiki/Comma-separated_values CSV format] (Comma-Separated Values) is a plain-text format to exchange spreadsheet data. It can usually be imported and exported by any spreadsheet application such as LibreOffice or Microsoft Excel. Reading and writing to csv format is done with python's built-in [http://docs.python.org/2/library/csv.html csv module].
The [http://en.wikipedia.org/wiki/Comma-separated_values CSV format] (Comma-Separated Values) is a plain-text format to exchange spreadsheet data. It can usually be imported and exported by any spreadsheet application such as LibreOffice or Microsoft Excel. Reading and writing to csv format is done with python's built-in [http://docs.python.org/2/library/csv.html csv module].


== Importing ==
== Importing ==

Importing a .csv file into FreeCAD creates a [[Spreadsheet Spreadsheet|spreadsheet]] object, then fills it with the values from the file.
Importing a .csv file into FreeCAD creates a [[Spreadsheet Spreadsheet|spreadsheet]] object, then fills it with the values from the file.


== Exporting ==
== Exporting ==
Exporting a [[Spreadsheet Spreadsheet|spreadsheet]] object to a .csv file simply writes all the values of the spreadsheet object. Functions, such as "=A3+B5" are written as functions, not resulting values.


</translate>
Exporting a [[Spreadsheet Spreadsheet|spreadsheet]] object to a .csv file simply writes all the values of the spreadsheet object. Functions, such as "=A3+B5" are written as functions, not resulting values.
{{clear}}
<languages/>

Revision as of 20:58, 11 March 2014

The CSV format (Comma-Separated Values) is a plain-text format to exchange spreadsheet data. It can usually be imported and exported by any spreadsheet application such as LibreOffice or Microsoft Excel. Reading and writing to csv format is done with python's built-in csv module.

Importing

Importing a .csv file into FreeCAD creates a spreadsheet object, then fills it with the values from the file.

Exporting

Exporting a spreadsheet object to a .csv file simply writes all the values of the spreadsheet object. Functions, such as "=A3+B5" are written as functions, not resulting values.

Other languages: