Mathematica Stack Exchange
Mathematica Stack Exchange

Questions tagged [excel]

For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.

209 questions
11
votes
1 answer

How to access an already opened Excel file in Mathematica?

This post 4594 shows how to open a existent Excel file with Mathematica. And this 6686886 shows how to do what I need, but in C#. This 12282310 is another related one. How can I connect to a spreadsheet that is already open?
Murta
  • 26,275
  • 6
  • 76
  • 166
8
votes
1 answer

Mathematica and Excel

I have a number of large data sets in Excel and .dat from OMEdit Modelica that then need to import some or all of it to Mathematica for manipulation and plotting. Importing the data is easy enough using Import were I only need the first sheet. data…
Chris B
  • 111
  • 1
7
votes
5 answers

Excel column label from integer

I would like to create a function in Mathematica, which returns the equivalent Excel column label (e.g., A, Z, AA, AZ, and so on) given a column number. I think it can be done with IntegerString[10,26], but this representation set of this chars is…
Walter Schrabmair
  • 189
  • 5
4
votes
1 answer

Formatting imported Excel spreadsheet to include tooltips on plot

I have an Excel spreadsheet with numbers on two columns and names in a 3rd. I would like to plot a 2d graph of the first 2 columns and see the respective name from the 3rd column as a tooltip. I understand how to create the 2d graph and how to…
Dieter
  • 41
  • 1
2
votes
0 answers

Excel file reference disappears after `Import`; how to avoid this?

EDIT An excel file reference in a formula like =[source.xlsx]Sheet1!A1 will be replaced by [1]Sheet1!A1 after 'Import'. How do I avoid this or, alternatively, how do I recover the original file name that this Excel cell references to? END EDIT A…
Sander
  • 1,866
  • 11
  • 15
1
vote
2 answers

Embedded data in a notebook

I'm looking for a method to store data which have been exported from an Excel sheet in my notebook. This enables my notenook to be indepent from the Excel sheet once the data have been imported. In maple, i did like that : FromExcel:=…
Bendesarts
  • 1,099
  • 5
  • 12
1
vote
0 answers

Transform Mathematica formula into ExcelForm for copy and paste to Excel cell

What I need is a function ExcelForm[expression] which transforms a given expression into a form, which I could just copy and paste into an Excel cell. Just like TeXForm[expression] does for TeX.
Gerhard Wonner
  • 397
  • 1
  • 9
0
votes
1 answer

import from Excel adds a point to each number ...How to get rid of it?

I import an excel file c1 c2 c3 1 3 5 2 4 6 fp = NotebookDirectory[] <> "Book1.xls"; excelSheet = Import[fp] [[1]]; t1 = Grid[excelSheet, Frame -> All, Alignment -> Left, Background -> {None, {Gray, {White, LightGray}}} The table…
TraceKira
  • 363
  • 1
  • 8
0
votes
1 answer

Make BarCharts from file CSV

I have a xls file and the data are: Hour Expenses1 Expenses2 17:50 1500 2000 17:55 1750 1830 18:00 1980 1330 There are three columns and I need import the file and plot a bar graph that data. I could help with this issue
user42671
  • 1