Example: /XL/Invoice with Template/Invoice with Template

Online Documentation   -   Statistics   -   FAQ   -   Plugin Parts (All, Dependencies)   -   Class hierarchy

New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1

The list of the   topics,   classes,   interfaces,   controls,   modules,   global methods by category,   global methods by name,   screenshots,   licenses   and   examples.

Platforms to show: All Mac Windows Linux Cross-Platform

/XL/Invoice with Template/Invoice with Template


Required plugins for this example: MBS XL Plugin

You find this example project in your Plugins Download as a Xojo project file within the examples folder: /XL/Invoice with Template/Invoice with Template

This example is the version from Sun, 20th Jan 2018.

Project "Invoice with Template.xojo_binary_project"
Class App Inherits Application
Const kEditClear = "&Löschen"
Const kFileQuit = "Beenden"
Const kFileQuitShortcut = ""
EventHandler Sub Open() RegisterLibXL // create new xls file dim book as new XLBookMBS(false) // load template call book.Load(FindFile("Template.xls")) dim sheet as XLSheetMBS = book.Sheet(0) // create sheet 'dim sheet as XLSheetMBS = book.AddSheet("Sheet1") // Write Customer address call sheet.WriteString 5, 1, "Smith & Co" call sheet.WriteString 6, 1, "First Avenue 123" call sheet.WriteString 7, 1, "12345 New York" call sheet.WriteString 9, 1, "Bob Smith" // Write Header call sheet.WriteString 13, 2, "123-456" call sheet.WriteString 13, 3, "789-123" call sheet.WriteString 13, 4, "UPS" // Write items dim sum as Double = 0 call sheet.WriteNumber 18, 0, 1 call sheet.WriteString 18, 1, "Box of Apples" call sheet.WriteNumber 18, 5, 19.95 call sheet.WriteNumber 18, 6, 19.95*1 sum = sum + 19.95 call sheet.WriteNumber 19, 0, 5 call sheet.WriteString 19, 1, "Box of Peaches" call sheet.WriteNumber 19, 5, 24.95 call sheet.WriteNumber 19, 6, 24.95*5 sum = sum + 24.95*5 // Write Sum call sheet.WriteNumber 29, 6, sum call sheet.WriteNumber 30, 6, 9.99 sum = sum + 9.99 call sheet.WriteNumber 31, 6, sum // Write bank account call sheet.WriteString 34, 2, "Smith & Co" call sheet.WriteString 35, 2, "123456789" // Write Footer call sheet.WriteString 42, 0, "Smith & Co" call sheet.WriteString 43, 0, "First Avenue 12344, LA 12345 New York" call sheet.WriteString 44, 0, "Phone 123-456-789-0, Fax 123-456-789-1, email@test.invalid, www.test.invalid" // write file dim file as FolderItem = SpecialFolder.Desktop.Child("Invoice with Template.xls") if book.Save(file) then file.Launch else MsgBox "Failed to create file."+EndOfLine+EndOfLine+book.ErrorMessage end if quit End EventHandler
Function FindFile(name as string) As FolderItem // Look for file in parent folders from executable on dim parent as FolderItem = app.ExecutableFile.Parent while parent<>Nil dim file as FolderItem = parent.Child(name) if file<>Nil and file.Exists then Return file end if parent = parent.Parent wend End Function
Sub RegisterLibXL() // once you bought a LibXL license, you can put your license key here // see order links on our website // http://www.monkeybreadsoftware.de/xojo/plugin-xls.shtml #if TargetMacOS then XLBookMBS.SetKeyGlobal "your name", "your Mac LibXL license key" #elseif TargetWin32 then XLBookMBS.SetKeyGlobal "your name", "your Windows LibXL license key" #elseif TargetLinux then XLBookMBS.SetKeyGlobal "your name", "your Linux LibXL license key" #endif End Sub
End Class
MenuBar MenuBar1
MenuItem FileMenu = "&Ablage"
MenuItem FileQuit = "#App.kFileQuit"
MenuItem EditMenu = "&Bearbeiten"
MenuItem EditUndo = "&Rückgängig"
MenuItem UntitledMenu1 = "-"
MenuItem EditCut = "&Ausschneiden"
MenuItem EditCopy = "&Kopieren"
MenuItem EditPaste = "&Einfügen"
MenuItem EditClear = "#App.kEditClear"
MenuItem UntitledMenu0 = "-"
MenuItem EditSelectAll = "&Alles auswählen"
End MenuBar
End Project

See also:

The items on this page are in the following plugins: MBS XL Plugin.


💬 Ask a question or report a problem