I would say it's more to do with your selected file format. Excel also creates a temporary file and most likely only updates what has changed when a save is done.
This is just a guess as I don't know the internals of excel and it's save process. What type of format are you saving you file to? 14 mins does seem like a long time though. Can you show us some of your saving code? If not perhaps some pseudo code of how your doing it. Alternatively, run it through a profiler. AQ Time has a trial download that you could run it against. -----Original Message----- From: Chris Veale [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 3:00 PM To: [EMAIL PROTECTED] Subject: [DUG]: Speed of excel saving? Hi Is anyone aware how excel saves large files so fast? Further to the saga of my application, a file takes me 14 minutes to save (20 columns and 28000 rows in a stringgrid) but the same file takes excel about 15 seconds! Is it because excel has a hugely optomised save routine, or some impressive data storage mechanism where Im treating everything as a string? Chris _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
