problem with xls2gms (file access is denied??)

GAMS
1

Dear friends

about 1 month ago I wrote a code for importing a table from excel to gams, it was working properly, but suddenly today when I wanted to work with that model again, I found that there is an error for importing the table which says “file access is denied”. but the file exists and nothing has happened with its sheets and ranges and values, can you please help me that what is the problem.
Many thanks in advance

table Lambda(v,u) ‘The rate of demand occurrence for each arc’
$call =xls2gms I=E:\testtable\test1.xls O=E:\testtable\pard.inc R=sheet3!a2:g8
$include E:\testtable\pard.inc

\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

2

Hi,
I have little time with GAMS, but, if possible, I try to help you.
what version do you use???
I do not use your code for importing a table.
I write the code that I use. I hope it helps you.

$libinclude xlimport \

Example:
$libinclude xlimport table C:\Users\usuario\Documents\Raquel\table.xls a1:h7

I use it if I only use the first sheet. And, try putting the gams file and the excel file in the same folder.

I hope it helps you,
Raquel


El martes, 23 de junio de 2015, 16:04:43 (UTC+2), mahmood golabi escribió:

Dear friends

about 1 month ago I wrote a code for importing a table from excel to gams, it was working properly, but suddenly today when I wanted to work with that model again, I found that there is an error for importing the table which says “file access is denied”. but the file exists and nothing has happened with its sheets and ranges and values, can you please help me that what is the problem.
Many thanks in advance

table Lambda(v,u) ‘The rate of demand occurrence for each arc’
$call =xls2gms I=E:\testtable\test1.xls O=E:\testtable\pard.inc R=sheet3!a2:g8
$include E:\testtable\pard.inc

\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.