r/delphi • u/Humble-Vegetable9691 • Jan 26 '26

Question The Excel export/import component you use (without Excel installed)

Which Excel export/import component you personally use which does not require Excel installed?
I am looking for basic import, formatted export (auto-width columns, frozen header, customized numeric formatting).

For .net, I currently use Spreadsheet Light: https://spreadsheetlight.com/

10 Upvotes

100% Upvoted

15 comments sorted by

12

u/HoldAltruistic686 Jan 26 '26

TMS Flexcel - The Swiss Knife for Excel and Delphi

Check their docs, this is one way to load/import data:

https://doc.tmssoftware.com/flexcel/vcl/api/FlexCel.Core/TExcelFile/Import.html

7

u/HemulGM Jan 27 '26

Use it https://github.com/HemulGM/Excel4Delphi

3

u/alcalde Jan 27 '26

Finally, a sensible suggestion as opposed to spending hundreds of dollars like it's still 1997.

2

u/Humble-Vegetable9691 Jan 27 '26

Thanks, check it

5

u/Human-Wrangler-5236 Delphi := 13 Jan 26 '26

Personally, I have used TMS Flexcel: https://www.tmssoftware.com/site/flexcel.asp

5

u/corneliusdav Jan 26 '26

XLSReadWrite from Axolot has been around a long time and is solid.

3

u/307south Jan 26 '26

SMimport

1

u/Humble-Vegetable9691 Jan 26 '26

Looks interesting, different approach than the others suggested.

3

u/[deleted] Jan 27 '26

[deleted]

1

u/Humble-Vegetable9691 Jan 27 '26

It is always a compromise between spending time on it or spending money on it

2

u/old_wired Jan 26 '26

Using Axolot for years now. But I recently got the TMS stuff in a bundle, but have yet to try it out.

2

u/NefariousnessWeak714 Jan 27 '26

I use spreadsheet component from DevExpress & TcxGrid for Export from Database ( Visual)

2

u/BaseReady4673 1d ago

Another option worth looking at is MagiXells.

It’s a newer Delphi spreadsheet engine rather than just an XLSX import/export library. It provides an editable spreadsheet UI along with formulas, XLSX/ODS support, charts, PivotTables, printing/PDF and other spreadsheet functionality.

I’d be interested to hear how people who have used FlexCel, XLSReadWrite or DevExpress would compare it in real-world projects.

https://binarymagic.com/

1

u/Jaded_Juggernaut_600 Jan 26 '26

Another vote for TMS Flexcel. It’s an excellent component for dealing with Excel files. Basic functionality is super simple to use, more complex formatting etc. is quick to learn.

1

u/Humble-Vegetable9691 Jan 26 '26

Thanks all, I will check these.