To hide gridlines use the hide_gridlines() method.

    use Spreadsheet::WriteExcel;

    my $workbook  = Spreadsheet::WriteExcel->new('test.xls');
    my $worksheet = $workbook->add_worksheet();

    $worksheet->hide_gridlines(2);
    $worksheet->write( 'A1', 'Hi Excel!' );
[download]

I'm not sure what you mean by "workbook should not contains rows and columns" but set_row() and set_column() have options to hide rows and columns.

--
John.