Word Load Data Direct Into

4597  

Although not trivial it’s perfectly possible to write reports in to MS Word direct from a plugin. The hardest part of the process is working out the format for the API calls.

The interface is well documented on the Microsoft Site, but there are not many example in Lua (unsurprisingly) .

Requires: luacom

Handy Links

Code

Example 1

Using the selection method

require "luacom"
 
word = luacom.CreateObject("Word.Application")
 
local book  = word.documents:Add()
local doc =  word.Selection
word.Visible = true
 
pi = fhNewItemPtr()  -- declare pointer 
pi:MoveToFirstRecord("INDI") -- and set to the first record.
row = 0
while pi:IsNotNull() do
   row = row + 1
   doc:TypeText(fhGetDisplayText(pi))
   doc:TypeParagraph() 
   pi:MoveNext()
end
word.DisplayAlerts = false
fhMessageBox('Loading '..row..' Individuals Complete')
doc = nil
word = nil

Example 2

This using the paragraph method.

require "luacom"

word = luacom.CreateObject("Word.Application")

local book = word.documents:Add()
word.Visible = true
paras = book.Paragraphs:Add()
range = paras.Range
range.Text = ("A Latin Selection")
range.Style = ("Heading 1")
range:InsertParagraphAfter()
paras = book.Paragraphs:Add()
range = paras.Range
range.Text = ([[Nam fabulas mnesarchum comprehensam ne, cu ullum euismod consulatu usu. Eam alii lobortis voluptatum id, denique eligendi pertinax quo ne. Vis congue eirmod ut. Duo probo soleat ex. Elit pertinax abhorreant eu his, ipsum dicam dissentiunt pri id. Kasd erant dolorum id sed, ei vim partem deseruisse, ne mea dico tantas alienum.
Has cu facilisis mediocritatem. Fabellas lucilius vim ex. Mei simul omnium et, wisi vidit ut ius. Ad has erat honestatis. Malis animal aliquid id usu. Nulla utinam appellantur cu qui, scripta sententiae disputando eu nam, ut pri unum labore.
Odio wisi torquatos sea cu. Ut detracto torquatos repudiandae pri. Vim puto solum epicurei at. Per nonummy perpetua similique te, odio platonem ut pri. Mei indoctum prodesset in, eam nisl quaerendum at.
]])
range.Style = ("Normal")
range:InsertParagraphAfter()
word.DisplayAlerts = false
doc = nil
word = nil