Questions tagged [excel2latex]
Excel-to-LaTeX – Convert Excel spreadsheets to LaTeX tables, see http://www.ctan.org/pkg/excel2latex
53
questions
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}
\...
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{\...
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 ...
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....
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 ...
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 ...
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[...
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,...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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 ...
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
...
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}
\...
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.
...
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 ...
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}}
\...
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]...
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{...