Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
89 views

ExcelLink stop working after Windows 10 update

After Windows Update KB4508433 & KB4512508, ExcelLink stop to work. If I uninstall these updates, it work again, but windows return to install them... ...
3
votes
1answer
240 views
1
vote
1answer
47 views

Interpolating data from Excel

Sorry for the probably mainstream question, but I have not found the answer I was looking for yet. I have this Excel file: https://drive.google.com/file/d/1UhkYdoaqXQIsf6opOx-EBgG7xPxxHga3/view and I ...
3
votes
1answer
153 views

Problem with Excel export with specific hyperlink

Bug introduced in 8 or earlier and persisting through 12.0 Exporting Hyperlink[] to XLSX works usually just fine, but with this particular link ...
2
votes
1answer
65 views

How to import a part of an Excel file?

I'm trying to import a part of an excel, the column 20 and the row between 6-59 in this column. I tried : tab = Import[ "file.xlsx"]; time = tab[[20, 6 ;; 59]] ...
1
vote
1answer
105 views

How do I create multiple plots from an Excel spreadsheet?

I have imported an Excel spreadsheet with dimensions {row, col}= {92, 28} into Mathematica, I want to plot 27 datasets from the spreadsheet: column 1 with column 2, column 1 with column 3, ..., column ...
1
vote
1answer
51 views

How to import XLSX data as integers?

I am importing simple 0s and 1s array from Excel myDep = Import[ FileNameJoin[{NotebookDirectory[], "dependencies.xlsx"}], {"Sheets", "Data"}] All good ...
6
votes
2answers
3k views

Exporting interpolating functions to excel

I have a question about exporting an InterpolatingFunction to Excel. I checked the forum, but I still couldn't completely understand how to solve my problem. Could ...
1
vote
1answer
232 views

How to plot cumulative stock return using Excel data?

I have an Excel file with daily prices and returns of a number of stocks. I need to plot a cumulative return for each stock. How can i do this, using Excel data, ...
0
votes
1answer
137 views

Package to read in data from excel files

I want make a package to add a function to Mathematica that reads all excel files is the working directory that is set after the package is loaded. ...
2
votes
2answers
144 views

Importing Excel File as Dataset

This might be a basic question but I couldn't get it to work. I have a dataset in Excel that I import to mathematica using ...
18
votes
2answers
841 views

Formatting Excel Borders with .Net

I have various tables generated in a Mathematica application and need to export this to MSExcel formatted in a specific way. The ...
4
votes
4answers
554 views

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

I want to import an excel .csv file and ListPlot the data. ...
3
votes
2answers
162 views

Importing an Excel file as a structured dataset

I need to import an Excel file as a dataset with row and column headers, and the following option using "Dataset" does not work. However, I can import the Excel file using "Data" option as a list ...
0
votes
1answer
497 views

Sort Excel File Natural Order

Preferable without reading and then rewriting an excel(vs the COMLink) file how might I sort an excel file by Natural Order based on a column? This question is similar although probably not as ...
2
votes
0answers
71 views

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 ...
9
votes
2answers
160 views

Problem with Excel operation in NETLink way

I'm using the NETLink package to build a Excel file and trying to fill it with some data as this: ...
3
votes
1answer
73 views

Excel to Mathematica and plot [closed]

I have an csv file that I open with excel. In it 2 columns of numbers. I'd like to import it to mathematica and plot it. How can I do ?
0
votes
2answers
88 views

Plotting Imported Excel Data With Specific Format into Mathematica 3-Dimensionally

EXCEL SPREADSHEET I have an Excel spreadsheet (link to it and its image given) that contains data I want to graph three dimensionally. Purple is for the x-axis values (wavelength). Blue is for the ...
0
votes
2answers
358 views

Creating a plot using data imported from Excel

I am trying to create plots starting from values that I have in an Excel spreadsheet. The values of interest are contained in three rows, which I will call 1, 2, and 3 for the sake of this discourse. ...
2
votes
2answers
462 views

Import data from Excel and plot in Mathematica

I'm trying to Plot data in Mathematica that I upload from Excel. The Excel file has 5 columns. The first column I would like to be the x-values, and the remaining ...
2
votes
1answer
62 views

Format FinancialData into MS Excel. How can I curate the data before exporting it?

My goal is to curate the following data before I export it as a CSV to open in Excel. I have downloaded financial data for more than one asset, like the following: ...
1
vote
1answer
78 views

Drawing a surface using an Excel file

I’m totally new to Mathlab. I have the following ‘grid data’ to be read from ‘Office Excel’ that I need them to be drawn as a surface in the Mathematica or Mathlab. I’ve done this with the ‘Surface’ ...
1
vote
2answers
300 views

How can I detect and delete any row with a NULL value when importing from Excel?

I'm attempting to do a code for Wolfram Mathematica I am uploading an Excel file that has a huge number of characters and multiple sheets to enter. The issue is the import is set up as a table/...
1
vote
2answers
115 views

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 ...
0
votes
2answers
180 views

Prepare a dataset in Excel then import to Mathematica

I need to prepare a dataset, which will be much easier using e.g. Excel. Then I want to import and use it in Mathematica. One row in the dataset would look like this in Mathematica: ...
1
vote
1answer
44 views

Looping and find the minimum of a function and get data in excel sheet

I have written a code. I want to change y from (*10^-4 to 10^-6) and want to find the corresponding minimum and then need to export the value of y and corresponding minimum in an excel sheet. I know ...
0
votes
1answer
83 views

Data from Excel does not show up in Bar Chart

I am trying to create a bar chart using data imported from Excel. This is how my excel file looks like. I created the following function: ...
0
votes
2answers
59 views

Labeling a list plot came from excel data set

I have made a list plot for an excel data set and I got the graph. However, I need to label each graph by its name that is already in the first cell of each column. I have 647 rows and 21 columns, but ...
4
votes
1answer
676 views

how can i associate the headings of columns/rows with content of itself and then recall what i want after i've imported the excel file in mathematica

Hello, i make another try... I have to import a file like this below (it is an excel file, i show you just the beginnig. it should have thousend of rows and columns). After i've imported the file i ...
5
votes
2answers
1k views

Importing numbers from Excel

I guess my problem is very simple but I could not find the solution by searching it. I have a column in excel sheet (Sheet1 in Book1.xlsx) including student numbers as the following. ...
0
votes
1answer
81 views

merge some elements into one in a list

I hava a list just like list = {{a1}, {a2}, {a31,a32,a33}, {a41,a42}} I want to save it to excel, but it will in different column ...
0
votes
0answers
76 views
2
votes
0answers
73 views

Apply a classifier to a column in excel and export side by side result? [closed]

I'm relatively new to using Mathematica, and I was able to create a Classifier from a training set of about 3,000 pairs of non-numerical text strings. I have my test set of about 20,000 records in an ...
2
votes
2answers
193 views

Hard time creating arrays with For/Do

So far this code Prints just a sequence of numbers, as you can see in the "Print"-Line. I would like to export the results in one excel sheet, which has rows "b,l,m,d,p,best n, value" and in each ...
1
vote
0answers
288 views

What could be wrong when using Import for an XLSX?

I am using MMA 11.2.0.0 on Win7X64. Import["combined_analysis.xlsx", {"sheet1"}] Import::noelem: The Import element "sheet1" is not present when importing as ...
37
votes
7answers
7k views

Importing a large Excel file

I'm trying to import a simple Excel file containing 94,000 rows and 52 columns of various types, mostly Reals. It's a 38-MB file. I get this super helpful error ...
5
votes
3answers
139 views

Help with fitting given data through an exponential function

I am trying to fit some data through the Mathematica function FindFit, however I encounter the errror: FindFit::fmgz: ...
1
vote
3answers
1k views

Specific data import from Excel

I guess this is really mundane question, but I can't find the answer anywhere. Having a rather complicated Excel that came from testing centre, I need to import specific data into Mathematica for ...
15
votes
3answers
3k views

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

I have a sheet in an Excel file already formatted: different colors, fonts, columns width and cells styles. I want to fill-out values from Mathematica into specific cells of that sheets, or use that ...
0
votes
0answers
107 views

Import element from large excel file

I am trying to import some rows and columns from a large excel file, but I get this error There was insufficient Java heap space for the operation. Try increasing the Java Virtual Machine heap ...
0
votes
0answers
112 views

Run Mathematica notebook using VBA

I want to run mathematica notebook using excel vba, can someone help me with a sample code?
1
vote
0answers
137 views

Convert data from excel to a list [closed]

I have imported a set of rows from a column of an Excel sheet as follows: ...
1
vote
1answer
118 views

How I can import correctly a xls sheet?

I have one excel file with a sheet "OK". I need to import the file, i tried: ...
1
vote
1answer
291 views

Exporting weather data as CSV or XLS file

I am relatively new to mathematica, and sorry if this question is too simple. I am trying to export weatherdata to a csv or xls file. ...
13
votes
3answers
5k views
12
votes
3answers
2k views

Exporting data from Excel into Mathematica using clipboard

I know that it's possible to import Excel data into Mathematica using the Import command, as we can see in this post. But sometimes I need just to do some fast ...
-4
votes
1answer
580 views

How can I export my output to excel? [closed]

so after you all helped me a lot, I got now this code: ...
2
votes
2answers
137 views

Create a hyperlink in an array to be exported as Excel file

I want to create an Excel file with some data and hyperlinks to a file. The goal is that in the end you can click in Excel the link and the file opens. The Excel file is to be exported from ...
0
votes
1answer
305 views

Import CSV spreadsheet slow

...