Questions tagged [excel]
{excel} concerns interchanging data between Microsoft Excel and (La)TeX.
77 questions
0
votes
1
answer
53
views
extract data from excell file [closed]
Well, I tried to understand your code or your code and I also consulted the tutorial indicated by cfr, and I admit that I don't understand anything and that it will take me a little time to master ...
1
vote
2
answers
104
views
How to bring an Excel table to latex with multiple hierarchies
I have the following case:
A MS Excel spreadsheet has been created that shows a hierarchy of classifications on the left side. On the right side the number of assignments needs to be shown.
How can I ...
1
vote
1
answer
230
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
1
answer
3k
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 ...
0
votes
1
answer
564
views
How to add excel tables with colors into overleaf?
I have this timeline made using Excel and I was wondering if there is an easy to transfer this into Overleaf -
1
vote
2
answers
809
views
Importing Excel cells into LaTeX
I'm doing my first project in LaTeX and I needed to retrieve values from an Excel file. I don't want/need to import the whole file but I need to reference some cells.
I would need to do something like:...
0
votes
1
answer
155
views
Creating latex files from the data stored as excel
I have an excel file containing five columns which include questions and four options. These questions are written using latex tags. Is there any way to automate the process of creating a pdf file ...
1
vote
1
answer
142
views
How to Insert tables side by side
I've created two tables side by side making copy/past from excel to website tablesgenerator.com. I've deleted the central column to divide two tables but I'm not satisfied of the result because it ...
3
votes
3
answers
791
views
Convert Dotted lines to solid lines in latex
I want to display the following table in my Overleaf Latex File
So I draw this table in the excel and using the excel AddsIn of "converExcelToLatex", I generated the following latex code
\...
0
votes
1
answer
5k
views
latex table generator software
I need to build a table in overleaf, most of the content of the cells have a lot of content that in excel would be wrapped to make them fit. I have tried all the online table editors and also tried to ...
1
vote
2
answers
4k
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....
6
votes
5
answers
63k
views
Export Excel tables to Overleaf
Good morning everyone,
I have been trying to export Excel tables to my Overleaf file. I have succeeded to some extent using \includegraphics command, but the problem with that is that the font size ...
2
votes
3
answers
1k
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
1
answer
879
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 ...
2
votes
2
answers
145
views
pdfs with datas from a special column in a table based database (like excel) + pictures
I am quite new in tex, but now I have to:
compile several pdfs with the same layout (not so important if separated physically in different files or just as pages in one file)
from 1 column of datas ...
0
votes
0
answers
869
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:
...
3
votes
1
answer
105
views
Forming totals in cell of tabular environment. Macro expansion or inline eval possible for simple arithmetic?
I have a tabular environment with a dozen or so itemized lines, each with a numeric integer cost. I would like to display a total in the last row. I've edited items in the table several times over a ...
1
vote
0
answers
607
views
Equation as excel axis title [closed]
I'd like to use as axis title an equation in excel 2016, there is no official
way it seems. Would anyone happen to know a good solution?
I tried to paste my equation as a picture from clip board, ...
0
votes
0
answers
122
views
On merging Excel and Tex files
I am doing some teaching and need some help to make the process of page-proof faster. For the last exam participants are given a piece of paper of the following format:
Name Surname
some info
and ...
3
votes
1
answer
5k
views
How to import table in Excel?
I would like to know if it is possible to copy a table from Excel with the configurations to Latex.
I use Microsoft Excel 2016 for Max OS X.
Thank you!
1
vote
0
answers
1k
views
Font consistency with Excel graphics
I am using Excel to create graphs to then include in my document.
The workflow is as follows:
Create Graph in excel, adjust width to same width as found from \textwidth, set font to "Book Antiqua" and ...
1
vote
0
answers
855
views
How do insert a pdf or excel spreadsheet neatly?
I have a rather complicated excel-spreadsheet with calculations.
I would like to insert this into my document so it looks quiet neat. It easily fits one page with title, caption, etc.
I tried ...
16
votes
4
answers
2k
views
Preparing a special exam sheet for every student
I am wondering if there is a way to read the data from an excel file and then somehow using a forloop outside a tabular, get a special exam sheet for each student.
Until now, we have been using a ...
2
votes
0
answers
2k
views
Importing Table form Latex to Excel. [duplicate]
Is there any way to Import a table from Latex to Excel or any other format ?
3
votes
1
answer
2k
views
How to merge data and create multiple documents?, similar to personalized mailings
I would like to use LATEX combined with EXCEL data files (or CSV if it were neccessary) to create "proof of payment".
Supose a list of people
John McEnroe, NYC (USA), 110.23$, 10$,May......
Mary ...