Graham I have not seen and reduction in performance however I use a different approach. There are also other exporters out there that work well.
For day to day stuff moving between excel and vfp I use the excel plugin available on the news2news site http://news2news.com/vfp/index.php?solution=14&src=frontpageimg&PHPSESSID=72 aecaae25cb568ecd04b67d0583bc32 . Small cost but very productive addition to tool box. As for excel export I wrote an export back in 2002 that has had minimal changes over the years. Still works well and fast. Idea is simply to use the VFP export - have the code loop through the entire table in 16,383 record blocks - export that block to temp file. Import that temp file into excel, copy the import and past into the destination spreadsheet. You'll have two sheets open at the same time - one holds the 16k data and the other your final output. If the number of records goes past the limit for the workbook per the version of Excel then simply spawn off another workbook. In this way you are not limited by number of records in your table and performance is perfectly adequate (significantly better than the figures you are quoting). All the formatting , column headers, column cells, autowidth, date format - whatever is supported by excel - is done very rapidly and you end up with a pretty nicely formatted and laid out spreadsheet in a very reasonable time period. Other niceties (e.g. Specific formatting per row, groupings etc) are handled by the addition of a formatting field in the data file fed to the exporter. A bit of pre-work to the export but result if very flexible output to spreadsheet format. Happy to send you the code if you want. Cheers -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Graham Brown Sent: Saturday, 23 May 2015 7:02 PM To: [email protected] Subject: Excel 2013 slow automation Hello Has anyone seen any problems with Excel automation? My code creates an excel spreadsheet, writing out various info from the tables, in 2010 and earlier it takes about 1 minute to write out 1500 lines but in 2013 it is more like 45 minutes. Checked with AV on and off, closed all other apps etc etc so it definitely seems to be 2013. Regards Graham --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) application/ms-tnef --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
