Stack Exchange Network

Stack Exchange network consists of 174 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 [excel]

{excel} concerns interchanging data between Microsoft Excel and (La)TeX.

1
vote
1answer
61 views

How to insert Excel figures into LaTeX

How to insert excel figures to LaTeX, I tried the following method but figure resolution too bad: Step 1. Copy and paste the graph. Copy/paste your Excel graph to Visio. Be sure that it is pasted as ...
4
votes
3answers
220 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 ...
3
votes
1answer
111 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 / ...
0
votes
0answers
22 views

import and export data from excel file with latex document [duplicate]

I want to do latex document were import and export the data from it. could not rechange the excel file and do with best shape
2
votes
1answer
104 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
0answers
165 views

Convert Excel table with colours to LaTeX longtable

As the title says, I need to convert a coloured table in Excel to LaTeX. Is there any automated way of doing this? When I convert to csv and use datatools, the colours disappear. Thanks a lot.
1
vote
1answer
170 views

Import CSV file generated from Excel To LaTeX with Datatool with accent

I'm trying to import a .CSV file generated with excel that contais special characters as á, é, í, ó, ú. I'm using \DTLloadrawdb, but these characters still don't show. What is the magic trick to do ...
1
vote
1answer
280 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
375 views

The easiest way to represent (complex) tables generate their code latex ( a group of tables) which have not same repartition on latex by excel

(An urgent appel for experts in tables on latex) I have different tables which have not same number of columns (differents repartition columns, lines etc etc (please see the figure) I am obliged ...
2
votes
2answers
66 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
1answer
547 views

display a csv file in LaTeX [closed]

How can I link a csv file, and display the data in separate columns ? \documentclass{article} \usepackage{makeidx} \usepackage{datatool} \DTUoaddb[keys=c1,c2,c3]{ctext}{csvtext.csv} \begin{document} \...
0
votes
0answers
270 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: ...
1
vote
0answers
232 views

Can I import Excel Sheet to select cell and use it as text block?

I would like to write text blocks in excel and then import this excel sheet into latex to be available there in a variable with a (multi)-list-like structure. The idea is then to select certain ...
3
votes
1answer
67 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 ...
0
votes
0answers
146 views

tex equivalent of Excel's conditional formatting [duplicate]

Has anyone implemented (either through hacky own scripts or an actual package) something that emulates Excel's conditional formatting? It would be useful to have the ability to colour the contents of ...
0
votes
0answers
145 views

Publishable tables [duplicate]

I have a dataset in excel that looks like this. Is there a nice way to make this into a publishable table? Pre Post Condition1 ...
1
vote
0answers
207 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, ...
2
votes
0answers
32 views

How to get a bunch of letters/envelopes (PDF) from a list of clients (CSV)? [duplicate]

Say I have a letter like this: \documentclass{letter} \usepackage{hyperref} \signature{Joe Bloggs} \address{21 Bridge Street \\ Smallville \\ Dunwich DU3 4WE} \begin{document} \begin{letter}{...
0
votes
0answers
59 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 ...
0
votes
1answer
62 views

Index copied into Excel misreads 'fi' combination

Using R and its knitr package under Windows 10 to produce a PDF file with an index, I have found that indexed words with 'fi' in them often appear incorrectly when I copy the index into Excel [to do ...
3
votes
1answer
4k 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!
3
votes
1answer
568 views

Link LaTeX Documentation to Excel Data

I am writing documentation for a build log that needs to have part numbers inserted. Rather than have someone go through and update part numbers in a document to reflect revisions and updates, I ...
1
vote
0answers
446 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" ...
0
votes
1answer
276 views

Encoding Issue while Export from JabRef to .CSV [closed]

I am trying to export bib to .csv and there are many issues being faced but most important is encoding: special symbols are not converted properly to the same symbols e.g. " " changing to different ...
0
votes
0answers
89 views

Creating datasheets with values imported from an excel-file

I need some help with getting values out of excel using perl. I found on this forum some information about it, but it is not working: \documentclass{book} \usepackage{perltex} \perlnewcommand{\...
1
vote
0answers
275 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 ...
2
votes
2answers
729 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 ...
16
votes
4answers
902 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 ...
3
votes
1answer
289 views

Plotting in latex

I have to produce few charts a week and finding very hard/time consuming typing in code for plots using Tikz. Graphs i have to produce are simple,most of the time linear or exponential and does not ...
1
vote
0answers
834 views

Importing Table form Latex to Excel. [duplicate]

Is there any way to Import a table from Latex to Excel or any other format ?
1
vote
0answers
186 views

How to export an Excel table to latex? [duplicate]

I have many tables in Ms Excel, and I need to export to a latex file to write an article. I don't want include a figure, I want to copy/import a table from Microsoft Excel. Then I need an easy method ...
2
votes
1answer
1k 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 ...
7
votes
2answers
730 views

Extract data from excel file with lualatex

I have an Excel file that I use as a database. Of course, there are a lot of entries (more than 4000) and I don't want to use all the data to create my PDF. So I was thinking of using LuaLaTeX to ...
10
votes
6answers
60k 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
0answers
75 views

unable to use a code for import table from latex csv

Hi All I am using this code to import my Table1.csv file , but yet unsuccessful please help me which parts to edit thanks a lot: % File: essai_datatool.tex % Created: mer jui 01 09:00 ...
1
vote
0answers
40 views

Define variable to use in [trim = ???] in Figure environment [duplicate]

I use PDF figures that are output by Excel with excessive whitespace. There are only a few standard sizes, so I would like to define re-usable variable to set in the [trim = ???] option for the \...
1
vote
1answer
385 views

Creating lables - using data from excel sheets - selecting specific column

I have to create desk slips (labels). For this data is available in excel sheet. The column names are - RollNo, Subject, Venue of Exam (examination center). Presently we are creating desk slips using ...
1
vote
2answers
16k views

Insert tables and graph from Excel

I'm writing a report in LaTeX and I'm using excel to calculate, make graphs and tables. What would you recommend me to do to import it to latex? I have tried taking print-screen and import as figures,...
13
votes
5answers
13k views

Getting data dynamically into LaTeX from a spreadsheet

Is it possible to access to data from spreadsheets (i.e. excel spreadsheets) and include them dynamically into a LaTeX document? We need to compile each month a lot of factsheets and therefore want ...
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 ...
6
votes
1answer
8k views

I am having trouble importing a big excel table into latex [duplicate]

I have an excel file including the following table. How should I create something similar to it? Is it better to use the table code in latex or make a figure from it and import it to latex (I did this ...
1
vote
3answers
1k views

export graphics on excel with quality

I want to export graphs on excel to latex. How I can do it ? Save graph as image ?
6
votes
1answer
2k views

A program to export latex tables to excel/ods/csv?

I know there are tools to export excel tables to latex, but what about the other way around? I get a lot of latex tables from functions in R (e.g.: texreg) that aren't perfectly customizable via the ...
2
votes
2answers
8k views

Include data from LibreOffice Calc or MS Excel [duplicate]

I'd like to use LibreOffice Calc or MS Excel to create and edit spreadsheets and include these in LaTeX (LuaLaTeX would be fine, too). It is necessary for me to get calculated values like SUM(C2:C5) ...
1
vote
2answers
1k views

How to make a wide longtable fit on page?

I'm new to LaTeX, and copied over a table from Excel into TeXShop (mac) using the macro. I set it as a longtable because it spans two pages, but with regard to width, the table isn't fitting. Also, ...
1
vote
1answer
347 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
0answers
113 views

Automatic counter increment for bibliography statistics

I am trying to organize my bibliography in a tabular form, (with columns: year, Journal, topic...etc). The one thing I want to add, is to make a counter, so at the end, I will get automaticlly how ...
4
votes
1answer
649 views

Creating Excel documents with LaTeX

I've been using an own class with some commands for writing exams in my classes (I'm a teacher). In this, I use a rather complex point system (why I do this is kind of irrelevant) with 9 different ...
6
votes
3answers
705 views

Approach to creating graphics in book - TikZ, SVG, PDF, Inkscape?

I have a series of "charts" I created with Excel (before discovering LaTeX) to show the ROM character patterns for an old computer for inclusion in a book on retrocomputing. My dilemma is how to ...
2
votes
4answers
202 views

Algorithm for 'Plugging in' Values to Tables

Simply, if I have a table of the form: \begin{tabular}{l r r r r r l r r r r r} \hline {}&{}&{}&$n$&{}&{}&{}&{}&{}&$n$&{}&{}\\ \cline{2-6}\...