OpenOffice.org OpenOffice - 3.3 Guia Básico descarregar pdf (Página 21)

100

101

Opening CSV files

Comma-separated-values (CSV) files are text files that contain the cell contents of a

single sheet. Each line in a CSV file represents a row in a spreadsheet. Commas,

semicolons, or other characters are used to separate the cells. Text is entered in

quotation marks; numbers are entered without quotation marks.

To open a CSV file in Calc:

1) Choose File > Open.

2) Locate the CSV file that you want to open.

3) If the file has a *.csv extension, select the file and click Open.

4) If the file has another extension (for example, *.txt), select the file, select Text

CSV (*csv;*txt;*xls) in the File type box (scroll down into the spreadsheet

section to find it) and then click Open.

5) On the Text Import dialog (Figure 16), select the Separator options to divide

the text in the file into columns.

You can preview the layout of the imported data at the bottom of the dialog.

Right-click a column in the preview to set the format or to hide the column.

If the CSV file uses a text delimiter character that is not in the Text delimiter

list, click in the box, and type the character.

Figure 16: Text Import dialog, with Comma (,) selected as the separator and double

quotation mark (“) as the text delimiter.

Chapter 1 Introducing Calc 21

1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 433 434

Comentários a estes Manuais

Sem comentários

OpenOffice.org OpenOffice - 3.3 Guia Básico Página 21

Comentários a estes Manuais

Manuais e produtos relacionados com Software OpenOffice.org OpenOffice - 3.3