|
-
Mar 28th, 2017, 09:28 AM
#1
Thread Starter
New Member
Help outputting Millions of values to excel? csv?
Hi. I have a program that opens a form, asks the user for some inputs (Variable names, range of possible values, #values in range) then creates all the output values and stores them all in an array. (The array I am using is an array of arrays however it is rectangular.) The program then outputs to excel. The problem is that I need to be able to create up to 5 million combinations and this would take way to long to output to excel. Does anyone know of a better way to accomplish this. The user wants to be able to see results in excel. I have never done anything with CSV files but am thinking that anytime I have ever exported anything of size it has been a CSV file. Is that the path I need to go down? And if so is it as simple as instead of exporting to excel you export to a CSV file?
Any help is greatly appreciated. Thanks
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|