Excel Link and matlab -- trouble updating data

Started by Dan Grabski in Matlab DSP17 years ago

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

Started by BALAJI RAMAN in Matlab DSP14 years ago 3 replies

Hello 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

Started by kristina_go in Matlab DSP12 years ago 2 replies

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...

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.

Started by travis_vetter in Matlab DSP15 years ago

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.

Started by BALAJI RAMAN in Matlab DSP14 years ago

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

Started by Ramesh in Matlab DSP13 years ago 1 reply

HI,     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

Started by M. Imad Khan in Matlab DSP15 years ago

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

Started by deepa n.k in Matlab DSP16 years ago 1 reply

I 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

Started by brandon_etheridge in Matlab DSP15 years ago

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???

Started by raval kunal in Matlab DSP15 years ago 1 reply

Hi 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

Started by aqou...@gmail.com in Matlab DSP8 years ago 1 reply

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...

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

Started by aami...@yahoo.co.uk in Matlab DSP12 years ago

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

Started by Asnawi in Matlab DSP7 years ago 1 reply

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...

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

Started by M. Imad Khan in Matlab DSP15 years ago 1 reply

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...

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?

Started by Heart To Heart in Matlab DSP12 years ago 5 replies

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...

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)

Started by yousufshaker in Matlab DSP10 years ago

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

Started by aami...@yahoo.co.uk in Matlab DSP12 years ago 3 replies

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....

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

Started by yarsky_1 in Matlab DSP14 years ago

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

Started by sjs22kaes in Matlab DSP14 years ago

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

Started by M. Imad Khan in Matlab DSP14 years ago

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