18 views
Skip to first unread message

you gun

unread,
May 16, 2013, 4:29:52 AM5/16/13
to ai...@googlegroups.com
Hi all,

I have a problem when I copy big data from excel sheet (about 10000 row * 300 col) to table in AIMMS. It take too long time and can't complete. Can any one tell me what happend? and what any way to do it?

Thank you!

Franco Peschiera

unread,
May 16, 2013, 4:52:17 AM5/16/13
to ai...@googlegroups.com
you should try AIMMS functions to read directly from Excel.
Check the function reference manual ("AIMMS_func.pdf"), specifically function "Spreadsheet::RetrieveTable".
It makes it a lot faster.

You can search this group for examples or ways to use it.

regards,


Franco Peschiera
Jefe de proyectos
baobab soluciones


--
You received this message because you are subscribed to the Google Groups "AIMMS - The Modeling System" group.
To unsubscribe from this group and stop receiving emails from it, send an email to aimms+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

you gun

unread,
May 16, 2013, 4:58:50 AM5/16/13
to ai...@googlegroups.com
Thank you for your warm reply. I will try it.
Reply all
Reply to author
Forward
0 new messages