sgcSpreadsheet ships in the sgcUI All-Access trial, one installer for Delphi and one for C++ Builder with every sgcUI product. Download the fully functional trial and run the spreadsheet demos in your own IDE. The .NET packages are Registered only and are delivered with the license. Licenses are available on the pricing page.
One sgcUI trial installs every sgcUI product, sgcSpreadsheet, sgcGrid and sgcCharts included, with full functionality for evaluation.
Fully functional evaluation for Delphi 7 through RAD Studio 13 with every sgcUI product, sgcSpreadsheet included, and the demo projects.
Download Delphi Trial →Fully functional evaluation for C++ Builder 10.1 through 13. The same components with C++ header files and the C++ Builder demo projects.
Download CBuilder Trial →Install the trial, run a demo, then drop the spreadsheet on your own form.
Run the sgcUI trial installer with sgcSpreadsheet selected. sgcGrid and sgcCharts install with it. The installer puts TsgcVCLSpreadsheet and TsgcFMXSpreadsheet on the SGC Spreadsheet palette page.
Open 01.Basic from Demos\Spreadsheet\Delphi and run it: type values and formulas, switch sheets, and save the workbook as an XLSX file.
In a new VCL project, drop a TsgcVCLSpreadsheet on the form, write cells with SetCellInput, and call SaveToXLSX and LoadFromXLSX.
The Delphi demos install in Demos\Spreadsheet\Delphi. The C++ Builder trial installs the Basic and Charts demos in Demos\Spreadsheet\CBuilder.
A sales workbook built in code with SUM, AVERAGE, IF and XLOOKUP, a summary sheet that reads it, a frozen header row, the formula bar, and Open and Save as XLSX.
Math, text, date and time, lookup and dynamic array functions, one sheet per category, with the formula next to its result.
Column, line and pie charts from cell ranges that follow the cells when a value changes.
Functions registered by the application and used in formulas like the built in ones.
The Basic and Charts demos with TsgcFMXSpreadsheet on FireMonkey.
Basic and Charts as C++ Builder projects in Demos\Spreadsheet\CBuilder.
| Item | Support |
|---|---|
| Delphi and C++ Builder | Delphi 7 to 13 and C++ Builder 2007 to 13. |
| VCL | TsgcVCLSpreadsheet and TsgcVCLSpreadsheetFormulaBar on Windows, Delphi 7 to 13 and C++ Builder 2007 to 13. |
| FireMonkey | TsgcFMXSpreadsheet and TsgcFMXSpreadsheetFormulaBar from Delphi and C++ Builder XE6. |
| Dependencies | The spreadsheet runs on sgcGrid and draws its charts with sgcCharts. Both install with sgcSpreadsheet. |
sgcSpreadsheet also ships as a managed C# port with the same class names for WinForms, WPF and Avalonia. The packages are Registered only, delivered with the license, and not published on nuget.org.
The NuGet packages come with the Registered .NET download that is delivered with the license. Add its folder as a local package source, then reference esegece.sgcSpreadsheet and the package for your UI framework.
Demo projects in demos\Spreadsheet: SpreadsheetBasic for WinForms, SpreadsheetBasicWpf, SpreadsheetBasicAvalonia, SpreadsheetFunctions, SpreadsheetCharts and SpreadsheetCustomFunction.
The spreadsheet packages depend on the Registered sgcGrid, sgcCharts and sgcUICore packages, which are included with the license.
There is no free Community edition of sgcSpreadsheet. Evaluate the spreadsheet with the sgcUI trial for Delphi or C++ Builder before you buy a .NET license.
Every package is Registered and needs a .NET license.
| Package | Contents | Targets |
|---|---|---|
Registered esegece.sgcSpreadsheet | Spreadsheet model, charts and XLSX support | .NET Standard 2.0, .NET Framework 4.7.2, .NET 6, 8, 9 and 10 |
Registered esegece.sgcSpreadsheet.WinForms | WinForms control, TsgcWinFormsSpreadsheet, with its formula bar | .NET Framework 4.7.2, .NET 8, 9 and 10 on Windows |
Registered esegece.sgcSpreadsheet.Wpf | WPF control, TsgcWpfSpreadsheet, with its formula bar | .NET Framework 4.7.2, .NET 8, 9 and 10 on Windows |
Registered esegece.sgcSpreadsheet.Avalonia | Avalonia control, TsgcAvaloniaSpreadsheet, with its formula bar | .NET 8, 9 and 10 |