The following is an example to clarify my question:
I have an excel spreadsheet with a column labeled
Period (Monthly)
I store this in a ruby variable called hperiod as:
hperiod = "Period (Monthly)"
and simply print out the header array using the sheet.add_row function as shown below:
sheet.add_row [hperiod,..,..,..,]
this works fine. But I have a requirement to break the words "Period" and "(Monthly)" on two separate lines as shown below:
Period
(Monthly)
I tried to use the standard line break in ruby in between Period and (Monthly) as shown below:
hperiod = "Period\n(Monthly)"
but that does not work.
I do this sort of thing all over my excel outputs so breaking this into two different rows will make my life very difficult. Is there a way that the line break can occur between the two words within the SAME cell?
Thanks in advance for your time.
Bharat