• Read Excel XLS 2.1, 3.0, 4.0 worksheet files and Excel XLS 5.0, 95, 97, 2000 workbook files.
• Access all sheets in workbook files.
• Receive all text, numbers, etc. you can write in a cell, including formulas!
• Read cell formatting information (font, cell color, border, etc.).
• Seek function for fast access to single cells.
• Write Excel XLS 4.0 worksheet files and Excel XLS 5.0/ 95/ 97/ 2000 workbook files (with any number of sheets in it).
• Easy to write formulas, just as strings: "SUM(A1:A10) / B2 + SIN(0.25)"
• Write cell formatting (font, cell color, border, etc.).
• FAST! Write more than 100,000 cells in less than two seconds!

This component encapsulates an About Box in a non-visual component. It has various string properties to display five different pieces of information in the about box.

Alternatively, the about box can display information extracted from the program's version information resource. This is accessed using a linked TPJVersionInfo component - available from DSP and my website.

Note: The TPJVersionInfo component must be installed before this component.

The About box also displays an icon. This is the icon defined for the application (see the Icon property of TApplication). If no icon has been specified for the application the default Delphi icon is used.

The display attributes and location on the screen can also be customised.

A help file is included that integrates into the IDE for Delphi 3 to 7. It does not integrate with the Delphi 1, 2 and 2005 or later IDEs but can be used independently of the IDE.

This code defines a property editor for properties of type HKEY - i.e. registry root keys. The editor causes a drop-down list of all the registry root keys supported by Delphi to be displayed in the object inspector for any property of type HKEY.

Such a property is exposed by my TPJRegWdwState component (available on DSP or from my website). This property editor is included with current releases of that component.

This unit provides various customisable message dialog box components. Three components are installed on the component palette. They are:

• TPJWinMsgDlg
  This component wraps the Windows MessageBoxIndirect API call and displays a message box based on that provided by Windows. This component will be suitable for most purposes and has the lighter footprint.
• TPJVCLMsgDlg
  This component uses the Delphi VCL CreateMessageDialog function to create a form based message box. (CreateMessageDialog is used by the standard Delphi MessageDlgXXX functions). The component provides more flexibility than either the Delphi functions or TPJWinMsgDlg. It should be used when it is necessary to display buttons or combinations of buttons that are not supported by the WindowsAPI message box or when a finer degree of control over the appearance and behaviour of the message box is required. TPJVCLMsgDlg supports all the features of TPJWinMsgDlg and extends them.
• TPJMessageDialog
  This is an updated version of the component supplied in release 1 of this unit. Various bugs have been fixed and the handling of user icons improved. This component is only provided for backwards compatibility with existing projects that use the old version. It exposes the same properties as the old component. Some of these properties vary from those common to TPJWinMsgDlg and TPJVCLMsgDlg. It is recommended that TPJWinMsgDlg or TPJVCLMsgDlg are used in new projects.

A demo project is included along with an OpenHelp compatible help file that integrates with Delphi 3-7.

TPJVersionInfo is a 32 bit non-visual component for all Win32 versions of Delphi and C++Builder that encapsulates the version information contained in an executable file's resources.

The component reads information from a designated file's VERSIONINFO resource. The required file is specified in the component's FileName property. Setting FileName to the empty string fetches version information for the executable containing the component. The boolean HaveInfo property indicates whether the file contains version information. This component can access variable file information for each language provided in the resource.

Run-time properties enable access to to version information. Properties enable:

• Access to fixed file information, either by field or the whole record.
• Access to the number of translations stored in the version information.
• Selection of the translation for which information is to be returned by other properties.
• Access to the language and code page of the current translation - by code and by name.
• Access to the string file information for the current translation - named properties access the Microsoft-defined string information, while an array property gives access to any string item by name.

The component makes calls to the Windows API. Therefore the version information being read must follow the Microsoft guidelines - be warned that not all software complies!

For detailed information about version information refer to the Win32 SDK.

A help file is provided that integrates with the help system of Delphi 3 to 7. An a-link keyword file is provided for integration with Delphi 6 and 7.

Source code of two demo programs is also provided.

TPJWdwState and TPJRegWdwState are a pair of non-visual components that can save and restore a window's size, position and state between program executions. Key features are:

• The components can automatically restore and save window state when the program starts up and closes down.
• The user can provide an event handler to change the stored window's state, size and position values before the window is restored.
• The components can be instructed to always display a window in the normal state regardless of the saved state.
• The window's saved size can be ignored and the form's design size used (useful for dialog boxes and fixed size windows).
• The window can be kept within the current work area of the desktop.

TPJWdwState stores window information in an ini file while TPJRegWdwState uses the Windows registry.

A help file is included that integrates into the Delphi 3-7 OpenHelp system and can be used stand-alone with Delphi 2005 and later.

A property editor is provided for editing HKEY values (such as the registry root key property of TPJRegWdwState). This editor is also available separately.

---

Added: 23-08-1999/19-12-2005   |  Version: 4.3.1   |  Downloads: 4172/3870/17

---

Author:

Peter D Johnson   [Homepage]   [DSP files]

TPJCBViewer is a simple non-visual component that registers itself as a "Clipboard Viewer". The component triggers an event each time the contents of the clipboard change.

Source and help file included.

A non-visual component that accesses version information resources in a given file. The component can read variable string information for multiple languages where these are supported by the version information resource.

Help file and demos included.

Now believed to be compatible with C++ Builder