Did you do any sort of speed comparisons between vba code and python code, involving big excel data tables manipulation within excel ? (like 300000 rows, 20columns)
Regards
Last edit: stonebig 2013-09-05
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No i never tried that as i wrote it and have used it for different
purposes: i.e. being able to code in python instead of vba, as it's a much
more consistent and concise language with lots of good libraries.
I guess performance-wise, in your example, it depends what you want to do
with the rows, I would have thought that the actual data processing in
python would be faster than in vba generally speaking. In excelpython the
bottleneck would be the conversion between vba arrays and their python
equivalents, though that part should be negligible compared to the data
processing itself in all but the very simplest cases.
If you do perform any tests please post the results!
On Sep 5, 2013 10:07 PM, "stonebig" stonebig@users.sf.net wrote:
Hello Eric,
Did you any sort of speed comparisons between vba code and python code,
involving big excel data tables manipulation within excel ? (like 300000
rows, 20columns)
Hello Eric,
Did you do any sort of speed comparisons between vba code and python code, involving big excel data tables manipulation within excel ? (like 300000 rows, 20columns)
Regards
Last edit: stonebig 2013-09-05
No i never tried that as i wrote it and have used it for different
purposes: i.e. being able to code in python instead of vba, as it's a much
more consistent and concise language with lots of good libraries.
I guess performance-wise, in your example, it depends what you want to do
with the rows, I would have thought that the actual data processing in
python would be faster than in vba generally speaking. In excelpython the
bottleneck would be the conversion between vba arrays and their python
equivalents, though that part should be negligible compared to the data
processing itself in all but the very simplest cases.
If you do perform any tests please post the results!
On Sep 5, 2013 10:07 PM, "stonebig" stonebig@users.sf.net wrote: