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
0 answers
24 views

How can I make this fit in portrait?

Ideally, I would like to wrap the text in the first column in order for the last remaining columns to be visible even if the font has to be a bit smaller.. \setlength{\tabcolsep}{0.8pt} \...
  • 21
0 votes
1 answer
35 views

How can I make this table fit in landscape orientation?

\documentclass{article} \usepackage[utf8]{inputenc} \usepackage{pdflscape} \usepackage{geometry} \usepackage{threeparttable} \begin{document} \begin{center} \begin{landscape} \renewcommand{\...
  • 21
0 votes
0 answers
53 views

How to use properly Excel2Latex?

This is just a simple testing of Excel2Latex: Table in Excel Table converted to Latex by Excel2Latex Code in Latex for the table given by Excel2Latex: % Table generated by Excel2LaTeX from sheet '...
1 vote
1 answer
110 views

Packages for representing collected data in physics reports?

I'm an undergrad in physics and I started using LaTeX last year for my reports. In every practice, I have a bunch of data collected in Excel, which I usually have to represent (maybe for calculating ...
0 votes
0 answers
20 views

Contents imported from csv file goes beyond the page below

I want to create a one-word Q&A document. I imported the contents from a .csv file which has 104 rows, the contents go below the page and not to the next page. How do I rectify it? \documentclass[...
0 votes
1 answer
53 views

Excel to Latex code not working properly in overleaf

I'm trying to use a large analysis table in overleaf. And i'm using excel2latex but it does not seem to fit properly on the page. Following is the latex code. Can someone please help? Thanks \begin {...
0 votes
1 answer
891 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 ...
2 votes
3 answers
132 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 ...
  • 647
0 votes
2 answers
128 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
135 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
126 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
288 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
291 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
3k 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....
  • 11
0 votes
1 answer
413 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
923 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 ...
  • 311
0 votes
1 answer
499 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.
4 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
261 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 ...
  • 13
2 votes
1 answer
562 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[...
  • 23
1 vote
0 answers
237 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
981 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,...
  • 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 ...
3 votes
5 answers
279 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
695 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 ...
  • 11
0 votes
1 answer
292 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
779 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 ...
  • 111
0 votes
0 answers
676 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
919 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
963 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
469 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
514 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
80 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 ...
  • 21
1 vote
2 answers
16k 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.
  • 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.
  • 213
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 ...
30 votes
11 answers
159k 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
927 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 ...
  • 3
2 votes
1 answer
594 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 ...
  • 951
1 vote
2 answers
2k 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 ...
  • 151
0 votes
1 answer
984 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} \...
  • 77
7 votes
3 answers
14k 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. ...
  • 2,901
6 votes
0 answers
13k 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 ...
  • 161
2 votes
1 answer
225 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}} \...
  • 269
1 vote
1 answer
409 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]...
  • 13
1 vote
1 answer
4k 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
486 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{...
  • 3,559