* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Example of creation of a Microsoft Excel BIFF 2.1 files
'---Load BIFF module
Uses "Biff"
Dim Count As Number
Dim OutFile As String
Dim MaxLoops As Long
'---Set a 1Mb buffer. This will speed up writing operations
BIFF_SetBuffer(1024 * 1024)
OutFile = App_SourceName & ".xls"
'---Create the file
BIFF_CreateFile(OutFile)
'---Write some random data
For Count = 1 To MaxLoops
BIFF_WriteNumber(RND(1, 100000), RND(1, 1000), RND(2, 5))
BIFF_WriteText ("Num Is " + TIMER, RND(1, 1000), RND(6, 10))
BIFF_WriteDate (Date$, RND(1, 1000), RND(1, 1), 12)
Next
'---Change some columns and rows size
BIFF_SetColWidth(1, 10, 10)
BIFF_SetRowHeight(1, 80)
'---Close the file
BIFF_CloseFile
