1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to [email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram

  5. Delphifan Magazine
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

TXLSFile,NativeExcel and XLSReadWriteII comparation

Discussion in 'Delphi Programming' started by AdminDF, Jun 28, 2015.

  1. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan Staff Member DF Staff

    TXLSFile: Write 65535 rows each 10 cols,time taken: 00:17.796
    NativeExcel: Write 65535 rows each 10 cols,time taken: 00:01.439
    XLSReadWriteII: Write 65535 rows each 10 cols,time taken: 00:02.600

    TXLSFile: Read 65535 rows each 10 cols,time taken: 00:02.261
    NativeExcel: Read 65535 rows each 10 cols,time taken: 00:03.204
    XLSReadWriteII: Read 65535 rows each 10 cols,time taken: 00:01.447

    TXLSFile: Write 2000 rows each 100 cols,time taken: 00:01.738
    NativeExcel: Write 2000 rows each 100 cols,time taken: 00:00.328
    XLSReadWriteII: Write 2000 rows each 100 cols,time taken: 00:00.565

    TXLSFile: Read 2000 rows each 100 cols,time taken: 00:00.571
    NativeExcel: Read 2000 rows each 100 cols,time taken: 00:00.955
    XLSReadWriteII: Read 2000 rows each 100 cols,time taken: 00:00.448


    TXLSFile: Write 65535 rows each 100 cols,time taken: 30:18.314
    NativeExcel: Write 65535 rows each 100 cols,time taken: 00:12.144
    XLSReadWriteII: Write 65535 rows each 100 cols,time taken: 00:40.625


    TXLSFile: Read 65535 rows each 100 cols,time taken: 01:22.480
    NativeExcel: Read 65535 rows each 100 cols, Error:Out of memory
    XLSReadWriteII: Read 65535 rows each 100 cols,time taken: 00:10.854
     
  2. Axel2014
    Offline

    Axel2014 DF Junior

    RE:

    Thnaks
     
  3. terz84
    Online

    terz84 Guest

    RE:

    thanks
     
  4. peterf
    Online

    peterf DF Junior

    Thanks
     
  5. nabob_09
    Offline

    nabob_09 DF Member

    RE:

    thanks
     
  6. noomsoft
    Offline

    noomsoft DF Junior

  7. Chawa
    Offline

    Chawa DF Member

    thanks for comparation
     

Share This Page