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

Code, edit and compile here:
% 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}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
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