Office Integration

Find the inspiring and ready to use solutions to integrate the Lufft I-BOX with your Office world.

  • Copy measured values to Microsoft Excel
  • Transfer measured values to Microsoft Excel using CSV-Format
  • Transfer values to Microsoft Word using VBA

Copy measured values to Microsoft Excel

Microsoft Excel has a powerful copy-and-paste mechanism. Here is how you can bring measured values from the Lufft I-BOX to you Microsoft Excel sheet.

Required: First install the OUT-App “Table” on your Lufft I-BOX.

Step 1: Open the browser

Step 2: Type in the URL with the necessary parmeters to get your values. To find out how the URL is built, go to the tab “API-help” in the device configuration menu on your Lufft I-BOX.

Step 3: The values are displayed in the browser. Select the table rows you want and “copy” them into the clipboard (menu edit->copy or keyboard-shortcut <strg-c>).

Step 4: Go to your Spreadsheet inside Microsoft Excel and “paste” the values.

Ready. The App “Table” refreshes periodically. So you can leave your browser tab open and always get the latest measured values.

Transfer measured values to Microsoft Excel using CSV-Format

Microsoft Excel has a powerful CSV-Import mechanism. Use this if you want to save Excel files on your file storage server or update the values just by one mouse klick. You don’t have to hassle with Lufft I-BOX user interface in a browser.

Required: First install the OUT-App “CSV” on your Lufft I-BOX.

…t.b.c…..

Transfer values to Microsoft Word using VBA

In Microsoft Word there is VBA (Visual Basic for Applications) builtin. Using VBA, values from the Lufft I-BOX can be transfered to Microsoft Word in the following steps.

Required: First install the OUT-App “CSV” on your Lufft I-BOX.

Step 1: Start VBA inside Microsoft Word

Step 2: Write your VBA-Script to get the data out of your Lufft I-BOX.

As an example, this is a procedure names “GetChannels” that loads channel metadata and inserts them at the current curser position. You can use this little VBA-snippet with copy&paste to your VBA code editor:

Sub GetChannels()
  Const URL$ = "http://<hostname>/ab/index.php/csv/1/api/getchannels"
  Dim txt As String, i As Long, ret As String
  With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", URL, False
    .send
    txt = .responseText
  End With
  Selection.TypeText (txt)
End Sub

Please replace <hostname> with the ip-address or hostname of your Lufft I-BOX.

Step 3: You can call this Procedure from your Microsoft Word document by calling the macro “GetChannels”.

To get real vealues replace the url in the snippet simply by

http://<hostname>/ab/index.php/csv/1/api/getvalues?valueids=73-100

The <valueids> are shown in the GetChannels output. Your can get several values by separating them with commas.