Editing the exported file, Editing a text or csv file – Konica Minolta PageScope Net Care Device Manager User Manual

Page 48

Advertising
background image

Device List

3

Device Manager

3-18

6

In the Download complete dialog box, click the [Close] button.

The exported data is saved in the specified location.

2

Reminder

The exported data can be viewed and edited in a spreadsheet application
or text editor.

For details on editing the export file in a spreadsheet application, refer to
"Editing the exported file" on page 3-18.

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, specify the file
type 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 the spreadsheet application.

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.

3

Specify the format of data to be delimited, and then the [Next] button.

As the data format of the original data, select data separated with
delimiters such as a comma and tab.

As the line where scanning starts, select "1"

Select "UTF-8" as the character code.

Advertising
This manual is related to the following products: