Inserting an Excel Table in a LaTeX Document

In summary, to include an excel table in a Latex document, you can export the excel file as a csv file and then use a latex table converter such as csv2latex or xl2latex. Alternatively, you can install cygwin to access unix-type software that can also convert the excel table to a latex format.
  • #1
Clausius2
Science Advisor
Gold Member
1,440
7
I want to include an excel table in a Latex document. How could I do that?

I have tried to print the table to a file .eps, but that does not give me a good result.

Is there another way?
 
Physics news on Phys.org
  • #3
faust9 said:
export your excel file as a csv file then use the csv file to make a latex table.

http://brouits.free.fr/csv2latex/

Eh, thanks.

My computer runs under WinXP, i haven't found this code for this operative system.
 
  • #4
If you install cygwin ( http://www.cygwin.com ), you can get access to lots of unix-type software.

By googling, excel latex
I found
http://www.jam-software.com/freeware/excel2latex_readme_en.txt
http://www.jam-software.com/freeware/index.shtml
and
http://csdl.ics.hawaii.edu/FAQ/chart-ps.html
http://www.hha.dk/~skj/Xl2latex.xls (Excel to LaTex table converter (xl2latex.xls), an Excel macro written by Svend Jacobsen (Aarhus School of Business). )
 
Last edited by a moderator:
  • #5
Thanks, robphy.
 

1. How do I insert an Excel table in a LaTeX document?

To insert an Excel table in a LaTeX document, you can either use the "Insert Table" option in the "Insert" tab of Excel, or you can copy and paste the table directly from Excel to your LaTeX document. You can also use the "Export" option in Excel to save the table as a CSV file and then use the "csvsimple" package in LaTeX to import the table.

2. Can I customize the appearance of the Excel table in my LaTeX document?

Yes, you can customize the appearance of the Excel table in your LaTeX document using various packages such as "tabularx" or "booktabs", which allow you to change the alignment, column width, and add borders or headers to the table.

3. How do I make sure the Excel table is properly aligned with the rest of my document?

To ensure proper alignment of the Excel table in your LaTeX document, you can use the "table" environment and specify the desired placement of the table using the "\begin{table}[placement]" command. You can also use the "center" environment to center the table on the page.

4. Can I edit the Excel table after inserting it in my LaTeX document?

No, once you insert an Excel table in your LaTeX document, it becomes a static image and cannot be edited. If you need to make changes to the table, you will need to edit the original Excel file and then reinsert the updated table in your document.

5. Are there any limitations to inserting an Excel table in a LaTeX document?

Yes, there are some limitations to inserting an Excel table in a LaTeX document. For example, the table may not maintain its original formatting, such as merged cells or cell borders. Additionally, the table may not resize properly if it is too large for the document. It is recommended to test the table in your document before finalizing it.

Similar threads

  • MATLAB, Maple, Mathematica, LaTeX
Replies
1
Views
1K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
5
Views
374
  • MATLAB, Maple, Mathematica, LaTeX
Replies
2
Views
1K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
7
Views
2K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
2
Views
2K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
3
Views
135
  • MATLAB, Maple, Mathematica, LaTeX
Replies
1
Views
2K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
12
Views
782
  • MATLAB, Maple, Mathematica, LaTeX
Replies
3
Views
6K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
13
Views
969
Back
Top