Fix consequence of previous update to support multiple worksheets default worksheet 'sheet1' no longer set becuase worksheet() method not called now have to set manually inside _write_xlsx_row() if ->worksheet_name() not set in calling script

Take worksheet name into variable for debugging purposes

Local::WriteExcel - adapt to support multiple worksheets

comment debug info

bugfix to WriteExcel row_counter - only worked up to A9, then B0, B1, etc

* move filename/filetype validation to earlier in object creation cycle, from BUILD to _build_filetype, as empty args to object causing undef value errors in _build_filetype before finally dying in BUILD block * replaced try/catch with Test::Exception throws_ok

* replace global xlsx_data var with class attribute to prevent data persistence when object created again in same scope * new attribute to prevent close() being called more than once on xlsx_data string, though probably no harm if it does * new test file

WriteExcel - xl_object to 'rwp' and _set_xl_object to set it

moved worksheet_name validation from 'around' to trigger; moved filetype-from-filename regex capture from BUILD block to filetype builder

WriteExcel: * set worksheet name * use scalar filehandle for xlsx filetype to allow both data return and file save functions * seperate _write_xlsx_row() function to handle write_row and write_bold_row * row counter starts at A1, auto-increments as expected (A2, A3, etc) * changes should allow call to both data() & save() for both filetypes

first draft of Local::WriteExcel - creates xls or xlsx file using Spreadsheet::WriteExcel::Simple syntax * can save file or return data for xls file but only save xlsx file