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

learn more… | top users | synonyms

19
votes
5answers
15k 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?
8
votes
5answers
2k 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 ...
7
votes
3answers
556 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 ...
4
votes
1answer
2k 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 ...
4
votes
1answer
3k 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.
4
votes
1answer
93 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 ...
3
votes
2answers
1k views

Similar to Excel's line charts?

How could I create charts as the follow ones, which were produced by Microsoft Excel?
3
votes
4answers
141 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$&{}&{}\\ ...
3
votes
2answers
442 views

Methods for graphing simulation data

I ran a large bootstrap simulation to gather data which I would now like to include in my paper. Currently, I have the data in an Excel spreadsheet so I could get a quick overview of what my results ...
3
votes
1answer
306 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 ...
2
votes
2answers
312 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 ...
2
votes
1answer
2k views

How to draw a plot from .xls file in pgfplot?

I want to read .xls format file in pgfplot to draw a graph. I couldn't find how to do that. Is it possible to do that? I have attached a small .xls file here for which I want to compute plot. ...
2
votes
2answers
151 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 ...
2
votes
2answers
473 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 ...
2
votes
3answers
394 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 ?
2
votes
1answer
195 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
368 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, ...
2
votes
2answers
2k 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
0answers
21 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 ...
2
votes
0answers
58 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 ...
2
votes
0answers
4k views

How to export high quality charts from excel to import in latex [closed]

I've tried exporting a chart (I have over 50) from excel as .pdf format but the fonts get changed and blurry. It looks good as a .xps file but pdflatex does not recognise this format. Any thoughts? ...
1
vote
1answer
67 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 ...
1
vote
1answer
153 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
1answer
313 views

Text does not fit into table which causes bad box errors

I use Excel2Latex to convert tables in Excel to Latex, however a problem arises when the text is too long to fit in the column and I get many bad box errors. My code is: % Table generated by ...
1
vote
1answer
179 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} ...
1
vote
0answers
45 views

Too big pdf images in latex file? [closed]

I have six 4MB pdf images of Excel graphs included in my latex code and now the compiler has much problem to load and update. Can images become too big in terms of memory or shouldn't that be a ...
1
vote
0answers
24 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 ...
1
vote
0answers
136 views

Is there any way to export an Excel table that contains images to LaTeX? [closed]

If I use the Excel2LaTeX addin, the images are not exported and the column is left empty. Is there any way to export this table that contains images without having to export each image separately? Or ...
1
vote
0answers
74 views

excel2latex table too many }s, wrong endgroups, and too many endgroups [closed]

I am having issues inputting a table generated by excel2latex into my primary document. I have called up packages bookends. And here is the code copied directly from excel2latex (in excel 2010 on a ...
0
votes
0answers
40 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 ...