35

I have a question regarding LaTeX .. 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?

migrated from stackoverflow.com Jul 18 '11 at 12:34

This question came from our site for professional and enthusiast programmers.

57

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

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}
  • 4
    I would not recommend this, because this could disturb caption styling, hyperlinks etc. – Axel Sommerfeldt Jul 19 '11 at 7:09
  • But this is useful in a minipage, where I cannot use the first solution by Svante of replacing "figure" by "table". – Frank Breitling Feb 16 '16 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.