2021年12月16日 星期四

Spreadsheet Components Delphi

 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.

沒有留言: