Questions tagged [excel]
For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.
183
questions
3
votes
1answer
69 views
Remove errors from sublists after Excel import
I have a very long list such as:
https://pastebin.com/9vYDLsVp
At the end of each sublist for some reason I have {,-6}. How can I remove that from each sublist of ...
1
vote
1answer
57 views
Exporting selected columns of multiple table into a single Excel file [closed]
Please suggest how to export multiple tables in a single excel file. I am trying to use the code given below:
...
1
vote
1answer
88 views
Exported Excel File - decimals
Im trying to export data from the interpolating function result to excel.
everything works fine and the plots are as expected, but if I want to export these data to excel using
...
0
votes
1answer
100 views
Exporting a multi excel files into one file
Suppose a list of students'grades in excel:
"excel files"
I want to write a program separate student grades to their respective classes and then write them in one excel file. What should I ...
0
votes
0answers
43 views
Import Accuracy/General Accuracy
r[i] = SetPrecision[
Import[epath, {"Data", epath2, 9 + counts + 5*i - 2, excelfile2}],
prec];
epath is file name, epath2 is tab, count is row, ...
0
votes
0answers
48 views
1
vote
1answer
46 views
0
votes
0answers
53 views
Loop function for a list of codes
I have a list of codes that start with importing column D of an excel sheet which has a hyperlink. Then, the code moves onto importing the text version of the hyperlink and further proceeds with ...
1
vote
1answer
31 views
Formating of cells with Dates on Exporting [closed]
I am trying to export a matrix into a .CSV file which has dates with format: Year/Month/Day.
When I try to export it into a CV those cells are converted into Day/Month/Year
When I try to export it ...
1
vote
1answer
77 views
How import Excel file from different folders
I would like to know how I can import excel files from inside different folders and save the results inside the associated folder. For example, the name of my folders are fn1={001, 002, 0045, 005, ...
0
votes
0answers
41 views
Issue with generating excel File as an output
I am running a script that saves the output in excel format. At the begging, it worked well and generates the excel file; However, after a few times running I got the following message before ...
1
vote
1answer
34 views
Issue with transferring list with different length to excel
I have two lists with different lengths and would like to transfer them to excel with the titles "Normalx+" and "Normaly+" respectively. I am using the following script, although ...
2
votes
1answer
76 views
Exporting Data to Excel, (specific sheet, and specific starting cell)
I have this code, which works properly: (I know you do not have the excess to my file mydata.xlsx, but that is not a problem, I believe.
...
1
vote
2answers
114 views
How to Export my results to an excel sheet
I have a nonlinear equation in single variable( $x \tan(x)=5$ ) and it have an infinite number of roots , I got some of them and I want to add them in a table this is my code
please, tell me how to do ...
1
vote
0answers
27 views
How to perform linear extrapolation on scatter plot?
I have five sets of data and I want to see the behavior as the data goes to 0.
This is my code so far:
...
8
votes
1answer
255 views
Mathematica and Excel
I have a number of large data sets in Excel and .dat from OMEdit Modelica that then need to import some or all of it to Mathematica for manipulation and plotting. Importing the data is easy enough ...
5
votes
2answers
167 views
Code to emulate what excel does in cells
I would like to generate a code which emulate the calculations that are being perfom in columns A and B and row 7 to 12 in the attached first image. The results of those calculations are those shown ...
0
votes
0answers
42 views
Importing Excel Files and Extracting Parts of the Dataset
I'm trying to import two Excel files that have multiple sheets to Mathematica using the following code:
...
0
votes
0answers
27 views
Exporting column data to a specific column and row range
When importing from an Excel file for the data contained in column 3 and rows 2 through 58, for example, one can use the following command:
...
2
votes
4answers
120 views
1
vote
0answers
86 views
How do I use Mathematica computation of special functions in Microsoft Excel computation?
I have a model equation which I find somehow easier to compute with some experimental data in Microsoft Excel. I had an initial model which is basically a Bessel function. In Mathematica, I was able ...
1
vote
0answers
67 views
Preserving mathematica formatting when exporting to Excel [closed]
I have a list:
lis = {{"a", "b", "c"}, {"d", "e", "f"}, {"g", "h", "c"}}
I would like to format the list such that whenever "c" occurs as the last element in a ...
2
votes
0answers
57 views
Exporting to Excel using Excel Link
I often export results from Mathematica to Excel. Then I have an auxiliary xlsm that formats the export file for me. Would Excel Link allow me to export data to Excel and to format it? The ...
0
votes
1answer
60 views
Export to CSV gives unformatted output and unexpected characters
I want to export data I collected in a Table to a CSV (or XLSX)-File.
However, the output is not very handy, it is not in a column-shape but surrounded by {} and in ...
1
vote
2answers
242 views
Properly Exporting Data to Excel
I have been looking at wind speed data from various locations. And I'd like to export this to excel. That part works. But the data are difficult to work with in excel. This is what the raw export ...
1
vote
1answer
118 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...
...
1
vote
1answer
107 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 ...
2
votes
1answer
103 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
134 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
127 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
...
2
votes
3answers
343 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
...
4
votes
4answers
604 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
425 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 ...
2
votes
0answers
77 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
188 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
80 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 ?
4
votes
2answers
1k 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
170 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
77 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
86 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
130 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
222 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
54 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
104 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
198 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
500 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
98 views
2
votes
0answers
80 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
468 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
89 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 ...
