Ykhjuy

I've a CSV file what I want process with csvsimple. My desire is to color some rows based on a conditional (one specified column has bigger value). Here is an MWE:

documentclass[12pt]{article}

usepackage{filecontents}

usepackage{csvsimple}

usepackage[table]{xcolor}

begin{document}

begin{filecontents*}{mwe.csv}

a,b,c,d

1,1,2,2

1,3,2,1

end{filecontents*}

begin{tabular}{*{4}{c}}

  csvreader[

    head to column names,

    before line={ifnumd>1rowcolor{gray}fi},

    late after line={\}

  ]{mwe.csv}{}{

    a&b&c&d

  }

end{tabular}

end{document}

In this case I gave an error message:

! Misplaced noalign.  

<recently read> noalign                             

l.18   }

How can I solve it?

Your error stems from rowcolornot being at the very beginning of the row. You can fix that by adding an additional \:

    before line={ifnumd>1\rowcolor{gray}fi},

However, it would be better to use a filter (section 3.4 of the manual) to process conditionals:

documentclass[12pt]{article}

usepackage{filecontents}

usepackage{csvsimple}

usepackage[table]{xcolor}

begin{document}

begin{filecontents*}{mwe.csv}

a,b,c,d

1,1,2,2

1,3,2,1

end{filecontents*}



csvreader[tabular=cccc,

           head to column names,

           late after line=\,

           full filter=ifnumgreater{d}{1}

                        {\rowcolor{gray}csvfilteraccept}

                        {csvfilteraccept}

          ]{mwe.csv}{}{a & b & c & d}

end{document}

Here we are using ifnumgreater to check for d>1 and we print the content of the line with csvfilteraccept weather the condition holds or not, since we don't want to discard the content. We just add rowcolor{gray} to format the output and we still need an additional \ to make sure that rowcolor is at the very beginning of the row (which is awkward).

Which yields:

The formatting of the table still needs to be handled separately.

Try this solution. It adds a line break after each row.

 

documentclass[12pt]{article}

usepackage{filecontents}

usepackage{csvsimple}

usepackage[table]{xcolor}

begin{document}

begin{filecontents*}{mwe.csv}

a,b,c,d

1,1,2,2

5,3,9,1

7,8,2,9

5,3,9,1

5,3,9,1

7,8,2,9

end{filecontents*}



  csvreader[tabular=cccc,

    head to column names,

    before line={ifnumd>1\rowcolor{gray}else\fi}

  ]{mwe.csv}{}{

    a&b&c&d

  }





end{document}

If you don't else\ then you will have this result: