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

learn more… | top users | synonyms

19
votes
5answers
18k 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?
15
votes
6answers
2k views

Creating Table: On Mastering LaTeX

Guys, I am one the process of mastering LaTeX, so that later when times come I shall be fully prepared to typeset almost anything without thinking twice. So during this awesome process, I am now ...
15
votes
4answers
344 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 ...
8
votes
5answers
3k 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
579 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 ...
7
votes
2answers
183 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 ...
4
votes
1answer
3k 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
108 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 ...
3
votes
2answers
2k 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
153 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
511 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
344 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 ...
3
votes
0answers
5k 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? ...
2
votes
1answer
3k 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
370 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
2answers
223 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
1answer
294 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
2k 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
573 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
2answers
452 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
3k 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
60 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 ...
1
vote
1answer
121 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
197 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
381 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
212 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
28 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 ...
1
vote
2answers
55 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
0answers
20 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
89 views

Jabref (biblatex) to Excel (xml) [closed]

I would like to export my database with a lot of customized entry type from Jabref to Excel. I did not manage to open correctly csv files in Excel, but xml works great. Now, I want to choose the ...
1
vote
0answers
62 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
32 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
143 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
77 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
42 views

Excel2Latex Mac Excel 2011

I have read it is possible to use Excel2Latex for Mac 2011, Has anybody got this working and how? I've added the add-in but for the life on me can't get it activated and showing up on the ribbon to ...
0
votes
0answers
48 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 ...