LoadExternalExcelFileResults

Structure

LoadExternalExcelFileResults(sFileName, sExcelType, iEventNum, iSeqNum)

Type

Procedure

Description

This procedure will load results from an external Excel file. The results are read and saved to database (as defined from the Mapping worksheet tab or mappings saved from Equipment View...Test Points tab). The Excel file is typically launched previously by using the LaunchExternalExcelFile procedure.

Parameters = 4

sFileName = the file to be read. This should be the full location, including directory/subdirectory + file name + extension.

sExcelType = the Excel type import. These hardcoded values are: '2' = Excel Range, '3' = Excel Cells (the only 2 available options)

iEventNum = the event number where the results should be imported. Typically you can learn this from LookupCurrentEventNum (or LookupFinalEventNum)

iSeqNum = the sequence number to be used for the first row of data imported. For example, if this is the first file being loaded, set this to 1. If you have already loaded 4 rows of data from a previous file and you are calling LoadExternalExcelFileResults to load additional rows, then set iSeqNum to 5.

Example

LoadExternalExcelFileResults("C:\MyDir\MyExcelFile.xls", 1) |