Excel css/rowstyle problem

(3 posts) (2 voices)
  1. lll.vis, Member

    I created a report using the command css (or rowstyle) to having an alternate rows color
    select 'dbr.css', 'tr.odd td { background: #D9D9D9;}';

    On the browser it works properly. But when I export into excel all the rows have a white background color.

    Only if I use cellstyle (cell by cell) I have the correct background color into excel.

    I am using the last version of mydbr. It's updated.
    Is there a solution to use a simple command as css/html/rowstyle/rowclass to having a correct style into excel?


    Posted 6 months ago #
  2. myDBR Team, Key Master

    Excel does not have an equivalent of CSS selectors. What you can do is to use dbr.rowstyle to set the style. myDBR will translate the most common CSS definitions to Excel formatting.

    select 'dbr.rowstyle', 'rowstyle';
    set @row = 0;
    select a, if ((@row:=@row + 1) % 2=0, 'background: #D9D9D9;', '') as 'rowstyle'
    from (
    select 'A' as a
    select 'B'
    select 'C'
    select 'D'
    select 'E'
    select 'F'
    ) as q;

    myDBR Team

    Posted 6 months ago #
  3. lll.vis, Member

    Thanks. I used your code. It works.

    Posted 6 months ago #


You must log in to post.