Questions tagged [csvsimple]
{csvsimple} provides a simple LaTeX interface for the processing of files with comma separated values (CSV).
173
questions
1
vote
1answer
17 views
Boldface CSV headings
(question updated from 1 to 3 columns)
I am trying to do something supremely simple: typeset a table such as
what.csv
First,Last,Style
Bob,Marley,Reggae
Fritz,Wunderlich,Lieder
with boldface ...
1
vote
1answer
14 views
csvsimple pdflatex hangs without error
The following minimal example, using csvsimple hangs without any error.
\documentclass[a4paper,11pt]{article}
\usepackage{csvsimple}
\begin{document}
\begin{tabular}{ll}
a & b\\
\hline
\...
1
vote
1answer
23 views
csvsimple no page output
Following tex source using csvsimple does not produce any output:
\documentclass[a4paper,11pt]{article}
\usepackage{csvsimple}
\begin{document}
\csvreader[head to column names,separator=semicolon]{...
0
votes
0answers
35 views
Multicolumn table with csvsimple
I'm working on a class for a document (derived from article) and one of the components I want to have in the report is a distribution list. This list should be populated with a CSV-file (name, ...
5
votes
2answers
62 views
having problems with greek characters in a table using csvsimple
Hi this is what I wrote:
\documentclass{article}
\usepackage{amsmath}
\usepackage{gensymb}
\usepackage[utf8]{inputenc}
\usepackage{csvsimple}
\usepackage{booktabs}
\usepackage{longtable}
\usepackage[...
0
votes
0answers
20 views
csvautotabular à character and unwanted characters
I'm trying to make a table using the /csvautotabular{table1.csv} command, but in the pdf file the à character is not displayed and before the table there's: /.@cmd written
2
votes
1answer
49 views
creating csv simple double header
I am trying to include to first two rows as headers. I would like to have the units - - m m m etc. on every page and another line below.
I am not an advanced user of csvsimple, and I have not been ...
3
votes
1answer
43 views
Error in longtable with csvreader
I am getting an error while creating a longtable by importing a csv file. The MWE is as given below.
\begin{filecontents*}{monodisperse15.csv}
20,2.825,5.967,0.0,0.0,0.0,0.0
22,2.85,15.516,0....
0
votes
1answer
52 views
How to set the width of the last column with tabular package? [duplicate]
I want to generate a table with fixed column width. This works for all the columns except for the last column.
Working example (fixed column width for all column except the last one)
\documentclass{...
2
votes
1answer
28 views
How to update the generated .csv file in csvsimple package
I just started using csvsimple which looks like a great package. I wonder if it was possible to do the following
Let's say that I have a .csv file that I copy into the .tex file as follows:
\...
0
votes
0answers
20 views
CSVReader Align Columns
Is there a way to right justify the second field (after the \dotfill)?
I tried using flushright, but that did not do what I was hoping for.
\documentclass{report}
\usepackage{csvsimple}
\usepackage{...
1
vote
1answer
39 views
Compilation error when string testing using csvsimple
Consider this minimal working example:
\documentclass{beamer}
\usepackage{csvsimple,filecontents}
\begin{document}
\begin{filecontents*}{data.csv}
id,type
1,a
2,b
\...
2
votes
1answer
40 views
How can I strip the percent char of a number read by csvsimple?
I have a CSV table containing some numbers in percent with the percent char explictily written in the CSV data (that can’t be changes). Is there a (LaTeX3) way to strip the percent char and preceding ...
1
vote
0answers
48 views
Cannot input utf8 encoding with csvreader
I am trying to generate a table with \csvreader. The problem is latex is ignoring when I have some german chars such as; ü,ä,ö
How can I fix this?
Here is the code:
\documentclass{article}
\...
2
votes
3answers
83 views
csvreader with tabular (to generate entire table) with caption
I have the following MWE that works:
\begin{filecontents*}{\jobname.csv}
Project, Size
A_b,-0.1237466
b,0.04632737
\end{filecontents*}
\documentclass{article}
\usepackage{...
1
vote
1answer
123 views
trouble with a simple csvsimple and csvautotabular table
I have a csv file, keywords_table.csv. I made it in Excel. Here it is:
Keyword Category,Number of keywords used in searches,Examples
Names of drugs,111,"tamoxifen, aspirin, tamiflu"
Names of ...
2
votes
2answers
102 views
csvsimple respect dollar not working
I'm using csvsimple to import some columns from a csv file into a tabular environment. The CSV file contains a column where all the values are dollar amounts, so just including it directly gives ...
0
votes
0answers
117 views
Sizing table to page
Apologies for a general question but I need some help strategizing about how to include a fairly large amount of data in an article document.
Basically I have several 35x35 matrices that I need to ...
0
votes
1answer
96 views
Removing quotes in csvsimple
Before someone marks this as a duplicate question, I have read this answer, and it has not helped.
I have a csv file:
"headline","similarity"
"Tesco directors in scandal",""
"Tesco suspends three ...
3
votes
1answer
66 views
Possible Bug in passing variables from CSV
I think there's a bug in calling decimal numbers from CSV files. Have a look.
Create a Folder.
Add a CSV file called texDemo.CSV with the following in it.
UniqueID,Name,DecimalPercentageComplete,...
2
votes
1answer
21 views
Combine datetime2 and csvsimple
How can I make the following code compile:
\documentclass{standalone}
\usepackage{csvsimple}
\usepackage{datetime2}
\usepackage{filecontents}
\begin{filecontents*}{test.csv}
a,b
2019,00:00:00
2019,...
1
vote
1answer
56 views
Don't do anything if CSV column is empty — How do I achieve this?
MWE (actually not totally MWE, but I think it's easier to see what happens this way):
\documentclass{article}
\usepackage{csvsimple}
\usepackage{graphicx}
\begin{document}
\setlength\unitlength{1cm}...
2
votes
1answer
39 views
Adding/subtracting to the /thecsvrow number in csvsimple
Assume a simple example centered on the csvsimple package.
\documentclass{standalone}
\usepackage{csvsimple}
\usepackage{fp}
\usepackage[table]{xcolor}
\begin{filecontents*}{input.csv}
Foo,...
2
votes
1answer
48 views
Color background for title row in csvsimple
Assume a simple example centered on the csvsimple package.
\documentclass{standalone}
\usepackage{csvsimple}
\usepackage{fp}
\usepackage{xcolor}
\begin{filecontents*}{input.csv}
Foo,Bar,Baz,...
2
votes
1answer
36 views
Strange csvsimple output when the line starts with an accented character
The code example below produces an undesirable result, where an Omega appears on the 5th line and all data from the 6th line appears glued to the last cell in the 5th line.
Does anyone knows what ...
13
votes
3answers
534 views
Populate information from a csv file into a LaTeX document (specifically into the fields/arguments of commands therein)
I have some personal information stored in a plain CSV file personal_info.csv in the following format:
personal_info.csv
83 Fancy Avenue,Nowheresville,Gotham City 24061
123 456 7890
someone@xyz.com
...
5
votes
1answer
91 views
Automated truncating and compilation of mean and uncertainty pairs for display in table from csv file
I have to display data from a number of CSV files containing pairs of mean and uncertainty values grouped in columns, the first column containing the mean values, the second the uncertainty values and ...
1
vote
1answer
117 views
csvsimple - process column names with digits correctly
I have a csv that contains column names with digits. Somehow this seems to be a problem for csvsimple, but I can't quite figure out why and how to deal with it correctly.
Here's what I want to ...
0
votes
0answers
35 views
Importing a csv Tablehead into latex, with too many columns
I tried importing a csv table, using the package csv simple:
\documentclass[11pt,a4paper]{scrartcl}
\usepackage{csvsimple}
\begin{filecontents*}{xxx.csv}
\end{filecontents*}
\begin{document}
\...
1
vote
2answers
113 views
Reading CSV file with quotes
I'm trying to read a CSV file into latex and produce a new page for every row in the file. Unfortunately, the file quotes every field, uses semicolons as delimiters, and contains underscores in the ...
4
votes
2answers
281 views
csvsimple vs. conditional row coloring
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}
\...
1
vote
2answers
275 views
Importing CSV as Long Table Not Working
I tried implementing the solution found here with multiple columns, but it is not working for me. It is just replicating the third column three times. What am I doing wrong? I know I wouldn't need a ...
7
votes
1answer
132 views
Is it possible to generate custom exams taken the student's names from a csv archive?
I'd like to generate a single PDF file containing multiple exams (template available below).
Each exam must have the field 'name' (see template) filled with the name of a student taken from a ...
3
votes
1answer
117 views
Csvsimple with nonenglish: error
Trying to parse table with russian symbols. Example csv file:
Название, Автор, Год
Бесы, Достоевский, 1871
Can't create a table from this file with any command: \csvloop, \csvautotabular{table.csv}, ...
3
votes
1answer
268 views
How to import data from excel and format it as text in LaTeX?
I have a big database spreadsheet on Excel which is a list of products and I want to use its data to write formatted text in LaTeX.
The table looks like this:
Year / Name product / Details
2000 / ...
2
votes
1answer
49 views
csvreader has integer overflow at 16384 = 2**14
I have to send quite a bit of documentation to Germany for taxes. I created some TeX files which use some CSV files to automatically generate this report. So far, I was a student and numbers were low. ...
1
vote
3answers
229 views
How to count rows of a csv?
I am using \csvreader to read a csv and I am trying to do some basic manipulation like counting the number of values and print that value in the document. For instance, how do I calculate the number ...
0
votes
1answer
58 views
csvsimple and tabular produces garbage
A simple example:
\documentclass[12pt]{article}
\usepackage{csvsimple}
\begin{document}
\begin{tabular}{|c|c|}
\csvreader[separator=pipe,head to column names]{test.csv}{}{\foo&\bar\\}
\end{...
3
votes
1answer
136 views
How do I create row and column dependent color coding using csvsimple?
I have the following MWE:
\documentclass{article}
\usepackage{csvsimple}
\usepackage{filecontents}
\usepackage{longtable}
\usepackage[table]{xcolor}
\renewcommand{\rmdefault}{ptm}
\begin{...
2
votes
1answer
136 views
raster plot with tikz in latex from csv file
I am trying to plot neuron's spikes which are stored in a csv file the following way:
time, neuron1, neuron2, neuron3,...
1,1,0,1,...
2,1,0,0,...
3,0,0,1,...
and so on...
Therefore the data ...
2
votes
1answer
295 views
How can I generate a big tabular out of a csv File?
I have a csv File with 400 lines and 3 columns and I want to generate one Table over more site (I guess there will be 3 pages).
In addition there should be 4 columns of table at one site like this:
...
0
votes
0answers
157 views
csvsimple, siunitx and tabularx
In the MWE
\documentclass{article}
\usepackage{filecontents}
\usepackage{csvsimple}
\usepackage{xcolor}
\usepackage{tabularx}
\usepackage{colortbl}
\usepackage{siunitx}
\definecolor{ColourTable}{...
2
votes
2answers
158 views
insert table generated by csvsimple package into another tex document not using that package
I'm not sure if the title describes the question clearly.
I have a latex document that uses the csvsimple package to read some columns from a large datafile and make a nice table. It works fine, but ...
2
votes
1answer
150 views
csvreader and csvstyle with siunitx: “Paragraph ended before NC@rewrite@S was complete”
I'm trying to define a csvstyle that I can use for multiple tables using csvreader, however I'm running into errors trying to separately format 'S' columns. Each table has the same column names and ...
1
vote
1answer
124 views
Csvsimple with colored rows gives black cell in the next table
What is wrong with:
\documentclass[12pt]{article}
\usepackage{fontspec}
\usepackage[american]{babel}
\usepackage{libertine}
\usepackage{xcolor}
\usepackage{colortbl}
\usepackage{csvsimple}
\...
2
votes
1answer
1k views
Creating a Table caption with csvsimple package using \csvautotabular{}
I have the following CSV dow_distribution.csv file:
DoW,ANZ Vol.,CBA Vol.,MQG Vol.,NAB Vol.,WBC Vol.,AORD Vol.,Total Vol.
Monday,3.63,1.93,0.88,3.14,3.56,457.56,470.7
Tuesday,4.11,2.12,0.92,3.64,4.07,...
1
vote
0answers
47 views
How to read chinese formating from CSV
anybody knows which package I can implement to be able to read chinese characters from a CSV file. The code works really well with english, but as soon as a make a CSV file containing chinese format, ...
1
vote
1answer
434 views
csvsimple table going off of page
I have the following CSV dow_distribution.csv file:
dow,ANZ Volume,BHP Volume,CBA Volume,MQG Volume,NAB Volume,QAN Volume,RHC Volume,TLS Volume,WBC Volume,WOW Volume,AORD Volume,Total Volume
Monday,3....
4
votes
1answer
186 views
Why csvsimple doesn't allow symbols/math in first row?
The package csvsimple is a nice tool to import large tables that were generated externally. However, it fails to interpret files with symbols or math in the header. It does neither work with tabular ...
0
votes
1answer
55 views
cite inside a csv file
I am trying to create a table from a csv file that has a citation column. Here is a sample from the csv file:
id, ref
1, \cite{ref1}
2, \cite{ref2}
when I use:
\csvreader[
respect all,
...
