tag:blogger.com,1999:blog-1246485265659910037.post7505476288452444324..comments2024-03-23T00:46:42.600-07:00Comments on MATLAB ... and more ...: xlswrite: output data to excel file {MATLAB functions}cguitarhttp://www.blogger.com/profile/01032181616134167318noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-1246485265659910037.post-86386212965595608342012-10-02T09:56:40.612-07:002012-10-02T09:56:40.612-07:00give more descriptive answers with examplesgive more descriptive answers with examplesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-71582257186065571712012-09-05T19:59:25.182-07:002012-09-05T19:59:25.182-07:00how can i adjust the column width of the cells i w...how can i adjust the column width of the cells i write into using xlswrite?<br />billnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-6567436441991360412012-07-21T23:30:56.057-07:002012-07-21T23:30:56.057-07:00i got it... first do x=x'; and y =y'; so a...i got it... first do x=x'; and y =y'; so as to make x and y column vectors. then create a matrix z= [x y]; and then the command becomes<br /><br />xlswrite('xyz.xls',z,Sheet1,'F5'); that takes care of both the vectors otherwise u have to type out the command twice for each of them (x & y).hmmnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-24382937154030885032012-07-21T03:05:56.605-07:002012-07-21T03:05:56.605-07:00lets say i want to add 2 vectors....one x and othe...lets say i want to add 2 vectors....one x and other say y=sin(x) where both x and y are vectors..in to the same excel sheet so that i can create plots of the y vs x kind...so what would i have to change in the command that you have given?hmmnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-86145424587324774422012-05-11T13:03:34.603-07:002012-05-11T13:03:34.603-07:00*** I am new with ***C/C++ programming*** I am new with ***C/C++ programmingSpardethnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-89668548248524806122012-05-11T13:00:39.952-07:002012-05-11T13:00:39.952-07:00Hello, I am dealing with large quantity of data wi...Hello, I am dealing with large quantity of data with the number of rows exceeding Excel's 65526 row limit. I need to export the data into an Excel spreadsheet. <br /><br />I want to write a Matlab code which would break down my data into 65526 rows and save them each as a different variable and then save each variable in a new sheet. <br /><br />But I am stuck at defining the row range! Could I set my row range as a variable such as this??<br /><br />---------------------------------------------<br /><br />matlab_row=size(t0,1);<br />excel_row=65526;<br /><br />diff=matlab_row - excel_row;<br />size1=matlab_row-65000;<br /><br />page1=t0(1:size1,:);<br /><br />if diff<0<br />data1=XLSWRITE('C:\data1.xls',page1,'Sheet1');<br /><br />------------------<br /><br />I am new with VBA programming, all help is appreciated. <br /><br />ThanksSpardethnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-34392093462584927892012-02-16T06:29:59.561-08:002012-02-16T06:29:59.561-08:00I think you use the for loop to repeatedly write/s...I think you use the for loop to repeatedly write/save/export xlsx files. However, you need to pay a little more attention to the file name. <br />The (i.xlsx) won't work since i is an integer, not a string.cguitarhttps://www.blogger.com/profile/01032181616134167318noreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-33816601119246515652012-02-15T18:21:07.835-08:002012-02-15T18:21:07.835-08:00hey do u know how to create a for loop and export ...hey do u know how to create a for loop and export to different filenames each time the for loop is repeated?<br /><br />is the following goin to work?<br /><br />for i =1<br /> xlswrite(i.xlsx)<br />endMatLab Noobnoreply@blogger.comtag:blogger.com,1999:blog-1246485265659910037.post-72302588652833028242012-02-14T05:52:41.649-08:002012-02-14T05:52:41.649-08:00Thanks for your comment, Anonymous!Thanks for your comment, Anonymous!cguitarhttps://www.blogger.com/profile/01032181616134167318noreply@blogger.com