# Tag Info

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 ...
• 42.3k

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

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

### Mathematica and Excel

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

### Fitting an exponential model: Mathematica vs. Excel

A logistic fit looks much better than your exponential: ...
• 49.3k
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 ...
• 69.2k

### 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.3k
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,543

### 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 ...
• 8,613

### Code to emulate what excel does in cells

This is simply a translation of the recursive rules indicated: ...
• 67.6k

### 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 ...
Accepted

### How to Export my results to an excel sheet

Actually, the conversion of Sequence into the List can be done easy: ...
• 5,189

### Plot Excel data From Different Sheets

Create an excel workbook with three sheets: ...
• 399k
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,489
Accepted

### Problem with Excel export with specific hyperlink

It is a bug. The source of the problem is the presence of symbols "{", "}", ...
• 62.1k
Accepted

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 ...
• 43.1k

### 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: ...
• 62.1k
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 ...
• 67.6k

### 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,469

### 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....
• 236k
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 ...
• 73.4k
Accepted

### Import PDF files embedded in an Excel file's cell

XLSX file is nothing else than a simple ZIP archive. If PDFs were properly embedded in the Excel document, you will find them in the xl/embeddings folder, stored as ...
• 30.5k
Accepted

### Can we extract Excel cell’s background colors?

I think this should put you on the right track: Create an Excel NETObject: ...
• 24.3k

### How to export a list of Datasets in separate sheets in XLSX?

Either it is not supported yet or there is some weird syntax for it. Anyway, you can make it work by evaluating the following code: ...
• 30.5k

### 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 ...
• 47k

### Using a Mathematica function in Excel

This works for me when I attmept to enter a FinancialDerivative call into Excel using ExcelLink: ...
• 4,292
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 ...
• 67.6k
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....
• 1,116

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

ToExpression[file /. {a_String} :> StringSplit[a, ";"]]
• 31k
Accepted

### How to import XLSX data as integers?

Konstantin, Welcome to MSE. If the data values are either 0 or 1, you can use IntegerPart to convert after importing. ...
• 10.3k