HotXLS Component para aplicativos Delphi de planilhas

Automacao nativa de pastas de trabalho Excel para Delphi e C++Builder

HotXLS Component e uma biblioteca de planilhas Object Pascal com codigo fonte para Delphi e C++Builder. Ela cria novas pastas de trabalho, abre arquivos Excel existentes, altera planilhas, avalia formulas, aplica formatacao e salva o resultado sem iniciar o Microsoft Excel, usar automacao COM ou depender de uma instalacao desktop do Office.

Use quando sua aplicacao precisar gerar pastas de trabalho de forma repetivel, preencher modelos, exportar relatorios, converter arquivos, inspecionar pastas de trabalho ou fazer edicoes round-trip controladas em instaladores, servicos, ferramentas em lote, utilitarios desktop ou aplicacoes de negocio.

Versao atual e cobertura de plataformas

Versao atual do HotXLS: 2.88.108. See the release notes for recent XLS, XLSX, formula, export, template-editing, protection, and round-trip preservation updates.

HotXLS suporta Delphi XE5 até Delphi 13 Florence e C++Builder XE5 até C++Builder 13 Florence. O pacote inclui demos Delphi e C++Builder, documentação de API, exemplos para edição de pastas de trabalho e exportação de relatórios, além do código-fonte completo Object Pascal / Delphi para clientes licenciados.

Duas APIs focadas para pastas de trabalho

Superficie da API	Uso principal
lxHandle	Classic Excel 97-2003 BIFF8 .xls : leitura e escrita de pastas, formulas, formatacao, comentarios, hiperlinks, folhas de grafico, tabelas dinamicas, preservacao de VBA e exportacoes HTML, RTF, CSV e TSV.
lxHandleX	Excel 2007+ OOXML .xlsx : E/S de pastas e streams, paletas de estilos, strings compartilhadas, tabelas, graficos, comentarios, desenhos, links externos, exportacoes XLSX e escrita em streaming para planilhas maiores.

Principais recursos

• Fluxos de pastas XLS e XLSX: create, open, modify, and save Excel workbooks from files or streams, and quickly list sheet names from XLS or XLSX packages without loading every worksheet.
• Edicao de celulas, intervalos e modelos: read and write numbers, strings, dates, booleans, formulas, merged cells, row and column sizes, hidden rows and columns, outlines, selections, and workbook ranges. Callback helpers can scan loaded cells, fill ranges, find text, and replace template placeholders.
• Formatacao e layout de pagina: apply fonts, colors, borders, fills, alignment, number formats, rich text, theme colors, indexed palettes, tab colors, page setup, headers, footers, print titles, page breaks, and worksheet view options.
• Formulas e calculo: evaluate formulas through the built-in calculation engine for classic XLS and XLSX workbooks, including cell references, ranges, cross-sheet references, defined names, and application-defined functions through an OnUserFunction callback.
• Recursos de dados da pasta: work with hyperlinks, internal sheet anchors, defined names, comments, conditional formats, data validation, AutoFilter ranges and criteria, Excel-style tables, document properties, external links, and pivot-table records.
• Imagens, graficos e desenhos: embed images, create worksheet charts and chart sheets, preserve VBA project payloads, and keep Excel-authored OfficeArt connector, solver, shape, and comment metadata stable during round-trip saves where supported.
• Protecao e criptografia: tratam protecao de planilha e pasta, senhas XLS classicas e saida XLSX protegida por AES, mantendo explicitos na documentacao os caminhos de leitura de pacotes criptografados nao suportados.
• Auxiliares de exportacao: export workbooks, worksheets, selected ranges, database tables, and DBGrid content to Excel, HTML, RTF, CSV, and TSV outputs, including HTML table fragments for previews, emails, or web reports.

Projetado para automacao controlada

HotXLS e util quando a automacao do Office nao se encaixa no fluxo de producao. O processamento da planilha fica dentro do processo da aplicacao, reduzindo a dependencia de sessoes desktop interativas e facilitando a implantacao de ferramentas sem supervisao e jobs de servidor.

The library is developed around documented workbook structures and practical Excel interoperability. Recent releases focus on preserving Excel-authored records, workbook metadata, comments, hyperlinks, external-link data, worksheet state, protection options, VBA payloads, table data, AutoFilter state, drawing records, and view settings during open/save round trips. That approach helps applications make targeted edits without unnecessarily rewriting parts of the workbook they do not own.

HotXLS is an independent losLab Software product. Microsoft Excel is not required at runtime, and this page does not claim Microsoft certification, endorsement, or trademark ownership.

Casos de uso comuns

Cenario	Como o HotXLS ajuda
Geracao de relatorios	Create styled workbooks from application data, database tables, DBGrid content, or callback-driven worksheet writers.
Edicao de modelos	Open an existing workbook, find and replace text placeholders, fill ranges, preserve surrounding metadata, and save the edited file.
Inspecao de pastas	Read sheet names, worksheet ranges, document properties, comments, hyperlinks, names, filters, and selected workbook metadata from controlled code.
Exportacao sem Office	Generate Excel-compatible output on machines where Microsoft Office is not installed, including services and unattended batch jobs.
Suporte a pastas antigas e modernas	Use one component family for classic BIFF8 .xls workflows and current OOXML .xlsx workflows.
Fluxos de visualizacao e conversao	Export whole sheets or selected ranges to HTML, RTF, CSV, or TSV for previews, email fragments, imports, and downstream systems.
Fluxos documentais auditaveis	Keep workbook transformations inside your own Delphi or C++Builder code path instead of driving an external UI application.

Avaliacao, licenciamento e suporte

Baixar o pacote demo do HotXLS Delphi Spreadsheet Component to review the demos and API documentation before purchase.

Novas licenças comerciais incluem o código-fonte completo Object Pascal / Delphi, um ano de atualizações, um ano de suporte por email e uso royalty-free em aplicações ilimitadas conforme a licença por desenvolvedores escolhida.

Pay with credit/debit cards, PayPal, AliPay, or wire transfer:
HotXLS Single License ($499)
HotXLS Team/SME License ($999)
HotXLS Enterprise License ($1999)

Comprar renovacao anual for existing licenses. Renewal pricing is listed on the HotXLS purchase page.

Open the HotXLS online documentation or contact losLab Software with licensing and technical questions.