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
5
votes
2answers
77 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: ...
6
votes
1answer
346 views

Problem with Excel export with specific hyperlink

Bug introduced in 8 or earlier and persisting through 12.2 Exporting Hyperlink[] to XLSX works usually just fine, but with this particular link ...
2
votes
2answers
91 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....
0
votes
1answer
31 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 ...
2
votes
2answers
100 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 ...
3
votes
1answer
65 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 ...
3
votes
1answer
71 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 ...
0
votes
0answers
44 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: ...
1
vote
1answer
63 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: ...
2
votes
3answers
378 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 ...
1
vote
1answer
90 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
101 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
49 views

Exporting Mathematica data and using it in excel

I run this code: ...
1
vote
1answer
48 views

Excel output append

I currently have the following codes: ...
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
33 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
85 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
43 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
79 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. ...
6
votes
2answers
1k views

CSV vs XLS for import

I need to import data from various database sources. At the moment I plan on importing files via a CSV file or XLS. All the data if in XLS would be on one sheet (notebook). Are there any advantages ...
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
32 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
258 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
168 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
2answers
2k views

Importing a named range of cells from Excel

I have a macro (is that what you call it?) set up in Mathematica and it runs fine. What I want to do now is set up my notebook to look through an Excel document (.xlsx) and pick out a certain set of ...
0
votes
0answers
28 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
122 views

Mathematica switches file formats on import [closed]

...
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
70 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 ...
1
vote
2answers
264 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 ...
2
votes
0answers
58 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
62 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
1answer
123 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
313 views
1
vote
1answer
113 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
107 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
139 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
135 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 ...
7
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
301 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
147 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. ...
18
votes
2answers
1k 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
608 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
458 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
695 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
78 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
189 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
81 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 ?