DSPRelated.com

Excel Link and matlab -- trouble updating data

Started by Dan Grabski in Matlab DSP25 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


Normalised Sampling

Started by kristina_go in Matlab DSP20 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 DSP24 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 Import Data from Excel to matlab

Started by BALAJI RAMAN in Matlab DSP22 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


How to access a particular row and column of a excel file.

Started by BALAJI RAMAN in Matlab DSP22 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 DSP22 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 to matlab

Started by aami...@yahoo.co.uk in Matlab DSP20 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 DSP16 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


Re: Mat to Excel

Started by aqou...@gmail.com in Matlab DSP16 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

Started by M. Imad Khan in Matlab DSP23 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


filtering data

Started by brandon_etheridge in Matlab DSP24 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 DSP24 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


converting matlabdates to excel dates

Started by deepa n.k in Matlab DSP24 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


How to plot figure [1 Attachment]

Started by Yalcin Ata in Matlab DSP16 years ago

Hi; I have some data (given in Table) and have Excel plot as given in Figure. I want to plot in Matlab same figure. How can i do it?...

Hi; I have some data (given in Table) and have Excel plot as given in Figure. I want to plot in Matlab same figure. How can i do it? Thanks in advance... ?s (m) Case 1 : 3000 m Case 2 : 3000 m Case 1 : 5000 m Case 2 : 5000 m 0,002 3,055665065 0,335881543 5,499844201 0,618447208 0,005 14,04617123 1,717303912 23,21267163 3,131262193 1000000 44,60678752 7,928307515 60,05460392 13,


why loop element numbers are different?

Started by in Matlab DSP16 years ago

Hi; I couldn't find where the error is. Loop element numbers are more than it must be. For example when; handles.UppWaveLen =...

Hi; I couldn't find where the error is. Loop element numbers are more than it must be. For example when; handles.UppWaveLen = 1.53 handles.LowWaveLen = 1.57 loop must be between 6369:6536 and there must be 168 elements of the for loop. But it writes in excel file 418 elements. Could anyone help me to find the error. Thanks in advance. k=1; for i=floor(10000/handles.UppWaveLen):1:c...


Build EX problem

Started by Serhat Guven in Matlab DSP16 years ago

Hi everyone, I'm trying to export a function that I've written in Matlab and I want to use this function in Excel. I'm using Matlab 2009b and...

Hi everyone, I'm trying to export a function that I've written in Matlab and I want to use this function in Excel. I'm using Matlab 2009b and Visual Studio 2008 Express Edition as the compiler on Windows 7. The problem is when I try to build my project I get the following error: "Error: An error occurred while shelling out to build (error code: 2)" Although Matlab 2009b is compatible with...


Please help on image analysis [1 Attachment]

Started by ravi shastri in Matlab DSP16 years ago

Hai every one , this sis Ravi shastri iam doing my m.Tech project on image analysis to determine the particle size, i facing some errors in my...

Hai every one , this sis Ravi shastri iam doing my m.Tech project on image analysis to determine the particle size, i facing some errors in my code.here i want to do the calculations using matlab and that resut should be enter in Excel sheet. please any on help me regrading. if some one helps me iam very greatful to them . the code is clear all; clc; close all; str_path = ''; str...


Non-string values in xlsread/xlsinfo

Started by szacharski in Matlab DSP17 years ago

Hello I am working with an excel file with data on multiple sheets where I may not know the sheet name I'm trying to automate my...

Hello I am working with an excel file with data on multiple sheets where I may not know the sheet name I'm trying to automate my calculations by reading the xls file and saving the sheet names into a matrix (see example below) [txt0,descr] = xlsfinfo('C:\inputs.xls') m=size(descr,2) for(i=0:1:m) txt = xlsread('C:\inputs.xls', descr(1,i))) I want to "automate" the xlsread function by...


Import xls data (Strings & Numerics)

Started by yousufshaker in Matlab DSP19 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


How to popukate data in M-files

Started by Moniba Shams in Matlab DSP19 years ago

Dear all, I am using MATLAB for doing neuron analysis, where I have neuron morphology data in MySQL, neuron electrophysiology data...

Dear all, I am using MATLAB for doing neuron analysis, where I have neuron morphology data in MySQL, neuron electrophysiology data in excel sheet, and DNA microarray data. I have MATLAB scripts that I have to populate with such types of data, but I am facing problem in populating the scripts with data. Kindly any body having expertise in this field helps me if possible. Thanks ...