sgcDocs Feature Matrix

Everything sgcDocs does, grouped by component. sgcDocs is included in sgcUI Enterprise and All-Access. It is not sold on its own, every feature is in every license, and there is no Community edition. It needs no Office installation and no UI framework, and runs on Windows and Linux64.

Components

7 components

Word Documents

10 features

Mail Merge

7 features

Spreadsheet

10 features

PDF Processor

8 features

Barcode

4 features

ZIP Archive

5 features

Converter

6 features

Platforms and Deployment

Delphi, C++ Builder and .NET

Components

ComponentDetails
TsgcDocsWordProcessorLoads, creates, edits and saves Word documents: DOCX, RTF, HTML, Markdown and text in and out, PDF, PNG and SVG pages, search and replace, fields, mail merge and protection.
TsgcDocsMailMergeThe mail merge engine of the Word processor, with MERGEFIELD and IF fields, regions and the CSV, JSON, dataset and event data sources.
TsgcDocsSpreadsheetLoads, creates, calculates and saves workbooks: XLSX, ODS and CSV in and out, formulas, formats, merged cells, charts, page setup, and PDF, HTML and PNG output.
TsgcDocsPDFProcessorOpens, edits and writes PDF files: pages, text, PNG pages, encryption, forms, PDF/A, digital signatures, and HTML and images to PDF.
TsgcDocsBarcode11 linear and 2D barcode kinds as PNG, SVG or PDF, or drawn on a PDF page.
TsgcDocsZipArchiveZIP archives with ZIP64, UTF-8 names, entry metadata, progress and protection against path traversal.
TsgcDocsConverterOne call conversion between the formats above, by file extension or by stream.

Word Documents

FeatureDetails
FormatsReads and writes DOCX, RTF, HTML, Markdown and text; dfAuto detects the format from the file extension and the content.
Document modelParagraphs, styles, lists, tables, images, sections, headers and footers, fields, footnotes, endnotes and bookmarks, through the document model of sgcRichEdit.
Building documentsAppendParagraph with a style name such as Heading 1, AppendTable, AppendImage (PNG, JPEG, GIF, BMP and SVG), page breaks and section breaks.
PDF exportExportToPDFFile writes the laid out pages, tagged with the structure of headings, lists and tables by default, and as PDF/A when you ask for it.
PNG and SVG pagesExportPageToPNG at 1 to 2400 dpi and ExportPageToSVG for one page at a time.
Search and replaceSearchText and ReplaceAll in the body, the tables, the headers, the footers, the footnotes and the endnotes. The replacement keeps the character format of the match.
FieldsUpdateFields updates DATE, TIME, PAGE and NUMPAGES, and RemoveFields unlinks every field.
Page numbers and notesPage numbering per section with a start value and decimal, roman or letter formats, and one mark format for the footnotes and another for the endnotes.
ProtectionRead only, comments, tracked changes and forms protection that Word enforces. New passwords are stored as a salted SHA-512 hash, and CheckPassword also checks the legacy hash of Word 2007 documents.
FontsAddFontFile and AddFontFolder add TrueType fonts for layout and for the PDF, PNG and SVG output, for servers with few fonts.

Mail Merge

FeatureDetails
TemplatesAn ordinary DOCX made in Word with MERGEFIELD fields, or a document built in code with AppendField. Fields in headers, footers, footnotes, endnotes and table cells are merged too.
SwitchesUpper, lower, first capital and title case, number pictures such as \# ,0.00, date pictures such as \@ "MMMM d, yyyy", and text before or after a value that is not empty.
IF fieldsComparisons with = <> < > <= >=, numeric or text, wildcards, and nested fields in the operands and in the texts.
RegionsA region from TableStart:Name to TableEnd:Name repeats table rows, or paragraphs and tables, once per child record. Regions nest.
Data sourcesTsgcDocsMergeJSON, TsgcDocsMergeCSV, TsgcDocsMergeDataSet for any TDataSet with master and detail relations, and TsgcDocsMergeEvents for data your application holds.
OutputMailMerge writes every record into one document with a section break, a page break or nothing between the records. MailMergeEach writes one file per record, PDF included, with the record number and field values in the file name.
OptionsFields without a value are removed, kept or reported as an error. Fields can keep their updated results so the document can be merged again, empty paragraphs can be removed and values trimmed.

Spreadsheet

FeatureDetails
FormatsXLSX and ODS read and write with values, formulas, styles, merged cells and charts, and CSV with a detected or fixed delimiter.
CellsValues, Formulas and Text by Excel address, SetRange for a Variant array, UsedRange and Clear.
Formula engine320 Excel functions in the logical, math, statistical, financial, text, date and time, lookup and reference, engineering and other categories, with dynamic arrays. Evaluate runs any formula against the workbook.
LET and LAMBDALET, LAMBDA, named LAMBDA functions defined with DefineName, and MAP, REDUCE, SCAN, BYROW and BYCOL.
Cell formatsFont, size, bold, italic, colours, fill, alignment, number formats, merged cells, column widths and row heights.
Conditional formatsKept when an XLSX file is loaded and saved, for 10 of the 15 Excel rule types.
ChartsThe charts of the sheets are loaded from and saved to XLSX, printed with the sheets and written as inline SVG to HTML.
SheetsAddSheet, DeleteSheet and RenameSheet, which rewrites the formulas that refer to the sheet.
DatasetsImportDataSet copies the visible fields of a dataset into a sheet, with a header row.
ProtectionSheet protection with unlocked cells, and workbook protection.

Printing Spreadsheets

FeatureDetails
PaginationA sheet is paginated the way Excel prints it, and written to PDF with ExportToPDFFile, to PNG with ExportSheetPageToPNG and to HTML with ExportToHTML.
Page setupOrientation, paper size, scale or fit to pages wide and tall, margins, centring, grid lines and headings, read from the workbook or set through PageSetup.
Print areas and titlesPrint areas, title rows and columns repeated on every page, and header and footer codes.

PDF Processor

FeatureDetails
PagesMerge, Split by page ranges, ExtractPages, DeletePages, MovePage and RotatePages.
TextExtractText for one page or every page, and SearchText for the pages that contain a text.
PNG pagesRenderPageToPNGFile at 1 to 2400 dpi, with the page rotation applied.
EncryptionRC4 40 and 128 bit, AES-128 and AES-256 with print, modify, copy, annotate, fill forms, extract and assemble permissions. Encrypted files open with the user or owner password, and Decrypt removes the encryption.
FormsRead and set AcroForm fields by name, fill them from Name=Value lines, and flatten them into the pages.
PDF/AConvertToPDFA for PDF/A-1b, 2b, 3b, 1a, 2a, 3a, 4 and 4f, and ValidatePDFA with a report of the errors and warnings.
Digital signaturesSign through OnExternalSign on every platform, for an HSM, a cloud key or sgcSign. SignWithPFX and SignWithThumbprint on Windows.
HTML and images to PDFLoadFromHTML renders HTML with CSS, and AddImagePage adds a JPEG, PNG, BMP or TIFF image as a page, at its own size or fitted to A4 or Letter.

Barcode

FeatureDetails
KindsCode 128, Code 39, EAN-13, EAN-8, UPC-A, ITF, Codabar, QR Code, Data Matrix, PDF417 and GS1-128.
ValidationValidate checks length, digits, check digits, character sets, GS1 application identifiers and 2D capacity. EAN-13, EAN-8 and UPC-A add a missing check digit.
OutputPNG, SVG and a one page vector PDF, or DrawToPDFPage into a box of an existing PDF page.
OptionsModule size, quiet zone, colours, the text under linear symbols, bar height and the QR Code error correction level.

ZIP Archive

FeatureDetails
ZIP64Archives over 4 GB or with more than 65,535 entries, deflate or stored entries, UTF-8 names and entry times.
CreateAddFile, AddFolder with a mask, AddStream, AddText and AddEmptyFolder, to a file or a stream.
ReadEntries with name, size, compressed size, CRC32 and time, ExtractTo, ExtractEntry to a stream, ExtractEntryToFile and ReadText.
Safe extractionEvery name is checked before anything is written: an archive with a .. segment or an absolute path is refused.
ProgressOnProgress before each entry, with a flag that stops the operation.

Converter

FeatureDetails
Format pairs63 pairs between 14 formats. DOCX, RTF, HTML, Markdown and text convert to each other and to PDF, PNG and SVG. XLSX, ODS and CSV convert to each other and to HTML, PDF and PNG. PDF converts to text, PNG and PDF, and images to PDF.
Files and streamsConvert takes both formats from the file extensions, and ConvertStream detects the source format from the content. CanConvert tells in advance whether a pair is supported.
Page imagesConvertToImages writes one PNG or SVG per page into a folder, at the resolution you choose.
Images to PDFConvertImagesToPDF makes one PDF page per PNG, JPEG, BMP or TIFF image, at the image size or fitted to A4 or Letter.
PDF optionsTagged PDF for Word sources, and every PDF output converted to a PDF/A level of your choice.
Progress and errorsOnProgress reports the load, save, page and image stages. An unsupported pair raises EsgcDocsUnsupportedFormat.

Platforms and Deployment

TargetComponentsVersions
DelphiThe seven sgcDocs componentsDelphi 7 to 13: Win32, and Win64 from Delphi XE2
C++ BuilderThe same classes, with generated .hpp headersC++ Builder 2007 to 13
Linux64The same units, with no VCL, FireMonkey or GDI codeConsole programs, daemons and web servers. Needs libz.so.1 and the TrueType fonts of the documents
Services and web serversOne instance of each component per thread; separate instances run in parallelEvery supported Delphi version
.NETesegece.sgcDocs, namespace esegece.sgcDocs.NET Standard 2.0, .NET Framework 4.7.2, .NET 6, 8, 9 and 10

sgcDocs for .NET

A C# edition with the same class and member names, in namespace esegece.sgcDocs. The package is Registered only and is not published on nuget.org.

PackageEditionContents
esegece.sgcDocsRegisteredEvery sgcDocs component, with the same conversion matrix as Delphi, and TsgcDocsMergeDataTable for a DataTable, a DataSet table or an IDataReader
esegece.sgcUICore, esegece.sgcPDF, esegece.sgcRichEdit, esegece.sgcGrid, esegece.sgcSpreadsheet, esegece.sgcChartsDependencyThe engines that sgcDocs builds on, installed with it
esegece.sgcUICore.RenderingOptionalAdd it only to write PNG and SVG pages of documents and sheets

Documentation

sgcDocs is documented in the sgcUI help, with one build for each development environment.

Online Help

The sgcUI help for each development environment.

Delphi →
C++ Builder →
.NET →

PDF Manuals

The complete sgcUI help as a PDF file, to read offline or print.

Delphi (PDF) →
C++ Builder (PDF) →
.NET (PDF) →
Best value: All-AccessEvery eSeGeCe product, Premium Support included, from €1,059/year.
See All-Access pricing

Build with sgcDocs

Download the sgcUI trial and create, merge and convert Office files in your Delphi or C++ Builder application.