Re: right justify strings in EXCEL::WRITE::XLSX

The module name is Excel::Writer::XLSX I presume.

You will have to use a format for the cell.

Either write the string as a string and format the cell to right-align, or write the number 0.67 and format the cell as percentage.

Both approaches are what one would do within the Excel application too.

Comment on Re: right justify strings in EXCEL::WRITE::XLSX Download Code

Replies are listed 'Best First'.
Re^2: right justify strings in EXCEL::WRITE::XLSX by fionbarr (Friar) on Jul 16, 2014 at 17:19 UTC
found it! $format->set_align('right') thanks again	[reply]
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?	[reply] [d/l]