Pasting speed

3.42K viewsGeneral Discussion
0

I’ve been pasting 3500 x 132 cell grids from Excel into slices of a Quantrix hypercube. Each slice takes about an hour to paste. Is there a trick to speed this process up?

0

If you want to send in your model and data source file to [email:1ag1turd]support@quantrix.com[/email:1ag1turd] we would be happy to take a look. Any information received would be held in this strictest of confidence.

0

The import happens speedily enough, but the result is a new matrix. Copying that and pasting it into position in the intended slice of the cube takes a long time.

0

Not sure of your exact use case, but maybe importing from the clipboard is an option. Choose Tools > DataLink > Import from Clipboard, and maybe you can import the clipboard contents into a 2D matrix?

You can learn more about DataLink here:

[url:ksc0gi1p]http://www.quantrix.com/r-doc-4-18-104[/url:ksc0gi1p]

Let me know if this is helpful.

-Mike

0

Windows XP, on a dual-core 1.8Ghz machine with 1G of memory.

0

I can look into that a bit. Are you using OS X or Windows?

-Mike