Skip to main content
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 ...
JimB's user avatar
  • 41.8k
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. ...
Szabolcs's user avatar
  • 235k
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 ...
halirutan's user avatar
  • 113k
10 votes

Mathematica and Excel

data = Import["ExampleData/elements.xls", {"Data", 1}] headers = data[[1]] ...
kglr's user avatar
  • 396k
9 votes

Fitting an exponential model: Mathematica vs. Excel

A logistic fit looks much better than your exponential: ...
Roman's user avatar
  • 47.9k
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 ...
WReach's user avatar
  • 68.9k
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. ...
Murta's user avatar
  • 26.3k
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 ...
Michael B. Heaney's user avatar
7 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 ...
GenericAccountName's user avatar
6 votes

Make Function from matrix

Assuming your data is two columns: time, and temperature ...
Aisamu's user avatar
  • 2,628
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 ...
Gustavo Delfino's user avatar
6 votes

Code to emulate what excel does in cells

This is simply a translation of the recursive rules indicated: ...
MarcoB's user avatar
  • 67.3k
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 ...
Mike Colacino's user avatar
6 votes
Accepted

How to Export my results to an excel sheet

Actually, the conversion of Sequence into the List can be done easy: ...
Rom38's user avatar
  • 5,139
6 votes

Plot Excel data From Different Sheets

Create an excel workbook with three sheets: ...
kglr's user avatar
  • 396k
6 votes
Accepted

How can I export a Dataset with graphics as an Excel file?

This solution will use external resources: python with a third-party library. Requirements: Python: use the official site to install Python xlsxwriter library: ...
Ben Izd's user avatar
  • 9,299
5 votes

Printing an array such that the values can be copied and pasted to a Excel Row

I suggest to print the data as a "TSV" string in a separate Cell: ...
Alexey Popkov's user avatar
5 votes

References on time series analysis

I made an example in Mathematica, hope this help. ...
madeinQuant's user avatar
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
Thomas's user avatar
  • 1,967
5 votes
Accepted

Import CSV spreadsheet slow

Your code opens and closes the file 2500 times for each variable. That will create some overhead. You may use the "Data" import specification for ...
Edmund's user avatar
  • 42.3k
5 votes
Accepted

Problem with Excel export with specific hyperlink

It is a bug. The source of the problem is the presence of symbols "{", "}", ...
Alexey Popkov's user avatar
5 votes
Accepted

Excel to Mathematica and plot

As mentioned in the comment above, the CSV file can be imported programmatically, which has been explained clearly in document of CSV, but I'd like introduce a more user-friendly approach in this ...
xzczd's user avatar
  • 66.7k
5 votes

Problem with Excel operation in NETLink way

It works with code. Scan[(ws@Cells[#, #]@Value = #*100) &, Range@10] It seems that vars i in ...
Jerry's user avatar
  • 2,459
5 votes

Mathematica switches file formats on import

You should always specify the format in Import. "Data" is not the format. It is the input element. Add the format to the command....
Szabolcs's user avatar
  • 235k
5 votes
Accepted

Remove errors from sublists after Excel import

You seem to have a problem that Excel puts some errors containing string expressions. If they appear in random places but you know how they look you can delete them based on their pattern. After you ...
Vitaliy Kaurov's user avatar
4 votes

How to write data from Mathematica to an existing formatted Excel file?

Here's a go at doing things from the extracted XML level. I only bothered to do this for the values, but if I ever use this I'll extend it to styles too probably. One note before we start is that ...
b3m2a1's user avatar
  • 46.9k
4 votes
Accepted

Calculate column number from alphabetic column reference in Excel

It's not clear that your question is about the Mathematica software, but just in case, here's a stab at it: ...
MarcoB's user avatar
  • 67.3k
4 votes

Using a Mathematica function in Excel

This works for me when I attmept to enter a FinancialDerivative call into Excel using ExcelLink: ...
ktm's user avatar
  • 4,242
4 votes
Accepted

Drawing a surface using an Excel file

Your data is not properly imported: things like 9.614679E+13 are not valid number in Mathematica. Once again, without knowing how you imported the data, it's hard ...
xzczd's user avatar
  • 66.7k
4 votes
Accepted

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

ToExpression[StringReplace[ToString[file], ";" -> ","]] {{0.0472, 120.9091}, {0.0454, 113.0303}, {0.0441, 106.6667}, {0.0442, 106.6667}, {0.0437, 103....
MeMyselfI's user avatar
  • 1,116

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