Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel2latex]

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

0
votes
1answer
47 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.
0
votes
0answers
36 views

Excel2latex not maintaining column width

I'm very new to Latex and I'm struggling with a table (and afraid I'll be needing more tables in the future). I've seen some similar questions but can't clear on what my problem is and how to fix it. ...
3
votes
1answer
209 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
85 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
144 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
94 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
1answer
172 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,...
0
votes
2answers
234 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
226 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
359 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
151 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
262 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
382 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
560 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
555 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
266 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
360 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
75 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
815 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
1answer
11k 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.
3
votes
2answers
4k 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 ...
11
votes
6answers
71k 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
641 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
490 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
592 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} \...
6
votes
3answers
7k 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. ...
3
votes
0answers
4k 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
169 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
363 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
393 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
15k 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}...
162
votes
24answers
30k 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
3answers
60k 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 ...