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

learn more… | top users | synonyms

10
votes
5answers
5k 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 ...
20
votes
5answers
23k views

Is it possible to put MS Excel graphs into a LaTeX document?

I will be using Microsoft Excel to produce graphs and I was wondering if there was a simple way to put those graphs into a LaTeX document?
2
votes
1answer
416 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
321 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,...
15
votes
4answers
437 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 ...
7
votes
3answers
603 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 ...
5
votes
1answer
4k views

Editing LaTeX tables in MS Excel

I have a big LaTeX table that I want modify it in Excel, is there any solution? There is some good solutions for converting Excel table to Latex tables.
1
vote
1answer
206 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 ...
2
votes
2answers
4k 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) ...
2
votes
2answers
7k 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 ...