search

zdavatz / spreadsheet

The Ruby Spreadsheet by ywesee GmbH
http://spreadsheet.ch
GNU General Public License v3.0
1.13k stars 240 forks source link

Adding styling to a sheet tab #266

Open Elian-Braja opened 2 years ago

Elian-Braja commented 2 years ago

I want to add custom styling to my sheet tab boxes and I can't find any way to do this with Spreadsheet gem

zdavatz commented 2 years ago

Like what? Custom colors? See the guide: https://github.com/zdavatz/spreadsheet/blob/master/GUIDE.md#writing-is-easy

Elian-Braja commented 2 years ago

On the documentation I can only add styling to excel cells but not tabs. I am referring to sheet tabs Screenshot from 2022-07-01 16-58-37 . On the example below I want to color Space Ideas, SpaceMembers and SpaceSettings tab boxes to have background color

zdavatz commented 2 years ago

try the last option here: https://stackoverflow.com/questions/865186/excel-file-with-multiple-tabs

elianbraja commented 2 years ago

I can render the excel with multiple sheets using spreadsheet gem. The only problem, as I mentioned is to color those sheet boxes as shown in the screenshot. The link provided by you has nothing to do with styling them. I am not referring to the sheet content, but to the sheet box as shown in the image.

zdavatz commented 2 years ago

The color of the sheet boxes I do not know, sorry. You will have to dig into the code I guess.