[Tex/LaTex] csvsimple erros building csv table

csvcsvsimplekiletables

I want to use the csv package to insert tables into my document.
I am importing csv by using the \usepackage{csvsimple} command.

Then, in the code, I use \csvautotabular{Tables/test} to create the tables of a csv file with the following content:

Year,Make,Model
1997,Ford,E350
2000,Mercury,Cougar

However, when I click the PDFLatex button in Kile to generate the pdf file, I get the following errors:

enter image description here

What am I doing wrong? Is this package still working? Is there an easier/better way to download my csv tables from Google docs into latex?

Best Answer

After creating a MWE, and testing around I finally found the problem: this error occurs when csvsimple cannot find the specified file. Which is quite dumb imo. If you ask me newline errors have nothing to do with FileNotFoundExceptions...

Related Solutions

[Tex/LaTex] How to transform Google docs tables into Latex Tables

This is exactly the same problem I and my classmates were having when writing our lab reports on Experimental Physics. Since we work in groups it's great to have data on the cloud. The problem was converting sometimes dozens of tables to Latex...

So, I and a classmate of mine came up with LatexKit, a google sheets add-on that creates and exports to your Google Drive a text file containing the tabular environment of a given table.

For your case, this won't handle page width or height, nor copy the exact borders you have configured (although there is a way to overcome this, keep reading), but it can help you get started with little trouble and systematically for multiple tables.

This add-on is developed using Google apps script so, unfortunately, the lack of some features is not easily overcomeable.

It does, however, help a lot when converting tables from Google Sheets to Latex

It has some additional features that could help you or someone else in the future.

Current Features:

Handles multirow and multicolumn environment using the multirow package
Handles uncertainties notation $\pm$ (especially useful to us at experimental physics)
Although it does not replicate your table's borders it has some templates for border configuration (like hlines everywhere or vertical lines everywhere)
Allows you to configure and export multiple tables at a time using the Named Range feature.

Features that can or will be implemented (given the time and will of the community):

Configure the table to have the same alignments as in your Spreadsheet
Handle different font styles like bold, italic, etc...
And a lot more, you just have to pitch us the idea! Reach us either trough facebook or e-mail: latexkit.dev@gmail.com

Here's LatexKit in action

This is the table on the spreadsheet:

This is the exact code produced by LatexKit using the template 'grid':

\begin{tabular}{|c|c|}
 \hline
Time (h) & Temperature (C)   \\ \hline
12       & 19.5 $\pm$ 0.4    \\ \hline
13       & 20.3 $\pm$ 0.6    \\ \hline
14       & 21.8 $\pm$ 0.7    \\ \hline
15       & 20.9 $\pm$ 0.6    \\ \hline
16       & 19.7 $\pm$ 0.4    \\ \hline
\end{tabular}

This is the result when compiled in Latex:

This is really a project to the community so we would gladly take your advice to improve!

[Tex/LaTex] Simple import of data with special characters for table

Your question is quite general and such not easy to answer. But, if I understand you right, you want to use special characters in your table head and you want to read them from your csv file.

The \csvautotabular macro is intended for quick survey only and not for productive tables, since it is quite restricted. \csvreader or \csvloop are indented for normal usage.

To use the first line of a csv file as normal data line, you have to say no head and also to give column count since this first line is not read as pattern. Then, this line can be used as data line.

Still, there is and will be an important restriction: A line is not allowed to start with a backslash \.

Now, here comes an example:

\begin{filecontents*}{test3.csv}
Wei\ss{}b\"ack,\textbf{bold},c
2,2,8
3,6,9
\end{filecontents*}

\documentclass{letter}

\usepackage[utf8]{inputenc}
\usepackage{csvsimple}

\begin{document}

\csvloop{
  file=test3.csv,
  no head,              % no special treatment of first line
  column count=3,       % since no first line is given, tell about column count
  before reading=\begin{tabular}{|l|l|l|}\hline,
  command=\csvlinetotablerow,
  late after line=\\,
  late after first line=\\\hline,
  late after last line=\\\hline,
  after reading=\end{tabular}
}

\end{document}

enter image description here

Best Answer

Related Solutions

[Tex/LaTex] How to transform Google docs tables into Latex Tables

[Tex/LaTex] Simple import of data with special characters for table

Related Question