Questions tagged [csvsimple]
{csvsimple} provides a simple LaTeX interface for the processing of files with comma separated values (CSV).
0
votes
1answer
44 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
43 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
13 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
36 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
19 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
25 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
25 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 ...
12
votes
3answers
449 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
55 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
58 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
16 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
79 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
176 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
115 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
112 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
58 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
158 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
40 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
155 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
55 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
94 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
100 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
181 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
108 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
121 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
99 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
77 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
476 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
46 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
203 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
99 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
36 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
33 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
104 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
75 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
113 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
19 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
224 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
94 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
101 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
77 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 ...
0
votes
1answer
344 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\...
3
votes
1answer
189 views
Format tabular cell from csv file automatically
I tried to adapt examples from 5.4
Tables with Number Formatting from csvsimple package, but no success.
Each line in my csv file has 20 fields, all of them has format like x.xxxxxx. Here is the ...
5
votes
1answer
296 views
csvreader adds extra empty row at the bottom of the table
I want to create a xltabular table by loading the content of a CSV file, which is imported by way of csvreader. At the end of the table, an extra empty undesired row is shown. I can't figure out what ...
1
vote
1answer
178 views
csvreader[] with \multirow
I would like to create this table imported by csv file. My problem is to create some multirows in the table. Like this:
This is my code:
\documentclass{article}
\usepackage{longtable}
\usepackage{...
1
vote
2answers
281 views
Cannot import csv file data to table in latex using csvsimple
I don't know why the data rows not shows up. Only the header, here is my csv file:
method,name,error,occurences
socket,socket,"ConnectionResetError(54, 'Connection reset by peer')",12
socket,socket,"...
2
votes
1answer
525 views
Importing csv Table with Underscores
I have to import a csv table whose entries contain underscores. A simple example is the following table:
FirstCol, SecondCol
Item_A, Item_B
I am trying to solve my problem with the csvsimple package ...
2
votes
1answer
128 views
csvsimple row counter processing
I am trying to list data from a csv file using csvsimple and to add automatic hyperlinks to related sections.
Issue
When working with a file with a header (but using the no head option to define a ...
1
vote
1answer
678 views
Loading data to fill a table from a csv file with multicolumn header
I'm trying to create a table that looks like this .
Currently I'm doing this ...
\begin{table}[ht!]
\centering
\begin{tabular}{|l|l|l|l|l|l|l|l|l|l|}
\hline
\multicolumn{1}{|...
1
vote
2answers
625 views
\csvreader doesn't show the table
Mainly I want to do something similar this-
\documentclass{article}
\usepackage{csvsimple}
\begin{document}
This is the summary
\csvreader[autotabular]{coefficient.csv}
\end{document}
but this is ...
