Questions tagged [excel]
For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.
2
votes
0answers
59 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 ...
8
votes
2answers
141 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
60 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 ?
1
vote
2answers
107 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 ...
0
votes
2answers
67 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 ...
2
votes
1answer
54 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
71 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
84 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
134 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:
...
0
votes
0answers
51 views
Export data to specific rows and columns in excel sheet
I would like to collate data that exists over many .txt files into a single excel file.
I know that I can do this in Mathematica using...
...
1
vote
1answer
40 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
2answers
48 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 ...
0
votes
1answer
76 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:
...
1
vote
2answers
156 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/...
0
votes
0answers
59 views
2
votes
0answers
69 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 ...
0
votes
2answers
246 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. ...
0
votes
1answer
75 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 ...
1
vote
0answers
192 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 ...
5
votes
3answers
128 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: ...
0
votes
0answers
90 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
89 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
109 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
235 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.
...
1
vote
3answers
757 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 ...
1
vote
1answer
112 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:
...
-4
votes
1answer
392 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
185 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 ...
3
votes
1answer
134 views
Problem with Excel export with specific hyperlink
Bug introduced in 8 or earlier and persisting through 11.1.1
Exporting Hyperlink[] to XLSX works usually just fine, but with this particular link
...
0
votes
1answer
227 views
1
vote
1answer
160 views
Plot from Excel sheet, 2 Columns, 1 of those columns with 2 categories
I have the following Excel csv sheet:
It tells if an university is Public or Private, then how in debt they are in USD.
Control is only 1 or 2, (1 = Public, 2 = Private).
I want to make an statistic ...
2
votes
2answers
117 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
2answers
50 views
How to generate a list of datas from a table with more y-values
I try to create a list of data on which I can perfrom a function. But I have problems in getting the data from my Excel sheet.
My Excel sheet looks like this:
...
0
votes
0answers
43 views
Merging Excel workbooks into a single workbook using Mathematica (Redux)
In reference to:
"Merging Excel workbooks into a single workbook using Mathematica" the only solution that has worked for me so far is:
`setDir:=Quiet@Check[SetDirectory@DirectoryName@$InputFileName, ...
1
vote
0answers
105 views
Merging Excel workbooks into a single workbook using Mathematica
I have several Excel workbooks (in *.xlsx format) that I wish to merge into a single new workbook.
The data in the workbooks have exactly the same format; they contain tables similar to this one:
I'...
0
votes
1answer
760 views
how can i plot this data from excel file?
in this link i have two excel file that i want to plot them simultaneously but i can not do it. i want to draw files in one graph.
i importing data by use of:
...
4
votes
2answers
260 views
Using a Mathematica function in Excel
I'm trying to use the FinancialDerivative function in Excel and can't seem to get the formula to work, even without using cell references for the inputs.
In a ...
1
vote
1answer
467 views
List export to Excel
I want to export a nested list to Excel.
However when I try to do that every column in my list gets exported to a different sheet.
I used {} already in the Export statement to combine all colums and ...
1
vote
1answer
147 views
Extracting sheet/pages from Excel XLXS file to Mathematica [duplicate]
I'm attempting to extract a sheet in an Excel file which consists of multiple sheets. How do I instruct Mathematica to extract a specific page?
Any help is appreciated.
Thanks in advance.
4
votes
2answers
149 views
ExcelLink: How to change cell properties like font family, size and borders?
I just purchased the Mathematica Link for Excel. I can't figure out how to change the cell properties in excel using ExcelLink package? Can someone please help.
1
vote
1answer
135 views
Force to import Excel columns in original format
Is it possible to import data from Excel file so that imported values keeps their original format? I mean if cell formatted in Excel as text import it as String, if cell is integer, than import it as ...
4
votes
0answers
235 views
How to OpenSQLConnection with JDBC for “Microsoft Excel”?
I have a very large Microsoft Excel file that will not Import even after setting a 5GB heap size for Java as follows.
...
5
votes
0answers
344 views
Exporting *formatted* Excel workbooks
I export Mathematica tables to Excel every day, for sharing reports with non-Mathematica users. It exports the values without flaw, but ignores any formatting. Consider the following:
...
1
vote
2answers
128 views
Printing an array such that the values can be copied and pasted to a Excel Row
Given an array I would like to print it in Mathematica such that the values can be simply copied and pasted into an Excel's row. What is the best approach for this?
...
1
vote
1answer
136 views
Having trouble importing values from Excel into Mathematica [closed]
When I import values from an Excel workbook into Mathematica; for instance:
originalvalues = {111011, 111011.03, 112011, 112021, 112031}
they are imported as:
...
1
vote
0answers
106 views
Transform Mathematica formula into ExcelForm for copy and paste to Excel cell
What I need is a function ExcelForm[expression] which transforms a given expression into a form, which I could just copy and paste into an Excel cell.
Just like TeXForm[expression] does for TeX.
0
votes
1answer
50 views
Make BarCharts from file CSV
I have a xls file and the data are:
Hour Expenses1 Expenses2
17:50 1500 2000
17:55 1750 1830
18:00 1980 1330
There are three columns and I ...
1
vote
1answer
106 views
Import Excel with variable row number [closed]
i am importing some Excel coloumns, what perfectly works.
Unfortunatly i am current setting the range Range [2, 50] statically
...
0
votes
3answers
365 views
Read timeseries data from CSV
I am new to Mathematica and have v10.
I would like to you use the new TimeSeriesAggregate[tsdata, "Quarter", Total] feature to return aggregated descriptive stats. I import a number of columns of ...
2
votes
0answers
61 views
How do I import an entire column from an Excel Sheet [duplicate]
The Wolfram Documentation gives information on how to import an entire sheet, and an entire row, but not an entire column.
Currently, the code I have been trying to contort into a working form is:
<...
