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\...