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
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 617
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|...
user avatar
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.
user avatar
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} \...
user avatar
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 ...
user avatar
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 ...
user avatar
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....
user avatar
  • 11
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 ...
user avatar
-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 ...
user avatar
  • 311
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.
user avatar
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 / ...
user avatar
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 ...
user avatar
  • 13
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[...
user avatar
  • 23
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 ...
user avatar
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,...
user avatar
  • 197
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 ...
user avatar
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} \...
user avatar
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 ...
user avatar
  • 11
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. ...
user avatar
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 ...
user avatar
  • 111
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: ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 (...
user avatar
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?
user avatar
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 ...
user avatar
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 ...
user avatar
  • 21
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.
user avatar
  • 11
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.
user avatar
  • 203
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 3
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 ...
user avatar
  • 931
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 ...
user avatar
  • 151
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} \...
user avatar
  • 77
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. ...
user avatar
  • 2,861
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 ...
user avatar
  • 161
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}} \...
user avatar
  • 269
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]...
user avatar
  • 13
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}} &...
user avatar
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{...
user avatar
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 ...
user avatar
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{...
user avatar
  • 3,499
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}...
user avatar
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 ...
user avatar
  • 12.1k
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 ...
user avatar
  • 291