Serial Terminal:

Controlling RealTerm from OpenOffice

RealtermDemo.ods is in Examples on Download page

Most up-to-date demos are installed with Realterm in the Examples folder

 

Contents

OpenOffice macros can access Realterm just like MSOffice. Now you can do easy serial comms using Realterm.

Applications made with OOO can be freely distributed. The example uses OOBasic, but open office scripting also supports Javascript, Python and other scripting languages.

  • There's no easier way to knock up a GUI

  • Send data from cells to a display

  • read A-D data and graph it


A Simple Demo

This demo shows how to

The Excel is more sophisticated at the time of writing, with automatic starting and tracking of spreadsheet changes. Please contribute a better demo!

Download

Public Sub Realterm_Open
Set RT = CreateObject("Realterm.RealtermIntf")
RT.HalfDuplex = True 'so you can see what we send out through the port...
RT.Caption = "Realterm Controlled from OpenOffice Calc"
RT.portopen = True 'port is always closed when starting by automation
RT.SelectTabSheet ("I2C")
End Sub
Public Sub Realterm_Close
If Not isnull(RT) Then RT.Close
Set RT = Nothing
End Sub
Public Sub Realterm_Hide
RT.Visible = Not RT.Visible
End Sub
Public Sub Realterm_SendStringToLED(S As String)

'You need the I2CHelper DLL, and to register it for this to work
'http://www.i2cchip.com/digital_display_module.html#I2CHelper DLL
Dim IH As Object

Set IH = CreateObject("I2CHelper.M5451")
RT.PutString ("YW0000000000") 'this always resets the display
LED_Data = "Y101" + IH.Str2M5451D4(S)
RT.PutString (LED_Data)
End Sub
Public Sub Realterm_SendCellToLED
Dim Sheet As Object
Dim Cell As Object
Doc = StarDesktop.CurrentComponent
Sheet = Doc.Sheets(0)
Cell = Sheet.getCellByPosition(0, 0) '
Realterm_SendStringToLED(str(Cell.Value))
End Sub

back to contents


Using Capture

When you want to get data from an instrument, just capture data to a file with Realterm, then have Scilab read the file. This is a "design pattern" that appears ugly, but has been easy to get going, and sucessful. It is well decoupled, which is what makes it so easy to do.



Simple DataLogging

back to contents


Books

http://api.openoffice.org/TipsAndTricks/external.html

http://www.ooomacros.org/dev.php


Contact Us

crun@users.sourceforge.net

back to contents