Export to Excel – is 64 bit an issue
I’d think you’d get an error however vs “hang” but you never know.
Make sure Excel is loaded on the machine trying to export to Excel (32 bit or 64 bit shouldn’t matter)
Thanks for confirming that 64 bit Excel is not an issue. I changed it to export to my desktop, and it exported pretty quickly. I then put it back to exporting to a shared folder on a different server and just let it run. It took a really long time, but it did finally get there. I was not patient enough yesterday 🙁
It is taking 7 minutes to export 1,321 rows. An export to tab delimited is instant. Seems like a long time for excel. Anything I can do to speed it up?
Not really other than to not export to Excel (use csv for example).
The reason is that SC is using COM automation to update Excel and that is slow. Remember how slow the export to Excel was from GP SmartList? That was because GP used COM and did the same thing. And then they made it much faster? That happened because GP SmartList switched to using the OpenXML SDK (and why it is in the GP prereqs) which writes directly to the underlying XML in the xlsx file.
Thanks Patrick for the explanation.
If you would like to submit an answer or comment, please sign in to the eOne portal.