Data may have lost error

[parmindersingh1]

Excel generated on ubuntu is ok but on windows it is showing data may have lost so i used compatibility mode now it is showing blank cells but on click on blank cell showing data on formula bar

[robertomiranda]

I was having the same issue but was a mistake iterating the an array, i was overwriting info like this

worksheet.write(0, 0, ''myheader',header)
array.each_with_index do |content, i|
  worksheet.write(i, 0, conent)
end

And I solved at this way

worksheet.write(0, 0, ''myheader',header)
array.each_with_index do |content, i|
  worksheet.write(i+1, 0, conent)
end

😊