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 ...
- 40.6k
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.
...
- 233k
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 ...
- 112k
10
votes
Mathematica and Excel
data = Import["ExampleData/elements.xls", {"Data", 1}]
headers = data[[1]]
...
- 384k
9
votes
Fitting an exponential model: Mathematica vs. Excel
A logistic fit looks much better than your exponential:
...
- 46.2k
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 ...
- 68.4k
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.
...
- 26.1k
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 ...
- 1,627
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 ...
- 1,533
6
votes
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 ...
- 7,948
6
votes
Code to emulate what excel does in cells
This is simply a translation of the recursive rules indicated:
...
- 65.8k
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 ...
- 701
6
votes
Accepted
How to Export my results to an excel sheet
Actually, the conversion of Sequence into the List can be done easy:
...
- 5,119
6
votes
5
votes
Accepted
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 "!" ...
- 12.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 ...
- 41.7k
5
votes
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,967
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:
...
- 61.5k
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 ...
- 41.7k
5
votes
Accepted
Problem with Excel export with specific hyperlink
It is a bug.
The source of the problem is the presence of symbols "{", "}", ...
- 61.5k
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 ...
- 63.8k
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 ...
- 2,409
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....
- 233k
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 ...
- 71.9k
5
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: ...
- 9,109
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:
...
- 65.8k
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 ...
- 46.6k
Only top scored, non community-wiki answers of a minimum length are eligible