Hello I am using the module Excel::Writer::XLSX written by John McNamara. It work's great. I have written a perl script which reads a cvs file and then creates a spreadsheet. The module has many characters you can set, such as:

$worksheet = $workbook->add_worksheet();

$workbook->set_landscape()
$workbook->set_freeze_panes(2,0)
[download]

I would like to populate the settings in a flat file such as:

set_landscape()

hide_gridline(), etc

and then have my script read and execute the settings. I know this doesn't work but this is what I want it to do:

while(<IN>) {
  chomp;
  $worksheet->$_
}
[download]

Is there someway to do what I want?