create excel sheet without gridlines

weshatheleopard / rubyXL

Ruby lib for reading/writing/modifying .xlsx and .xlsm files

MIT License

1.28k stars 255 forks source link

create excel sheet without gridlines #281

Closed piotrjm closed 6 years ago

piotrjm commented 6 years ago

Is there a way, using rubyXL, to create excel sheet without gridlines?

weshatheleopard commented 6 years ago

Yes there is. You just need to create cells with white backgroung as opposed to normally transparent background. The exact code to do that you'll need to figure out yourself :)