Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Large Array without writing in the worksheet
Hello,
I have two large arrays in two separate external text files (values separated by a space): A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array C(82000,240). How can I read it in VBA without the need to write it on the worksheet and print C in worksheets: result1 (65536,240) and result2 (65537,240) Thanks and good weekend |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Large Array without writing in the worksheet
Daniel wrote:
Hello, I have two large arrays in two separate external text files (values separated by a space): A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array C(82000,240). How can I read it in VBA without the need to write it on the worksheet and print C in worksheets: result1 (65536,240) and result2 (65537,240) Thanks and good weekend What version of Excel? Alan Beban |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Large Array without writing in the worksheet
I think you are so close to what you want that you don't realize that most
people may have no idea what you are asking for. Can you give some example of what you need to do like this: File1 100 200 200 10 300 4 5 77 File2 44 323 1 22 33 44 Now what do you wish to do? Multiple like this: File 1 100* 200 200 *10 300 *4 5 *77 File 2: 44* 323 1* 22 33* 44 and then write back into file the product of: 100* 200*44* 323 200 *10*1* 22 ....etc.... Please be more explicit in what you want to end up in your "C" as you call it. Do you want it in a spreadsheet or do you want to just store the product of each multiplication in a new file "C"? Let me know... "Daniel" wrote: Hello, I have two large arrays in two separate external text files (values separated by a space): A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array C(82000,240). How can I read it in VBA without the need to write it on the worksheet and print C in worksheets: result1 (65536,240) and result2 (65537,240) Thanks and good weekend |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Large Array without writing in the worksheet
2003
"Alan Beban" wrote: Daniel wrote: Hello, I have two large arrays in two separate external text files (values separated by a space): A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array C(82000,240). How can I read it in VBA without the need to write it on the worksheet and print C in worksheets: result1 (65536,240) and result2 (65537,240) Thanks and good weekend What version of Excel? Alan Beban |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Large Array without writing in the worksheet
here it goes,
A(82000,1500), B(1500,240) want to do C=A*B, where C(82000,240) A look like: A 7.68053e-03 1.14077e-02 1.34675e-02 ... (1500 numbers separated by space in a row) .... 82000 rows of 1500 each B similar but different size want to read each array into A(i,j), B(l,m) and compute C(i,m) then write C into 2 worksheets (cant be one because of the nr of rows) hope is more clear, thanks Mike, looking for feedback "Mike H." wrote: I think you are so close to what you want that you don't realize that most people may have no idea what you are asking for. Can you give some example of what you need to do like this: File1 100 200 200 10 300 4 5 77 File2 44 323 1 22 33 44 Now what do you wish to do? Multiple like this: File 1 100* 200 200 *10 300 *4 5 *77 File 2: 44* 323 1* 22 33* 44 and then write back into file the product of: 100* 200*44* 323 200 *10*1* 22 ...etc.... Please be more explicit in what you want to end up in your "C" as you call it. Do you want it in a spreadsheet or do you want to just store the product of each multiplication in a new file "C"? Let me know... "Daniel" wrote: Hello, I have two large arrays in two separate external text files (values separated by a space): A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array C(82000,240). How can I read it in VBA without the need to write it on the worksheet and print C in worksheets: result1 (65536,240) and result2 (65537,240) Thanks and good weekend |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing array data to range object always writes 0's on worksheet | Excel Programming | |||
How to Read Worksheet Data into VBA Array? | Excel Discussion (Misc queries) | |||
Fast export large 2-dim array to worksheet | Excel Programming | |||
Writing an array(2d) of user types to a worksheet | Excel Programming | |||
Writing values to worksheet from array | Excel Programming |