Questions tagged [csvsimple]
{csvsimple} provides a simple LaTeX interface for the processing of files with comma separated values (CSV).
0
votes
0answers
19 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
27 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
32 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
40 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
57 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
54 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
70 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
110 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
61 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
55 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
15 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
44 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
30 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
39 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
29 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
489 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
61 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
82 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
23 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
92 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
224 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
191 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
123 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
78 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
213 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
43 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
192 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
56 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
112 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
112 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
237 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
123 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
137 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
119 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
87 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
821 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
285 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
139 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
41 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,
...
1
vote
1answer
42 views
Csvsimple: Customize the method of output
\documentclass[12pt]{article}
\usepackage{csvsimple,filecontents}
\usepackage{fontspec}
\usepackage[american]{babel}
\usepackage{libertine}
\begin{filecontents*}{test.csv}
H1, H2
X1, Y1
X2, Y2
X3, ...
0
votes
1answer
126 views
Excluding columns with csvsimple & autotables
first my apologies for not providing a full minimum working example.
Description:
I have a large number of (mainly large) tables in the csv format that I wish to include in a LaTeX document.
The ...
0
votes
1answer
95 views
Controlling vertical space between lines in csvautolongbook table
I'm generating tables from csv that have very specific formatting requirements in terms of captions and spacing. A few of these tables extend across multiple pages, for which I'm using csvautolongbook ...
3
votes
2answers
135 views
Unable to print without quotes in csvsimple
I am trying to print a table from .csv file which is generated by libreoffice in such a way one of the column has a value comma separated e.g John,Terang i want to print John, Terang without any ...
0
votes
0answers
25 views
How to run another tex file from within tikzposter
I want to run a separate tex file from within tikzposter. Is this possible? I can't find any examples on the internet. I want to do something like this, here but using a csvsimple package that ...
2
votes
1answer
266 views
csv issue with semicolon
using pipe as separator in csvsimple :
\documentclass{article}
\usepackage[utf8]{inputenc}
\usepackage[T1]{fontenc}
\usepackage{lmodern}
\usepackage[frenchb]{babel}
\usepackage{microtype}
\usepackage{...
1
vote
1answer
126 views
How to use a semicolon separator with csvsimple together with babel (french language)?
1) Semicolon ; separator and babel
Using the package csvsimple, I found that I can use a semicolon ; separator only if the babel package is not loaded:
\documentclass[varwidth,margin=0.5cm]{...
3
votes
2answers
112 views
CSV file and QR codes
I have a .csv file with some URLs.
First I want to store each URL in a variable.
Second I want to print the variables in QR codes.
What's the easiest way to do this?
MWE
\documentclass{article}
\...
3
votes
1answer
81 views
Import csv and multiple eps files into table
How can I import all the elements of a csv file along with corresponding eps files? Basically I have 3 columns, NSC, Name, Structure. I was able to import text using csvsimple package and I think I ...
1
vote
1answer
440 views
csvreader longtable caption repeated on every page
I am using csvreader with longtable and I added a caption in table head below is my code:
\csvreader[
longtable=ccc,
table head=\caption{Caption goes here.
}\label{tab:sometab} \\
\toprule\...
