Passing List in Pgfplotstableset

Question

I'm pretty new to LaTex, so please forgive my sloppy code. I'm trying to create a table from a csv file, and pass a list of colors in so that LaTex will color each cell of the a column of the table differently depending on the corresponding element in the list. I can't get it to work. Any suggestions?

\documentclass{article}
\usepackage{pgfplotstable,filecontents}
\RequirePackage{listofitems}


\begin{filecontents*}{test.csv}
    ColA, ColB, ColC
    0.17, 0.91, 0.67
    0.15, 0.17, 0.92
    0.48, 0.1, 0.28
\end{filecontents*}




\begin{document}
    \pgfplotstabletypeset[col sep=comma,
    ]{test.csv}
    \def\mylistOne{green, blue, orange}
    \readlist*\mylistTwo{\mylistOne}
    \newcounter{myCounter}
    \setcounter{myCounter}{-1}
    \foreachitem\x\in\mylistTwo[]{
        \stepcounter{myCounter}
        \pgfplotstableset{
            every row \themyCounter column 1/.style={
                postproc cell content/.append style={
                /pgfplots/table/@cell content/.add={\cellcolor{\x}}{},
            }
        }
    }
}
\end{document}

Is it going to repeat the colors if there are more rows? – percusse May 09 '18 at 16:22 — percusse, May 09 '18 at 16:22
No, the length of the list will match the number of rows. – Kevin Gregory May 09 '18 at 16:37 — Kevin Gregory, May 09 '18 at 16:37

percusse · Accepted Answer · 2018-05-10T14:43:43.927

I've created another column to have ease of access to the colors since the numbers match

\documentclass{article}
\usepackage{pgfplotstable,colortbl}
\pgfplotsset{compat=1.16}
\pgfplotstableread[col sep=comma]{
ColA, ColB, ColC
0.17, 0.91, 0.67
0.15, 0.17, 0.92
0.48, 0.1, 0.28
}\mytable
\def\mylistOne{green, blue, orange}

\pgfplotstablecreatecol[create col/set list/.expand once=\mylistOne]{colors}{\mytable}

\begin{document}

\pgfplotstabletypeset[
  columns={ColA,ColB,ColC},
  row setter/.style={
    every row no #1/.style={
      before row={%
      \pgfplotstablegetelem{#1}{colors}\of\mytable%
      \expandafter\rowcolor\expandafter{\pgfplotsretval}%
      }
    }
  },
  row setter/.list={0,1,2}
]\mytable


\end{document}

For single column

\documentclass{article}
\usepackage{pgfplotstable,colortbl}
\pgfplotsset{compat=1.16}
\pgfplotstableread[col sep=comma]{
ColA, ColB, ColC
0.17, 0.91, 0.67
0.15, 0.17, 0.92
0.48, 0.1, 0.28
}\mytable
\def\mylistOne{green, blue, orange}

\pgfplotstablecreatecol[create col/set list/.expand once=\mylistOne]{colors}{\mytable}

\begin{document}

\pgfplotstabletypeset[
  columns={ColA,ColB,ColC},
  columns/ColB/.style={
    postproc cell content/.code={%
      \pgfplotstablegetelem{\pgfplotstablerow}{colors}\of\mytable%
      \begingroup\edef\temp{\endgroup\noexpand\pgfkeyssetvalue{/pgfplots/table/@cell content}%
      {\noexpand\cellcolor{\pgfplotsretval}##1}}\temp%
    }
  }
]\mytable
\end{document}

Is there a way to do this so that only one of the columns is colored? — Kevin Gregory, May 10 '18 at 14:12

Passing List in Pgfplotstableset

1 Answers1