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
Normalised Sampling
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.
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
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.
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
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
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
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
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
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
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???
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
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]
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?
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
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]
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
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)
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
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 ...






