Questions tagged [excel]
For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.
201
questions
0
votes
1
answer
36
views
Creating table of 2 different variable and exporting them to single excel file
I want to put the results in a table for X and Rn.they are 2 different variables which don't depend on each other and plot them with X on x axis and Rn on y axis or export both of them in a single ...
- 37
0
votes
1
answer
66
views
Tips and tricks for minimization problem
I am quite new to Mathematica and would like to use it for a minimization problem.
The function I like to minimize is:
...
- 19
2
votes
1
answer
56
views
How do I name the sheets in an Excel export [duplicate]
I have a three level nested list. When I export the list as an Excel document, I get the data in three different Excel sheets, as I require. I would like to know how to change the name of the Excel ...
- 755
1
vote
2
answers
116
views
6
votes
1
answer
136
views
Can I Import data into Google Spreadsheet using a Wolfram Cloud API?
I would like to use the IMPORTDATA Google Sheets function to load a Wolfram Cloud API into my Spreadsheet. How can I do that?
- 25.3k
0
votes
1
answer
61
views
Creating a ListPlot From Imported Excel file with errors
I'm learning mathematica, and right now trying to plot a graph with error bars. What I would like to do is to import 3 lists with x values(1/viscosity), y values(permeance), and error values, and plot ...
1
vote
0
answers
108
views
Ignoring or deleting empty cells from an Excel import
I have tried all the possibilities with DeleteCases and everything at the answer in the closed question on the same subject
how to exclude empty cells when Importing from excel?
and checked my input ...
- 579
0
votes
0
answers
60
views
Error trying to import multiples excel files
I have a set of Excel files produced daily, in a folder, with names like: "GH tl data - 2021-08-01_2021-08-01.xlsx". Each file has just one worksheet. The files have many columns of data (...
0
votes
0
answers
22
views
How to rewrite Import[filename, {"XLSX", "Dataset", 1} in Mathematica 11?
The example of usage that you can find documented on the [Wolfram site][1] seems not to work in Mathematica 11. Is there another way to parse the Header of the excel file?
...
- 518
2
votes
1
answer
78
views
Exporting multiple lists (x1,y1...n) (x2,y2..n)of different lengths into same excel files separated by spaces of two columns between each (x,y) list?
I have multiple lists like this this with different lengths and different x, y values,
...
- 21
6
votes
2
answers
363
views
Fitting an exponential model: Mathematica vs. Excel [closed]
My data is:
data = {{0, 0.05}, {40, 0.079}, {80, 0.113}, {120, 0.18}, {160, 0.31}, {200, 0.5}, {240, 0.71}, {280,0.86}, {320, 1.02}};
With Excel we can fit the ...
user79703
0
votes
0
answers
96
views
how to exclude empty cells when Importing from excel?
I am very new to mathematica and I need help importing excel file. The file that I am importing has a bunch of empty cells throughout the column and it is giving me some trouble taking an average of ...
- 23
1
vote
1
answer
60
views
How to export an output in a special cell in an excel file?
My general question is: How can I put each of my outputs (a number) in a special cell of a given sheet of an excel file? for example I have built an excel file (say results.xlsx) and I want to fill it ...
- 1,047
1
vote
1
answer
48
views
5
votes
2
answers
150
views
How can I export a Dataset with graphics as an Excel file?
I would like to export a Dataset to Excel. The Dataset contains graphics. But the following does not work:
...
- 4,677
0
votes
1
answer
79
views
Import multiple sheets from one excel file to one datasheet
This is probably quite a simple question for you guys but I've just started M and I've been mulling this problem for a few days and I think I am well and truly stuck. So any help would be greatly ...
- 1
2
votes
2
answers
116
views
Plot the complete dataset as listplots
I have imported as a csv file and converted to a Dataset. The data is in the following csv format
...
- 641
2
votes
2
answers
182
views
How to Listplot data from huge DataSet?
I have this data set in .csv and I imported them to mathematica to analyze them using Import function. Now here I have only shown a part of the dataset just to give an example of how it looks in Excel....
- 641
3
votes
1
answer
84
views
Plot Excel data From Different Sheets
I have sheets 100A-100G in Excel with data I want to plot in columns E and H of every sheet. Is there a way I can take the data from each sheet and plot into a separate graph in a simple way through ...
- 61
3
votes
1
answer
77
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,531
1
vote
1
answer
156
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:
...
- 981
1
vote
1
answer
108
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
...
- 11
0
votes
1
answer
115
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 ...
- 27
0
votes
0
answers
47
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, ...
- 43
0
votes
0
answers
51
views
1
vote
1
answer
70
views
0
votes
0
answers
56
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 ...
- 51
1
vote
1
answer
50
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 ...
- 31
1
vote
1
answer
132
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, ...
- 501
1
vote
1
answer
37
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 ...
- 501
2
votes
1
answer
109
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.
...
- 290
1
vote
2
answers
150
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
0
answers
82
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:
...
- 11
8
votes
1
answer
283
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 ...
- 111
5
votes
2
answers
176
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 ...
- 421
0
votes
0
answers
53
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
1
answer
88
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
4
answers
144
views
1
vote
0
answers
87
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 ...
- 595
1
vote
0
answers
101
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 ...
- 3,183
2
votes
0
answers
73
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 ...
- 3,586
0
votes
1
answer
85
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 ...
- 67
1
vote
2
answers
465
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 ...
- 31
1
vote
1
answer
139
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...
...
- 451
1
vote
1
answer
156
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 ...
- 326
2
votes
1
answer
139
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,225
1
vote
1
answer
183
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 ...
- 139
1
vote
1
answer
178
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
3
answers
751
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
...
- 47
4
votes
4
answers
643
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.
...
- 1,225