Perl Excel Worksheet Name. The set_column() method is used to change the default properties of a single column or a range of columns. I have a spreadsheet which is being used as a template.
This will create an Excel file called perl.xlsx with a single worksheet and the text 'Hi Excel!' in the relevant cell. Excel names your worksheets based on the number of worksheets that have been created in that workbook. The default Excel VBA name of ThisWorkbook is used if a user defined name isn't specified.
I have a spreadsheet which is being used as a template.
The tutorial uses Perl and the Excel::Writer::XLSX module available on CPAN.
Please suggest how can i get that. These functions won't work in a regular sheet, they only work in named functions and macro sheets. Added the new worksheet named PERL to the workbook.