Editing the exported file, Editing a text or csv file – Konica Minolta PageScope Enterprise Suite User Manual

Page 21

Advertising
background image

Account Manager

3

Account Manager

3-6

2

Note

The exported data can be viewed and edited in a spreadsheet
application. For details, refer to "Editing the exported file" on page 3-6.

2

Note

To open a file for which a password has been set with XLS or XLSX
selected in "File Format", a read password must be entered to open the
file.

Editing the exported file

The exported file can be edited and saved in a spreadsheet application.

2

Reminder

To edit and save an XML file in a spreadsheet application, change the file
format to "XML Spreadsheet", and then save it.

For the procedure to edit a tab-delimited text file (.txt) or a comma-
delimited CSV file (.csv) in a spreadsheet application, see "Editing a text
or CSV file".

Editing a text or CSV file

The following procedure describes how to edit an exported tab-delimited
text or comma-delimited CSV file in Microsoft Excel.

1

Open Microsoft Excel.

2

Open the exported file.

To open a CSV file using Microsoft Excel 2003, select "Import
External Data" - "Import Data" from the Data menu. In the Select
Data Source dialog box, select "All Files" as the file type.

To open a CSV file using Microsoft Excel 2007, click "From Text"
on the Data tab.

The Text Import Wizard appears.

Advertising