Outputting '=== as string, not formula

27 views
Skip to first unread message

tibo....@gmail.com

unread,
Dec 2, 2014, 6:50:23 PM12/2/14
to ax...@googlegroups.com
Hi there,

How can I output a series of '=' without it being interpreted as a formula? I tried prepending a single quote but that shows in the cell also.

wb = xlsx_package.workbook
wb.add_worksheet(name: "formatted text") do |sheet|
lines = [
%Q{-----------------},
%Q{ blah },
%Q{'============},
]
lines.each do |line|
sheet.add_row [line], types: [:string]
end
end

Thanks for the help!

Reply all
Reply to author
Forward
0 new messages