Importing peak lists
This example shows the importing of a specific peak evaluation into Microsoft Excel.
  • First you have to know the PEAKEVAL_ID number of the peak evaluation for which you want to query the evaluated peaks. You can find it as “Id” in the Detail lister window of the Main Module, when you click on the peak evaluation data node at the left.
    In this case the Peak Evaluation Id is 3717.
  • Start Microsoft Excel and select its Data / Get external data / New database query menu.
    Select the ODBC alias you have created previously. Make sure that the Query Wizard check box is checked at the bottom, and click OK.
  • Microsoft Excel tries to connect to the database, and displays an SQL Server login dialog box.
    For default HyperLab installations, un-check the Trusted connection check box, and type your user name “sa” as well as the password. Default password for HyperLab 2005 product line is “hlpwd2005”.
    Click OK when you are ready.
  • TheQuery Wizard appears now, where you can select the data table from which the data to be imported. Select PEAK table from the list of tables at the right, then click on the arrow button (“>”) pointing to the right, in order to add all fields of PEAK table to the list of queried fields.
    When you are ready, click Next.
  • Now the very important filter window appears. Here you can select a small subset of the records from the huge amount of peaks stored previously in the database.
    Filtering is performed via specifying a filter condition on the field values of the peak record. Only those peak records will be selected where this condition is met. In our case the condition requires that the peak evaluation of the peaks equals to 3717. To specify this condition, select PEAKEVAL_ID field on the left, “equals” operator at the middle, and type in “3717” to the value field. When you are ready, click Next.
  • At the next step you can specify the sorting criteria. In our case it is advisable to select the energy field “E”, which sorts the peaks of a specific peak evaluation by their peak centroid.
    When you are ready, click
  • At the last step of the Query Wizard, simply click Finish button in order to return the queried data to Microsoft Excel.
  • Excel's worksheet displayed again, requiring you to specify a desti­nation for the queried data.
    Specify the target location, and click OK.
  • Finally, the retrieved data is displayed in Excel, where further processing may be performed on it.
Copyright © 1998-2007 by HyperLabs Software Budapest, Hungary