Graphics, Figures & Tables ⇒ Convert Excel Table to LaTeX

[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.

[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:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
% 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

Run LaTeX here

[sabahmed]

no reply
why

[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.