An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Solved
Store results in memory instead of each time writing results in sheet(cell).
Posted on 2012-12-27
Dear,
I'm including some accuracy control mechanism in a simulation Tool I build to re-rate made mobile calls.
The tool has a "control modus". If selected, the result (in this case the duration of the call ) is written in the current selected row offset by 18 colums.
When rerating +100K rows, and even with screenupdating and calc disabled, it runs very slow.
Is there a possibility to keep results in the memory (array), and only write the result once, once all rerating has been done.
Thank you for your help
/Xtophe
I'm including some accuracy control mechanism in a simulation Tool I build to re-rate made mobile calls.
The tool has a "control modus". If selected, the result (in this case the duration of the call ) is written in the current selected row offset by 18 colums.
When rerating +100K rows, and even with screenupdating and calc disabled, it runs very slow.
Is there a possibility to keep results in the memory (array), and only write the result once, once all rerating has been done.
Select Case ControlModus
Case Is = "YES", "Yes", "yes"
ActiveCell.Offset(0, 18).Value = CdrSeconds ' uncomment this in case you want to write control figures next to CDR's
Case Else
End Select
Thank you for your help
/Xtophe
3 Comments
Well... putting values on spreadsheet is, virtually, maintaining values in an array (since these values are in memory). With +100k rows... and understanding how Excel maintains row data in memory... you're probably better off using the spreadsheet method versus memory arrays.
But, depending on how you use this data in your application... you may want to write your data to a sheet like a table (1st row contains headers, all other rows contain data) and access your data on the sheet by opening it like a table and query your data using SQL type statements.
Scott C
But, depending on how you use this data in your application... you may want to write your data to a sheet like a table (1st row contains headers, all other rows contain data) and access your data on the sheet by opening it like a table and query your data using SQL type statements.
Scott C
Writing 100k cells one by one will be very very slow, so yes you would be far better off writing the results to an array and then writing that to the sheet in one go using a simple:
syntax
Range("Y1").Resize(ubound(myarray, 1), ubound(myarray, 2)).Value = myArray
syntax
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month7 days, 18 hours left to enroll
585 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.