LaTeX forum ⇒ Graphics, Figures & TablesConvert Excel Table to LaTeX

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

Convert Excel Table to LaTeX

Postby sabahmed » Wed Dec 21, 2011 6:56 pm

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.

Link:
BBcode:
HTML:
Hide post links
Show post links

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

Postby sabahmed » Wed Dec 21, 2011 8:28 pm

now i have made the table but problem is that the verticle lines are going beyond table edges
my code is
  1. % Table generated by Excel2LaTeX from sheet 'table'
  2. \documentclass[12pt,a4paper,fullpage]{report}
  3. \usepackage{booktabs}
  4.  
  5. \usepackage{float}
  6. \usepackage{tabularx}
  7. \usepackage{multirow}
  8.  
  9.  
  10.  
  11.  
  12. \begin{document}
  13. \begin{table}[htbp]
  14. \centering
  15.  
  16. \small\addtolength{\tabcolsep}{-5pt}
  17.  
  18. \begin{tabular}{|r|r|r|r|r|r|r|r|r|r|r|r|r|}
  19. \toprule
  20.  
  21. \multicolumn{12}{|c}{\textbf{Deletion Attack}} & \\
  22. \midrule
  23.  
  24. \textbf{Insertion Attack} & 10 & 20 & 30 & 40 & 50 & 60 & 70 & 80 & 90 & 95 & {\textbf{Alteration Attack}} \\ \hline
  25. & \multicolumn{10}{c|}{\textbf{Decoding Accuracy}} & \\ \hline
  26. 10 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 10 \\ \hline
  27. 20 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 20 \\ \hline
  28. 30 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 30 \\ \hline
  29. 40 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 40 \\ \hline
  30. 50 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 50 \\ \hline
  31. 60 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 60 \\ \hline
  32. 70 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 70 \\ \hline
  33. 80 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 80 \\ \hline
  34. 90 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 90 \\ \hline
  35. 95 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 100 & 95 \\
  36. \bottomrule
  37. \end{tabular}%
  38. \caption{Multifaceted Attack Table}
  39. \label{tab:addlabel}%
  40. \end{table}%
  41. \end{document}
Last edited by sabahmed on Mon Jan 02, 2012 10:12 pm, edited 1 time in total.

Link:
BBcode:
HTML:
Hide post links
Show post links

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

Postby sabahmed » Wed Dec 21, 2011 9:07 pm

:cry:
no reply
why

Link:
BBcode:
HTML:
Hide post links
Show post links

User avatar
skanda
Posts: 28
Joined: Sat May 16, 2009 6:32 pm

Postby skanda » Fri Dec 23, 2011 10:48 am

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. :)

Link:
BBcode:
HTML:
Hide post links
Show post links


Return to “Graphics, Figures & Tables”

Who is online

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