Forums Search for: Excel
Excel Link and matlab -- trouble updating data
I'm using Matlab R12 with Excel 2000 under Windows ME to do some data analysis. I'm using Excel Link to pull data from cells in an ...
I'm using Matlab R12 with Excel 2000 under Windows ME to do some data analysis. I'm using Excel Link to pull data from cells in an Excel spreadsheet, then using MLEvalString a lot of times to work with the data. I have all of this written as a subroutine in the Excel workbook, which
HOW To Import Data from Excel to matlab
inHello everybody, This is my first mail to the group. I need some help on importing data from excel.. I am not that good...
Hello everybody, This is my first mail to the group. I need some help on importing data from excel.. I am not that good at matlab.. I have certain data sets in excel and i would like to plot the x and y values.. Is there some way that i
Normalised Sampling
inHi all, I know this is a Matlab discussion group, but I would like to ask regarding DSP in Excel? Can anyone please enlighten me, what does...
Hi all, I know this is a Matlab discussion group, but I would like to ask regarding DSP in Excel? Can anyone please enlighten me, what does it mean by Normalised Sampling? How many type of sampling are there? How to perform a non-normalised sampling in excel? I have been to many excel forum but majority of them are excel's expert, not DSP's expert. Thanks in advance:)
Excel Link opens new matlab process.
Currently opening an excel file whcih calls excel link will execute a totally independent matlab process. despite the fact that one...
Currently opening an excel file whcih calls excel link will execute a totally independent matlab process. despite the fact that one is already running! The same is true if i double click a .m or .mat file. how can i change this to connect to or open in the same window. alternatively,
How to access a particular row and column of a excel file.
Hey guys thanks for helping me out fo the first problem of accessing excel files through matlab. Now i have another problem.. ...
Hey guys thanks for helping me out fo the first problem of accessing excel files through matlab. Now i have another problem.. channel = ddeinit('excel','C:\bal.xls') prices = ddereq(channel,'r1c1 : r3c10') this will print out row one to row three of bal.xls file
Mat to Excel
inHI, I am trying to copy a mat file into a excel file...the function, copyfile is working..but the excel file is coming...
HI, I am trying to copy a mat file into a excel file...the function, copyfile is working..but the excel file is coming up with some junk values......can u locate the problem.. Regards, Ramesh.
Excel
I am looking to import Excel file and the Matlab gives error "spritf not compatible with "cell" " Regards, M. Imad Khan...
I am looking to import Excel file and the Matlab gives error "spritf not compatible with "cell" " Regards, M. Imad Khan Postgraduate Student School of Engineering and Technology Deakin University, Waurn Ponds Campus Geelong 3
converting matlabdates to excel dates
inI know I can use datenym function to convert exceldates to matlab dates but,,, I dont know how to convert matlabdates to...
I know I can use datenym function to convert exceldates to matlab dates but,,, I dont know how to convert matlabdates to exceldates. Also is there a way of writing a matrix output into excel data sheet? Deepa
filtering data
i am attempting to take an excel data file of acceleration values that are plotted over time and filter the data to obtain a curve. ...
i am attempting to take an excel data file of acceleration values that are plotted over time and filter the data to obtain a curve. how do you enter the excel file into matlab and then filter the data using fft. brandon
how to convert Excel sheet into Matlab files???
inHi Everyone, I have a rather strange doubt. I got the data in Excel sheet. Actually it is the time-series data obtained using...
Hi Everyone, I have a rather strange doubt. I got the data in Excel sheet. Actually it is the time-series data obtained using Power Lab ( PC version of Matlab with limited features ). And now I want to perform advanced features of Matlab on it. So can anyone tell me how can I
Re: Mat to Excel
inyou can do this: 1. copy your data from .mat file 2. paste all of them into a notepad 3. then copy everything on the notepad into the excel...
you can do this: 1. copy your data from .mat file 2. paste all of them into a notepad 3. then copy everything on the notepad into the excel file make sure you have set your computer setting (in "Regional and LAnguage Options" in the "control panel"), so that the decimal is (.) and number grouping is (,) thanks > > > > > HI, > ??? I am trying to copy a mat file i...
Excel to matlab
dear friends, I am writing a project on the deformation of Offshore monopile foundations and have gathered , among others, time(20Hz)-Extension...
dear friends, I am writing a project on the deformation of Offshore monopile foundations and have gathered , among others, time(20Hz)-Extension readings which are saved in an excel file in my pc. I wish to import this Excell file into matlab and deduce a frequecy from this Extension- time readings with the help of FFT. I also wish to identify and eleminat unchanged values of Extension (which oc...
load data
inHi every body expert in matlab, I have excel data (.xls) store in my hard disk, (for example data namely 12_1.xls, 12_2.xls, 12_3.xls ... and...
Hi every body expert in matlab, I have excel data (.xls) store in my hard disk, (for example data namely 12_1.xls, 12_2.xls, 12_3.xls ... and 12_6.xls). As I know to load excel data we use xlsread command , for my own m file: data_1=xlsread('12_1.xls); . . . bla.. bla ---> my own script to process the data_1 then I save, new_name1.txt -ascii data_1 If I want to process the ne
Intro
inHi! I am new to Matlab. I am doing PhD in Application of Neural Nets on Die Casting. Can you please tell me how to plot a graph...
Hi! I am new to Matlab. I am doing PhD in Application of Neural Nets on Die Casting. Can you please tell me how to plot a graph from data in an Microsoft Excel file? Imad
How to make a curve smooth?
inHello, I am plotting SNR ~ BER with a limited number of points i.e I have 2 series of data [x] and [y] Now I want to make it a smooth curve...
Hello, I am plotting SNR ~ BER with a limited number of points i.e I have 2 series of data [x] and [y] Now I want to make it a smooth curve of the plot(x,y) (just like in Excel). Anyone know how to do that? Thanks alot! HTH
Import xls data (Strings & Numerics)
Is there a command which will import an excel file consisting of strings as well as integers? I tried [num,txt,raw]= xlsread(Book1.xls) but...
Is there a command which will import an excel file consisting of strings as well as integers? I tried [num,txt,raw]= xlsread(Book1.xls) but it doesnt seem to work. Please help. Thanks
question on Averages in Excel tabel
inDear Friends,=20 The Excell Table below shows readings of deflection of a pile(colunms 2, 3 = and 4) that were recorded at a fequency of 20HZ....
Dear Friends,=20 The Excell Table below shows readings of deflection of a pile(colunms 2, 3 = and 4) that were recorded at a fequency of 20HZ. - That means the recordin= g was done 20 times per second (see colunm 1). Colunm 1 begins with a .00 e= nding ans increases with .05 and so on till .95 before it starts again with= .00. that the time interval between the .00s is 1 second.=20=20 I ...
OLE conflict or something
hello, i've got the following problem. I use the ExcelLink. Then through it I launch a ruther long calculus in matlab, that works...
hello, i've got the following problem. I use the ExcelLink. Then through it I launch a ruther long calculus in matlab, that works fine in stand alone matlab. In a minute, an error message saying that excel waits for the end of an OLE action of another application arrives and th
MUSIC Method
Could anyone help me convert the MATLAB code of the MUSIC Method to Excel Spreadsheet. Or is there software that can you it? ...
Could anyone help me convert the MATLAB code of the MUSIC Method to Excel Spreadsheet. Or is there software that can you it? function Px = music(x,p,M) MUSIC Frequency estimation using the MUSIC algorithm. USAGE Px=music(x,p,M) The input sequence x is assum
Neural Network related data
Hi! I was at last able to import Excel worksheet in Matlab as a single variable named A. Now when I try to import it in NNtool, ...
Hi! I was at last able to import Excel worksheet in Matlab as a single variable named A. Now when I try to import it in NNtool, 1) The import remains frozen, perhaps because the lebals are text in the variable A 2) I want to randomize the data (rows) separate the