Hot answers tagged

12 votes
Accepted

How to SemanticImport Multiple Excel Sheets

I don't think SemanticImport has been designed to deal with multiple Excel sheets. I work around this problem using Import to ...
12 votes

Importing a large Excel file

I see there are no accepted answers for this question after more than 10 months so I thought I'd have a go at it. Although I have been using Mathematica for since V8, I am only an occasional user and ...
12 votes

How to access an already opened Excel file in Mathematica?

Using SE as my rubber duck to organize ideas worked just nice. I found the answer in NETLinkUserGuide. To get current Excel session use GetActiveCOMObject instead ...
  • 25.6k
12 votes
Accepted

Fitting an exponential model: Mathematica vs. Excel

You fit a different model with Excel than what you fit with Mathematica which is why the coefficient estimates do not match. To get the coefficient estimates you present from Excel, the equivalent ...
  • 35.4k
11 votes

How can I replace ; with , in an imported excel file and to delete "

Import as Table instead of CSV, and set the "FieldSeparators" option. ...
  • 228k
11 votes

Mathematica and Excel

data = Import["ExampleData/elements.xls", {"Data", 1}] headers = data[[1]] ...
  • 351k
10 votes

Importing a large Excel file

I know this is an old question, but I ran into this problem myself. The permanent solution for me was to alter the settings of JLink directly. As for most ...
  • 111k
9 votes

Fitting an exponential model: Mathematica vs. Excel

A logistic fit looks much better than your exponential: ...
  • 37.9k
8 votes

CSV vs XLS for import

Both have advantages and disadvantages. Importing XLS is done using a Java-based application. In my experience, it is terribly slow and eats up enormous amounts of memory to the extent that it blows ...
8 votes
Accepted

Problem with Excel operation in NETLink way

In the Excel object model, the worksheet symbol Cells represents a property, not a method. In Visual Basic and other languages, many properties have a default ...
  • 67.5k
8 votes

Can I Import data into Google Spreadsheet using a Wolfram Cloud API?

Yes, it's possible to do that. Here is a toy code. ...
  • 25.6k
7 votes

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

Following discussion with WRI tech support, setting Import's “Numeric” -> False has no effect on Excel files (.xls, .xlsx), but works when importing comma or tab ...
  • 14.9k
7 votes

Import data from excel and store it permanently in notebook

it is not etirely clear for what you need that, but I think the best way to store data within a Notebook so that it is available in the next session is the ...
  • 23.2k
7 votes

Why can 10.3.1 import a 2MB excel file, but 10.4.0 cannot, with the same commands and file?

From Wolfram support: the reason 10.4.0 cannot import the excel file: the command ReinstallJava[CommandLine -> "java", JVMArguments -> "-Xmx2048m"]; is ...
6 votes
Accepted

Importing numbers from Excel

Get data x = Import["C:\\Book1.xlsx", {"Sheets", "Sheet1"}] Recover the integers for instance like this ...
6 votes
Accepted

Cannot import Excel (xls or xlsx) files which have non-ASCII characters in the name

I can reproduce this problem on OS X with Mathematica 10.0.2, but with XLS and XLSX files only. Thus it's different from this bug which existed in version 10.0.0 and affected all files, and was fixed ...
  • 228k
6 votes

Make Function from matrix

Assuming your data is two columns: time, and temperature ...
  • 2,600
6 votes

Hard time creating arrays with For/Do

You are clearly a beginner. Experienced Mathematica users run away in panic when presented so many For loops. Using Do is better ...
6 votes
Accepted

Importing Excel File as Dataset

Like the previous answer mentions, excel imports as a list Datasets corresponding to each sheet. There's a couple approaches you can take. If you have multiple sheets of interest, anything you do will ...
6 votes

Code to emulate what excel does in cells

This is simply a translation of the recursive rules indicated: ...
  • 63k
6 votes

How to Export my results to an excel sheet

I think you probably want to use NSolve instead of Reduce. roots = x /. NSolve[x Tan[x] == 5 && 0 <= x <= 100, x] Export["outfile.xls", roots] This ...
6 votes
Accepted

How to Export my results to an excel sheet

Actually, the conversion of Sequence into the List can be done easy: ...
  • 4,907
6 votes

Plot Excel data From Different Sheets

Create an excel workbook with three sheets: ...
  • 351k
5 votes
Accepted

Exporting to a single spreadsheet in excel

data You need to remove the braces around the individual data elements to obtain a rectangular table. You can do this in a number of ways: ...
  • 351k
5 votes

Using Wolfram Library Reference in Excel VBA

The Wolfram Mathematica Control is the COM footprint of the CDF Player Internet Explorer plug-in. Here is the information page for the plug-in from the Internet Explorer Add-on Manager: The registry ...
  • 67.5k
5 votes
Accepted

Import data from excel and store it permanently in notebook

My approach to this task would be to create new Input Cells within the notebook, that have the same structure as newly typed in symbol definition. ...
  • 27.2k
5 votes

extract a mxn matrix

This Dataset based method allows use of the column and row names instead of column and row indices. ds uses a list of two ...
  • 39.7k
5 votes
Accepted

Sort Excel File Natural Order

Let's walk through this solution to see how it works. First, we define some groups of characters. The characters that are in spChar list are characters like "!" ...
  • 11.7k
5 votes
Accepted

Map if-function on a list

If test is a list of numbers, your code works fine: ...
  • 228k
5 votes

References on time series analysis

You could start looking at the online reference, such as: http://reference.wolfram.com/language/guide/TimeSeries.html http://reference.wolfram.com/language/guide/SignalProcessing.html
  • 1,947

Only top scored, non community-wiki answers of a minimum length are eligible