Questions tagged [excel2latex]

Excel-to-LaTeX – Convert Excel spreadsheets to LaTeX tables, see http://www.ctan.org/pkg/excel2latex

Filter by
Sorted by
Tagged with
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 ...