Questions tagged [excel2latex]
Excel-to-LaTeX – Convert Excel spreadsheets to LaTeX tables, see http://www.ctan.org/pkg/excel2latex
47
questions
0
votes
0answers
19 views
formatting features of an Excel table transferred during its conversion to LaTex format
Which formatting features I used in an excel table are transferred to the conversion in LaTex language of the same table?
To do so, I am using an Excel add-in. I was wondering about it since I noticed ...
2
votes
3answers
114 views
Help with complicated table
I'm trying to replicate complicated table (scheme) from Excel:
Cells with numbers (1, 2, ...) should be more or less squared. Lines forming right angle around center table are thicker than ordinary ...
0
votes
2answers
56 views
Excel2Latex Code Borders not correct
I use Excel2latex to generate tables, and for some reason I keep getting the wrong outside borders.
This is my code:
\begin{table}[htbp]
\centering
\caption{Add caption}
\begin{tabular}{|rcc|r|...
0
votes
3answers
118 views
How do I make a complicated table with LaTex? [closed]
I want to create table like this but I am having some troubles doing it. I tried to use the Excel2LaTex plugin but it doesn't create the table I want in LaTeX.
2
votes
1answer
65 views
How to put this table in the middle in Latex?
I use begain{center} and end{center} here,but why the table is not in the middle?The following is my Latex code.
\documentclass{article}
\usepackage{float}
\usepackage{booktabs}
\usepackage{multirow}
\...
0
votes
0answers
125 views
Excel to latex conversion of tables
I would like some help in producing a table similar to the one shown the photo (photo1).
As the table was complicated to me, I am using an excel to latex converter plugin; but I am getting a ...
0
votes
2answers
56 views
Bullet points in Table - Reducing the space between rows
I want to convert an Excel table which contains some bullets to a LaTeX table; for that purpose, I used the Excel2Latex plugin. When I pasted the (produced by the Plugin) code to Overleaf, I noticed ...
1
vote
2answers
2k views
How to convert a table with multicolumns from excel to latex
My question is that different cols have different widths. each row has multicolumns whose widths change. How do i have a macro which allow me to input such table from Excel to Latex. Thanks in advance....
0
votes
1answer
253 views
Excel2Latex Table producing error
I am using Excel2Latex to create tables but I got the following errors: ! Undefined control sequence.
I have installed the multirow and multicol package, I really apppreciate your help.
% Table ...
-1
votes
1answer
567 views
Convert efficiently the long table from Excel to LATEX? [closed]
I have a long table in MS Excel.
How to convert the (long) table from Excel to LaTeX?
Yes, I have read some methods to achieve this on this site. But my table is very long.
I can' t transform ...
0
votes
1answer
330 views
Is there an alternative for Excel2Latex in Mac OS X?
When I try to export a table to latex, the Excel does not allow to copy the code. I tried with Excel 2016 and last version 16.25. I don't know if the problem is the plugin or app.
3
votes
1answer
929 views
How to import data from excel and format it as text in LaTeX?
I have a big database spreadsheet on Excel which is a list of products and I want to use its data to write formatted text in LaTeX.
The table looks like this:
Year / Name product / Details
2000 / ...
1
vote
1answer
223 views
Plotting 3d from different Excel Files
i have several Excel Files (.csv) which are built up like the following scheme:
Instruction Averange ddv
500 6717.10 300
600 7572.30 300
[...]
So basicalle the column "Instrcution" is the same in ...
2
votes
1answer
461 views
Excel2Latex column alignment
I would like to create the following (Excel) table in LaTeX:
I use the Excel2Latex add-on and get the following code (I included adjustbox to scale the table):
\documentclass{article}
\usepackage[...
1
vote
0answers
209 views
Problem with table installed from Excel2Latex [closed]
I am writing a paper for my thesis and I'm having getting a reoccurring error about " LaTeX Error: Option clash for package xcolor.
See the LaTeX manual or LaTeX Companion for explanation.
Type H ...
2
votes
3answers
768 views
Excel2latex produces broken vertical lines
So I used Excel2latex to convert the following table into latex code:
The code produced (along with the environment to make a MWE) is:
\documentclass[11pt,a4paper]{article}
\usepackage[a4paper,...
1
vote
2answers
1k views
Problems compiling a longtable
I'm currently working with a table consisting of a rather large amount of data and I want to split it onto more than one page. For this I want to use a longtable.
I simply used Excel2LaTeX in order ...
3
votes
5answers
273 views
How to make this table aligned, centered and also fit into a page?
I copied this table from excel2latex, I want this table to be centered, aligned and fit into the the page within the margin.
My code is:
\documentclass[11pt]{article}
\usepackage{booktabs,siunitx}
\...
1
vote
1answer
551 views
Excel2Latex Macros issues Mac Excel 2011 [closed]
I'm trying to get Excel2Latex to work on my Mac but I always get the same error message: When I try to open the file, excel warns me that the workbook contains macros and gives me the open to enable ...
0
votes
1answer
251 views
Fitting large table after using Excel2Latex
I'm working on my thesis document and I have a large schedule table that i did for the plannig of my project. I want to put it on a horizontal page in the annexes section, but I have several problems.
...
1
vote
0answers
746 views
Why is booktabs adding vertical space between rows of table? [duplicate]
I'm experimenting with the excel2latex tool to quickly get my Excel tables to latex code. However if I check the use booktabs package option in the Excel2Latex AddIn and paste my code into Latex I get ...
0
votes
0answers
586 views
Automating the formatting of Matlab table outputs into a TeX document
I am using Matlab table to create tables with my descriptive statistics. A typical table looks something like:
I can write this table to a perfect excel file using the function writetable as follows:
...
2
votes
1answer
811 views
Excel2Latex Formatting Issue
I am struggling with the formatting of a table I created using the Excel2Latex macro. Below you can see a screenshot of the Excel output:
Using the Excel2Latex macro, the table in Latex looks like ...
1
vote
2answers
889 views
table width - excel2latex
I converted a table from excel to latex.
My question is, how can I fit the width of the table so that it is nicely align to the margin of the A4 and, depending on the table length, A3?
I tried using
...
1
vote
1answer
383 views
Excel2LaTeX on Mac - "Invalid procedure call or argument" error
I know several topics are dealing with errors related to Excel2Latex but I could not solve my problem so I take a chance here.
I have a French version of Excel 2011 (14.6.6) on Mac OS.X.El Capitan (...
0
votes
1answer
474 views
Uninstall Excel2Latex using Mac Terminal
I installed Excel2Latex using terminal and want to uninstall it now. Does anyone know the command for this?
0
votes
1answer
78 views
Big space between 2 tables when using excel to latex
Hi I get this big gap between two tables when I upload the code generated by excel2latex as a seperate .tex file using the \include command. if I however just copy the code and run, the space is not ...
2
votes
2answers
1k views
Excel2Latex Table too wide and too long
I have a long (36 rows) and wide (15 columns) excel table and I am using excel2latex. I am having issues to adjust the width and length of it. I want the table to continue in the following pages (in ...
1
vote
2answers
15k views
Excel to latex for mac 2016
Does anyone know if there is an excel to latex converter for mac (El Capitan) with excel 2016.
3
votes
0answers
3k views
Alternatives for excel2latex working on office 2016?
It's not working on the newest office 2016. Is there any other macro can do this? Or I need to download an older version of Office.
4
votes
2answers
5k views
Using long table to split a table across multiple pages
I am using the excel to latex add in to generate tables from excel, however, when the table is too long it is not split automatically between 2 (or more pages). Is there any easy way to do this? I ...
25
votes
10answers
128k views
Converting Word or Excel tables to Latex
Is there a plug in or something that can convert Ms Word or Ms Excel tables exactly as they are (with borders etc) to Latex? I have used http://www.ctan.org/pkg/excel2latex but it removes the lines in ...
0
votes
2answers
861 views
Windows spreadsheet - latex export
I am trying to find a Windows available spreadsheet with an option of graphs export to LaTeX. It would be great to export it directly from Excel, but I've read that it is not possible furthermore I am ...
2
votes
1answer
569 views
Tables in landscape mode
I need to show Excell table below in landscpe mode including the colours of each cell.
I have used \begin{landscape} and \end{landscape} but I couldn't fix all the data in the same page.
Also I ...
1
vote
2answers
1k views
Convert table from excel to latex with format $10^{-n}$
I would like to convert a table from Mircosoft Excel to latex (on Winedt) based on Microsoft Windows operation system. The number in excel is, for instance,
1 2
1.00E-02 1.05E-03
...
0
votes
1answer
892 views
My table works in latex in general but not in beamer
I am using excel2latex to create my tables, but when I am using beamer to create presentation file, it has error. My code is :
\usepackage{lmodern}
\usepackage[english]{babel}
\usepackage{mathrsfs}
\...
7
votes
3answers
12k views
how to use Calc2LaTeX
I've installed extension Calc2LaTeX to convert OO tables into LATEX. But I don't see any extra button on OO to get LATEX CODE;
In Extension manage of OO, it's showing Calc2Latex in Enabled format.
...
6
votes
0answers
10k views
How to embed LaTeX symbols in excel sheets [closed]
I would like to embed LaTeX symbols into Excel worksheets. This basically means each cell entry needs to display equations for example. I know there is a indirect but inconvenient solution of using ...
2
votes
1answer
214 views
Table isn't displaying
\documentclass[manuscript]{aastex}
\begin{document}
\clearpage
\begin{deluxetable}{}
\tabletypesize{\scriptsize}
\rotate
\tablecaption{Sample table taken from \citet{treu03}\label{tbl-1}}
\...
1
vote
1answer
402 views
excel2latex leads to the error: "Unicode char 8... not set up for use with LaTeX"
Compiling LaTeX to pdf worked fine until I used code generated by excel2latex. Now I'm getting the error "Unicode char 8… not set up for use with LaTeX".
\documentclass{scrartcl}
\usepackage[english]...
1
vote
1answer
3k views
Excel2LaTeX code not working in LaTeX
% Table generated by Excel2LaTeX from sheet 'Sheet1'
\begin{table}[htbp]
\centering
\caption{Add caption}
\begin{tabular}{ccccccc}
\toprule
\multirow{2}[4]{*}{\textbf{Gauge Number}} &...
1
vote
1answer
449 views
What is wrong with my long table code?
I got the code for the table from excel2latex tool, then I noticed about I need \longtable package. After adding the longtable to table environment my code is giving error:
\begin{landscape}
\begin{...
9
votes
1answer
16k views
Using Excel2LaTeX in Excel 2013 [closed]
I'm using Excel 2013 and having no luck getting the Excel2LaTeX add-in to do my bidding.
When I view my add-ins from the options menu, all seems well--Excel2LaTeX shows up, and its checkbox is marked ...
5
votes
1answer
1k views
Weird problem with LaTeX/excel2latex
I try to use excel2latex for converting excel tables into LaTeX. Here is the simple code I am using:
\documentclass[10pt,a4paper]{article}
\usepackage[utf8]{inputenc}
\usepackage{amsmath}
\usepackage{...
1
vote
2answers
1k views
Error in tabular code generated from Excel2LaTeX
I used Excel2LaTeX to create a table in LaTeX and here is the code that gives me an error.
% Table generated by Excel2LaTeX from sheet 'Sheet1'
\begin{table}[htbp]
\centering
\caption{Add caption}...
171
votes
26answers
37k views
Comprehensive list of tools that simplify the generation of LaTeX tables
Manually hacking tables in LaTeX is one of the less funny things when preparing a document. Naturally, there are quite a few tools that promise to simplify this. In fact, I have somewhat lost track of ...
28
votes
4answers
69k views
Using Excel2LaTeX in Excel 2010
I just installed Excel2LaTeX in Excel 2010.
I do see it in add-ins. However, I cannot find a way to operate it. That is, there is no change in the ribbon area after the package was installed.
How ...
