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

learn more… | top users | synonyms

2
votes
1answer
55 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 ...
7
votes
5answers
472 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 ...
2
votes
2answers
137 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 ...
4
votes
1answer
260 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 ...
2
votes
3answers
163 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
115 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
970 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
223 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
112 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} ...
2
votes
0answers
50 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 ...
3
votes
1answer
246 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 ...
7
votes
3answers
495 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 ...
3
votes
4answers
133 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$&{}&{}\\ ...
1
vote
0answers
121 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
1answer
208 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 ...
3
votes
2answers
292 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
2answers
878 views

Similar to Excel's line charts?

How could I create charts as the follow ones, which were produced by Microsoft Excel?
4
votes
1answer
2k 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.
2
votes
0answers
3k 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
0answers
66 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 ...
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. ...
16
votes
5answers
9k 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?