Questions tagged [excel2latex]
Excel-to-LaTeX – Convert Excel spreadsheets to LaTeX tables, see http://www.ctan.org/pkg/excel2latex
48
questions
0
votes
1
answer
36
views
Problem with add-ins excel2latex
I would like to convert my excel table to latex code using the add-ins Excel2latex.xla downloaded from the website CTAN. I followed the necessary steps to add this option to excel file wich is copying ...
0
votes
0
answers
21
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
3
answers
123
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
2
answers
77
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
3
answers
121
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
1
answer
75
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
0
answers
145
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
2
answers
82
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
2
answers
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
1
answer
307
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
1
answer
677
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
1
answer
389
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
1
answer
1k
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
1
answer
236
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
1
answer
504
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
0
answers
217
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
3
answers
865
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
2
answers
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
5
answers
274
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
1
answer
563
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
1
answer
266
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
0
answers
777
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
0
answers
610
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
1
answer
844
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
2
answers
919
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
1
answer
402
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
1
answer
483
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
1
answer
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
2
answers
2k
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
2
answers
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
0
answers
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
2
answers
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 ...
28
votes
11
answers
140k
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
2
answers
885
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
1
answer
580
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
2
answers
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
1
answer
938
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
3
answers
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
0
answers
11k
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
1
answer
224
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
1
answer
407
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
1
answer
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
1
answer
460
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
1
answer
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
1
answer
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
2
answers
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}...
172
votes
26
answers
38k
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 ...
29
votes
4
answers
70k
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 ...