Reading Sets from Excell Sheets with Connect
Posted: Wed Feb 28, 2024 9:31 am
I have a set testSet and the content of the set is defined in an Excel-Sheet. I tried to read it using the ExcelReader from the Connect API but I can not seem to get it done. Can someone give me an explanation of how to get this done?
Code: Select all
set testSet;
$onEmbeddedCode Connect:
- ExcelReader:
file: Lego-Edit.xlsx
symbols:
- name: testSet
range: Hindex_new!A1:C3
rowDimension: 0
columnDimension: 1
type: set
- GAMSWriter:
writeAll: True
$offEmbeddedCode