HotXLS-dokumentation
Innehåll
Startsida
Översikt
XLSX Facade
Startsida
Innehåll
XLSX Facade Overview
Additional XLSX facade API medlemmar
This page covers smaller public API medlemmar declared by lxHandleX, including HTML export options and helper functions for callers that work directly with XLSX cell references or XML payload text
HTML export options
type
TXLSXHtmlExportOptions = class
constructor Create;
property Title: WideString;
property WriteDocument: Boolean;
property IncludeStyles: Boolean;
property IncludeBOM: Boolean;
property TableClass: WideString;
end;
Title
Sets the document title when WriteDocument is True
WriteDocument
When True, writes a complete HTML document. When False, writes only the table fragment
IncludeStyles
Controls whether exported HTML includes generated CSS and inline style information
IncludeBOM
Controls whether file and stream output starts with a UTF-8 BOM
TableClass
Adds a klass CSS name to the generated <table> element
XLSX reference helper functions
function XlsxColumnLabel(Col: Integer): WideString;
function XlsxCellRef(Row, Col: Integer): WideString;
function XlsxColumnIndex(const ColumnLabel: WideString): Integer;
function XlsxParseCellRef(const Ref: WideString; out Row, Col: Integer): Boolean;
function XlsxParseRangeRef(const Ref: WideString; out Row1, Col1, Row2, Col2: Integer): Boolean;
XlsxColumnLabel
Converts a 1-based column index to an A1-style column label such as A, Z, or AA
XlsxCellRef
Builds an A1-style cell reference from 1-based row and column numbers
XlsxColumnIndex
Converts an A1-style column label to a 1-based column index
XlsxParseCellRef
Parses a single A1-style cell reference and returns row and column coordinates
XlsxParseRangeRef
Parses a rectangular A1-style range and returns inclusive 1-based bounds
XLSX XML escape helper functions
function XlsxEscapeText(const Value: WideString): WideString;
function XlsxEscapeAttr(const Value: WideString): WideString;
XlsxEscapeText escapes XML text-node content, while XlsxEscapeAttr escapes XML attribute values and preserves attribute whitespace that Excel must read back exactly
Exempel
var
Ref: WideString;
Row, Col: Integer;
begin
Ref := XlsxCellRef(10, 5);
if XlsxParseCellRef(Ref, Row, Col) then
Worksheet.Cells.Item[Row, Col].Value := 'Checked';
end;
Copyright © 2010-2026 losLab Software