Hidden Hidden Hidden Hidden
 

GETTING STARTED WITH DIRECT TO EXCEL
SOFTWARE > DIRECT TO EXCEL SOFTWARE >

Overview
If you want to learn how to digitize in instruNet World, and then save a text file to be loaded by a spreadsheet program, post-acquisition, please refer to Saving Data to Excel from instruNet World. If you want to digitize directly into a spreadsheet, while data is being acquired in realtime, please consider the Direct To Excel program, described here. Note that Direct To Excel requires that an iW+ license be installed on your computer. To run Direct To Excel, please proceed with the following steps:

Installation

  1. In order to run Direct To Excel, All of the following must be installed on your computer. If this is not the case, please proceed to the next section.

    • Windows Excel version 8.0 or above (i.e. Microsoft Office 97 or above)
    • Windows OS ≥ Xp
    • instruNet software ≥ 3.0, available at www.instrunet.com/d
    • iW+ license (see www.instrunet.com/plus for details)
  2. If you are not sure these requirements have been satisfied, try running the Direct To Excel program, as described below, and if it runs ok, then you are probably ok.
  3. Exit any currently running instruNet software and select under the Windows START menu: Programs / instruNet / Application Software / Direct To Excel / Direct To Excel.exe. This will run the Direct To Excel program, which is pictured below.



    In summary:

    • Press Channels to configure channels and to enable them for digitizing. To enable a channel for digitizing, click to make rectangle red, as described here.
    • Press Setup to set samples-per-second-per-channel and number-of-points-digitized-per-channel.
    • Press Save to save the setup. Everything you did in the Channels and Setup areas is saved in a .prf file.
    • Next time you run this software, you must press Load to load back your settings.
    • Press Start to start digitizing, and Stop to stop it.
    • For more details on how to use this software, press Help.
    • This program is written in Visual Basic, the source code is included at the below location, and you are welcome to modify it.

      ..Program Files\instruNet\Programming Interfaces\Visual Basic .Net\VB Direct To...
  4. Press the Channels button, select 2 channels for digitizing (i.e. click in small rectangle after channel address, it will turn red), and close the instruNet Network window.
  5. Press the Start button and watch a new spreadsheet window appear and fill with instruNet data, as shown below. When finished, you can save or delete the Excel spreadsheet file.
  6. Close the Direct To Excel program by clicking in the upper right corner.

Learning Direct to Excel

Known Issues

  • If working with Direct To Excel <= v2.0 and it does not work properly (e.g. covers your valid data with zeros within the spreadsheet cells, shows"input string is invalid" message, etc) please:

    1. Visit http://www.instrunet.com/ftp/direct_to_excel/, download the listed zip file (i.e. drag to desktop), expand the zip file, and do as instructed in the ReadMe file to update your Direct To Excel.exe application program.
    2. Update to the latest iNet32.dll, per the instructions here.