
4.REFERENCING THE DATABASE USER CUSTOMIZE B-75074EN/04
- 436 -
4.1 OVERVIEW
The following Excel samples for referencing the i CELL database are
available:
Sample 1. Referencing machining result data
As with the Machining Result screen, database information is displayed
as graphs and tables on an Excel sheet. Database information can also
be displayed as CSV data.
File name: RunTimeA.xls
Installation path: %iCELL%\Sample\DataExport\Excel
(%iCELL% is the folder where the
i CELL is installed.)
Sample 2. Referencing workpieces process result data
As with the Workpieces Process Result screen, database information is
displayed on an Excel sheet. However, data is displayed in the CSV
format, and planned count data cannot be input, and no pie chart can be
displayed.
File name: WorkProcA.xls
Installation path: %iCELL%\Sample\DataExport\Excel
4.2 REFERENCING THE ACCESS DATABASE FROM EXCEL
This section describes the method of acquiring data from the Access
database by using a VBA script of Excel and displaying the acquired
data on an Excel sheet.
Specifically, a connection is made to the Access database with ODBC
Direct, then data is acquired using SQL statements through a VBA
script of Excel then is displayed on an Excel sheet. Users who are
familiar with the method need not read this section.
Starting Excel
To display the Excel samples, start Excel by using one of the following
methods:
Method 1
Double-click an Excel sheet to be used.
Method 2
(1) From the menu, select [Start] → [Programs], then select
[Microsoft Excel] to start Excel.
(2) Read an Excel file to be used.
When a dialog box for selecting whether to enable macros appears,
select Enable in either case.
Starting VBEditer
To edit the VBA script of an Excel sample, start VBEditor according to
the procedure below.
From the Excel menu, select [Tool] → [Macro], then select [Visual
Basic Editor] to start VBEditer.