Featured Book

LaTeX Beginners Guide

Who is online

In total there are 8 users online :: 2 registered, 0 hidden and 6 guests (based on users active over the past 5 minutes)
Most users ever online was 1327 on Tue Nov 05, 2013 7:11 pm

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 6 guests

Partner Sites

TeXwelt - Fragen und Antworten goLaTeX
TeXblog
TeXnicCenter
TeXample

Convert Excel Table to LaTeX

Add tags Information and discussion about graphics, figures & tables in LaTeX documents.

Convert Excel Table to LaTeX

Postby sabahmed on Wed Dec 21st, 2011

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.
sabahmed
 
Posts: 36
Joined: Thu Aug 4th, 2011

Re: Convert Excel Table to LaTeX

Postby sabahmed on Wed Dec 21st, 2011

now i have made the table but problem is that the verticle lines are going beyond table edges
my code is
Code: Select all  •  Open in writeLaTeX
% 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 2nd, 2012, edited 1 time in total.
sabahmed
 
Posts: 36
Joined: Thu Aug 4th, 2011

Re: Convert Excel Table to LaTeX

Postby sabahmed on Wed Dec 21st, 2011

:cry:
no reply
why
sabahmed
 
Posts: 36
Joined: Thu Aug 4th, 2011

Re: Convert Excel Table to LaTeX

Postby skanda on Fri Dec 23rd, 2011

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. :)
User avatar
skanda
 
Posts: 28
Joined: Sat May 16th, 2009


Return to Graphics, Figures & Tables

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 6 guests