the answer doesn't work for excel in mac osx, I have tried:
sheet.add_row ["row1 \r\n\x0D\x0A row2"]
still doesn't work