in reply to Re: right justify strings in EXCEL::WRITE::XLSX
in thread right justify strings in EXCEL::WRITE::XLSX

found it! $format->set_align('right') thanks again
  • Comment on Re^2: right justify strings in EXCEL::WRITE::XLSX

Replies are listed 'Best First'.
Re^3: right justify strings in EXCEL::WRITE::XLSX
by Corion (Patriarch) on Jul 16, 2014 at 17:23 UTC

    The percentage format is documented in the documentation for set_num_format(). I found this by looking in the "Cell Formats" section and seeing set_num_format there for numeric formats.

    As the formats are readable as well as writable, maybe you could have created an Excel file and read the format given to a cell that shows the value like you want it?