Tables as PDF images

Question

Due to time constraints I'm considering cheating a little and importing some tables I've created in Excel into my latex document. I realise I can do this quite nicely as a 'figure' using something like the following,

\begin{figure} [t]
\centering
\includegraphics[width=\textwidth,scale=1]{abc}
\caption{Plot of Testing Time Frame vs Gross Profit/.Total Commission.}
\label{fig:abc}
\end{figure}

However, obviously this is now recognised as a figure... and appears in my list of figures rather than my list of tables.

Question, is there a way of doing this but for the PDF image imported to be recognised and labelled as a table?

Answer 1

It's better to export the table as latex source than an image. By using the excel2latex tool, this is a very easy task.

To include the exported table you have to include the following packages to your main tex file: booktabs, multicol and multirow

\usepackage{booktabs, multicol, multirow}

If you don't want to use the booktabs package, you can uncheck the "Booktabs-style formatting" chechkbox in the export dialog. multicol and multirow are used as soon as you have merged cells in your excel sheet. If you don't see any \multicol or \multirowcommand in your exported table, you don't have to include this packages.

Answer 2

Use table instead of figure.

\documentclass{article}
\usepackage{graphicx}

\begin{document}
\begin{table}[hbtp]
\centering
\includegraphics[width=0.5\linewidth]{exceltable}
\caption{This is an excel table.}
\label{tab:ExcelTable}
\end{table}
\end{document}

Note:

• Adjust the width until it suits your preferences.
• The table example is taken from this site.