Spreadsheet::WriteExcel::write() takes an arrayref of arrayrefs. DBI::fetchall_arrayref({}) returns an arrayref of hashrefs. Read the documentation of ->fetchall_arrayref to find out how to make it return array references.

Also, you might be interested in Querylet.