50

If I have a table from an excel file which I print screened and posted as a figure in LaTeX. However, I want to make it a table. Problem is, the particular table has a lot of values in it so making it into a table manually is pretty tedious.

Is there a way to be able to reference an image as a table instead?

0

3 Answers 3

76

You can put \includegraphics... into a table floating environment:

\begin{table}
  \caption{A stunning table}
  \label{tbl:excel-table}
  \includegraphics[width=\linewidth]{excel-table}
\end{table}

The distinction between table and figure is a semantic one—separate counters etc., but technically, they work the same.

3
  • Can the opposite be done too? Refer a table as a figure?
    – PGupta
    Commented Dec 31, 2020 at 16:41
  • 1
    That's what I tried to express with the last sentence.
    – Svante
    Commented Jan 5, 2021 at 20:33
  • I started looking for this on the internet a little tense, because I didn't want to have to rewrite my excel tables in latex. Thank you very much!
    – Pereira
    Commented May 2, 2021 at 4:58
6

Use the \captionof command (it is included in the caption package).

\begin{figure}[htb]
\centering
\includegraphics[width=0.7\linewidth]{./img/some_image.png}
\captionof{table}[foo]{foobar}
\label{img:foobar}
\end{figure}
2
  • 4
    I would not recommend this, because this could disturb caption styling, hyperlinks etc.
    – user2574
    Commented Jul 19, 2011 at 7:09
  • But this is useful in a minipage, where I cannot use the first solution by Svante of replacing "figure" by "table". Commented Feb 16, 2016 at 23:30
2

You can save your excel file as .csv file(comma delimited). I found a converter( a CSV to LaTeX file converter) It should work.

If you want to plot a graph from excel .csv file. u could follow http://en.wikibooks.org/wiki/LaTeX/Tips_and_Tricks#Graphs_with_gnuplot

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .