[Tex/LaTex] Insert tables and graph from Excel

excelfloats

I'm writing a report in LaTeX and I'm using excel to calculate, make graphs and tables. What would you recommend me to do to import it to latex?

I have tried taking print-screen and import as figures, but if the image scale isn't 100% it gets blurry and ugly.

I've been trying to export, print and save selected area as pdf. But no matter what I try, it exports with selected paper size. So it has a huge margin and I think it would take to much time to make a custom paper size for each figure.

Any thoughts?

Best Answer

For tables you can use Excel2Latex or Csv2Latex. Excel to latex sometimes has a weird bug, where it inserts an invisible character. So I prefer the latter. Some editors also have an option to insert csv as a latex table.

For figures you can install ASAP-utility which will allow you to save your figures as a image (.png, .jpg or .esp). You can then insert them in your .tex file with \includegraphics{}

Related Solutions

[Tex/LaTex] Editing LaTeX tables in MS Excel

You can import a latex table into excel.

In the excel main menu select File -> import ...
choose csv or text as file type
choose "&" as your delimiter (un-select all others)
finish

[Tex/LaTex] How to make grid of pictures span across entire page

You mention working with a two-column setup, and that whereas you currently have the entire figure environment take up the width of one column, you'd really like to have it occupy the width of the entire text block, i.e., both columns. For that, you need to switch to the figure* environment. A starred float environment always has to show up at the top of a page; hence, omit the [ht] location specifier.

Furthermore, because you want three subfigures per (now much wider) row, you should switch the width of each subfigure from 0.49\columnwidth to something like 0.31\textwidth. And, use \hspace*{\fill} to push the subfigures out to the margins, i.e., to make them take up the entire textblock. Finally, use comment symbols (%) at various line ends within each subfigure to avoid introducing spurious spaces.

The following image shows the effect of implementing these suggestions:

enter image description here

\documentclass[twocolumn]{article}
\usepackage[demo]{graphicx} % omit 'demo' option in real document
\usepackage{subfigure}
\usepackage{lipsum} % for filler text
\begin{document}
\lipsum[1-3] % start with some filler text

\begin{figure*}%
%% first three subfigures
\subfigure[Total/Avg]{%
  \label{fig:Total_scatter}%
  \includegraphics[width=0.31\textwidth]{images/Total_scatter}%
}%
\hspace*{\fill}
\subfigure[Num/Avg]{
  \label{fig:Num_scatter}%
  \includegraphics[width=0.31\textwidth]{images/Num_scatter}%
}%
\hspace*{\fill}
\subfigure[Raw/Avg]{
  \label{fig:Raw_scatter}%
  \includegraphics[width=0.31\textwidth]{images/Raw_scatter}%
}

%% second group of subfigures
\subfigure[Num/Raw]{%
  \label{fig:Num_Raw_scatter}%
  \includegraphics[width=0.31\textwidth]{images/Num_Raw_scatter}%
}%
\hspace*{\fill}
\subfigure[Total/Raw]{
  \label{fig:Total_Raw_scatter}%
  \includegraphics[width=0.31\textwidth]{images/Total_Raw_scatter}%
}%
\hspace*{\fill}
\subfigure[Num/Total]{
  \label{fig:Num_Total_scatter}%
  \includegraphics[width=0.31\textwidth]{images/Num_Total_scatter}%
}
\caption{Scatter plots of 6 pics.}\label{fig:Scatter}
\end{figure*}

\lipsum[4-10] % more filler text
\end{document}

Best Answer

Related Solutions

[Tex/LaTex] Editing LaTeX tables in MS Excel

[Tex/LaTex] How to make grid of pictures span across entire page

Related Question