CSV-tekstifailide avamine ja salvestamine
Comma Separated Values (CSV) is a text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character.
If the field or cell contains a comma, the field or cell must be enclosed by single quotes (') or double quotes (").
CSV-tekstifaili avamiseks Calc'is
-
Vali
. -
Mine soovitud CSV-faili asukohta.
Kui fail on laiendiga *.csv, vali fail.
If the CSV file has another extension, select the file, and then select "Text CSV" in the
box -
Klõpsa
.The
dialog opens. -
Määra failis oleva teksti veergudesse jaotamise sätted.
You can preview the layout of the imported data at the bottom of the
dialog.Veeru peitmiseks või selle vormingu määramiseks tee eelvaates sellel veerul klõps parempoolse hiirenupuga.
Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box.
-
Klõpsa
.
Arvutustabeli salvestamiseks CSV-tekstifailina
Arvutustabeli eksportimisel CSV-vormingusse salvestatakse ainult aktiivsel lehel olevad andmed. Kõik muu teave, kaasa arvatud valemid ja vormindus läheb kaduma.
-
Ava arvutustabeli leht, mida soovid CSV-tekstifailina salvestada.
Eksporditakse ainult aktiivne leht.
-
Vali
. -
In the
box, enter a name for the file. -
In the
box, select "Text CSV". -
Määra CSV-tekstifaili väljade sätted (mittekohustuslik).
Select
.In the
dialog, select the options that you want.Klõpsa
. -
Klõpsa
.