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

NEW: TikZ book now 40% off at Amazon.com for a short time.

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