TAdvSpreadGrid https://www.tmssoftware.com/site/aspgrid2.asp
TMSSoftware https://www.tmssoftware.com
Powerful spreadsheet function calculation support added to the full TAdvStringGrid feature set. ... Delphi component VCL Grid. TAdvSpreadGrid extends the ...TAdvSpreadGrid extends the full power of TAdvStringGrid with formulas. Simple formula editing interface
Auto recalculation
Native XLS file import and export*
Single cell recalculation, full recalculation
Extensive range of mathematical functions
Save with formulas or formula results only
Single cell references in formulas
Cell range formulas
Formula precision for grid on cell basis
Display formulas or formula results
Date / time functions
Intelligent formula aware copy and paste
Can be extended with custom functions
Cell names
Cell name mode can be RxCy style or A1-style
Can reference cells from other TAdvSpreadGrids
Math library infrastructure to allow easy extending
TAdvSpreadGrid with custom functions
Includes the free ESBMaths library with 46 scientific constants and 19 mathematical functions from ESB Consultancy
ESBPCS maths library available for even more statistical functions
Intelligent and customizable hints while editing formulas
https://github.com/sergio-hcsoft/Delphi-SpreadSheets
DevExpress components SpreadSheet component (cxSSheet).
https://en.delphipraxis.net/topic/5819-looking-for-spreadsheet-component/
JansFreeware A collection of freeware components including the TJanGrid4 a grid with spreadsheet capabilities.
git-bee/janSQL: Fast single user SQL engine for text-based files.
Searching in the Internet I found only commercial components (such TMS and ProfGrid) until I found
TJanGrid4: http://jansfreeware.com/jfdelphi.htm
http://web.tiscalinet.it/patriziotorsa/delphi.html
TjanGrid 4
TjanGrid is a TStringGrid descendant featuring: AutoCalc Spreadsheet, Named Cells, Cell Info Hints, R1C1 or A1 cell reference, LoadFrom CSV/HTML, SaveTo CSV/HTML/XML, insert/delete/append/autosize columns/rows. cut/copy/paste/clear/fill range. alpha/number/date SORT row/columns. wordwrap. source code included. help file. integral dialogs for : print/preview/zoom/formule/query/cell names. filter/show/hide rows/columns. color bands. http://members.xoom.com/JanVee/jangrid4.zip
XLGrid http://www.gavina-software.com/components/xlgrid
https://www.gobestcode.com/html/math_parser_for_delphi.html
TbcParser is a math expression parser VCL component that can be used with Delphi and C++ Builder 4,5,6,7, 2006, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, Delphi 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney and most likely any newer version.
沒有留言:
張貼留言