Search found 4 matches

by mahdigh
5 years ago
Forum: Tools
Topic: Reading Data from Excel , except some Cells
Replies: 6
Views: 5421

Re: Reading Data from Excel , except some Cells

Please give an example and why it is necessary to skip a cell. If there is no value, there is no value in the data you read... Cheers Renger How can i send a picture to give an example? there is 4 modes for transportation 1 - truck , 2-rail , 3-boat , 4-pipeline imagine we want to transport our pro...
by mahdigh
5 years ago
Forum: Tools
Topic: Reading Data from Excel , except some Cells
Replies: 6
Views: 5421

Re: Reading Data from Excel , except some Cells

how can Gams skip blank cells (not rows or columns) just some Cells?
by mahdigh
5 years ago
Forum: Tools
Topic: Reading Data from Excel , except some Cells
Replies: 6
Views: 5421

Re: Reading Data from Excel , except some Cells

Thanks
i found https://www.gams.com/latest/docs/T_GDXX ... _SKIPEMPTY
but Gams should ignore or skip blank cells - this is for blank rows or columns
how can i solve this problem?
by mahdigh
5 years ago
Forum: Tools
Topic: Reading Data from Excel , except some Cells
Replies: 6
Views: 5421

Reading Data from Excel , except some Cells

1 1 1 1 1 2 3 4 1 1 4887000 2003400 11252850 1 2 4174200 1682100 9444750 1 3 1949400 775950 4174800 1 4 1323000 557550 2601900 1 5 2011500 796950 3807300 1 6 5262300 2140950 11458650 1 7 3777300 1482600 8004150 1 8 3755700 1501500 7776300 1 9 82500 1 10 355500 Hello I want My Gams code reads this Ex...