| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to read Excel Array to vb.net Arrays?
W dniu sobota, 12 października 2013 21:03:18 UTC+2 użytkownik GS napisał:
Why all the extra steps? Why not just 'dump' the range into an array and work with it in memory? Because of speed. I made the test which compared the speed of seeking the strings from one array in another array. This operation in Excel memory took about 30 seconds. Exactly the same operation in Visual Studio took 52 miliseconds :) It's 576 times faster. Some operation are 3 or 4 thousant faster. When working with large amount of data it counts. Excel is great software but VBA is slow. A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you create an Array of Arrays? | Excel Programming | |||
| Excel, read in an array | Setting up and Configuration of Excel | |||
| How to Access Array of Arrays? | Excel Programming | |||
| array of arrays stored in Name: POSSIBLE? | Excel Programming | |||
| Array of Arrays in VBA | Excel Programming | |||
Threaded Mode
