Graphics, Figures & TablesConvert Excel Table to LaTeX

Information and discussion about graphics, figures & tables in LaTeX documents.
Post Reply
sabahmed
Posts: 36
Joined: Thu Aug 04, 2011 8:55 pm

Convert Excel Table to LaTeX

Post by sabahmed »

hello everyone,

i have made a complex table in excel 2007 and i know its a lengthy task to make this table in latex . can any one please guide me to how to convert this table to latex.

Recommended reading 2024:

LaTeXguide.org • LaTeX-Cookbook.net • TikZ.org

Learn LaTeX easily with newest books:

The LaTeX Beginner's Guide: 2nd edition and perfect for students writing a thesis

The LaTeX Cookbook: 2nd edition full of practical examples for mathematics, physics, chemistry, and more

LaTeX Graphics with TikZ: the first book about TikZ for perfect drawings in your LaTeX thesis

sabahmed
Posts: 36
Joined: Thu Aug 04, 2011 8:55 pm

Convert Excel Table to LaTeX

Post by sabahmed »

now i have made the table but problem is that the verticle lines are going beyond table edges
my code is

Code: Select all

% Table generated by Excel2LaTeX from sheet 'table'
\documentclass[12pt,a4paper,fullpage]{report}
\usepackage{booktabs}

\usepackage{float}
\usepackage{tabularx}
\usepackage{multirow}




\begin{document}
\begin{table}[htbp]
  \centering
  
  \small\addtolength{\tabcolsep}{-5pt}

    \begin{tabular}{|r|r|r|r|r|r|r|r|r|r|r|r|r|}
    \toprule
    
    \multicolumn{12}{|c}{\textbf{Deletion Attack}}  & \\ 
    \midrule
    
    \textbf{Insertion Attack} & 10    & 20    & 30    & 40    & 50    & 60    & 70    & 80    & 90    & 95    & {\textbf{Alteration Attack}} \\ \hline
          & \multicolumn{10}{c|}{\textbf{Decoding Accuracy}}                             &  \\ \hline
    10 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 10 \\ \hline
    20 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 20 \\ \hline
    30 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 30 \\ \hline
    40 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 40 \\ \hline
    50 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 50 \\ \hline
    60 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 60 \\ \hline
    70 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 70 \\ \hline
    80 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 80 \\ \hline
    90 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 90 \\ \hline
    95 & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 100   & 95 \\ 
    \bottomrule
    \end{tabular}%
    \caption{Multifaceted Attack Table}
  \label{tab:addlabel}%
\end{table}%
\end{document} 
Last edited by sabahmed on Mon Jan 02, 2012 10:12 pm, edited 1 time in total.
sabahmed
Posts: 36
Joined: Thu Aug 04, 2011 8:55 pm

Re: Convert Excel Table to LaTeX

Post by sabahmed »

:cry:
no reply
why
User avatar
skanda
Posts: 28
Joined: Sat May 16, 2009 6:32 pm

Convert Excel Table to LaTeX

Post by skanda »

Well done on getting the table into LaTeX.

Use the lscape package to rotate the table alone. You might be able to get it into the page.

Hope it helps.
Good Luck.
Skanda.

P.S: If this solved your problem, please edit your message, and choose the checkbox icon to denote that the issue is closed. This will help everyone in tackling the unsolved problems. :)
Post Reply