"Philosophaie" <email@example.com> wrote in message <firstname.lastname@example.org>...
> I have got xlsread to take a range from a .xls file and assign it to an array. I now want use xlsread to take an array and write it to a .xls file. This is what I have thus far:
> for i = 1:25
> N(i, 1) = Num(i)
> N(i, 2) =Name(i)
> xlswrite('C:\path\file.xls', N(:, :), 'K2')
> The xlswrite should write starting from cell K2 with N(:, :) in C:\path\file.xls. This does not work. Could someone show me why not.
From the xlswrite doc
Specify range using the syntax 'C1:C2', where C1 and C2 are two opposing corners that define the region to write. For example, the range 'D2:H4' represents the 3-by-5 rectangular region between the two corners D2 and H4 on the worksheet. The range input is not case sensitive and uses the Excel A1 reference style. (For more information on this reference style, see Excel help.) xlswrite does not recognize named ranges.
The size defined by range should fit the size of M. If range is larger than the size of M, Excel software fills the remainder of the region with #N/A. If range is smaller than the size of M, xlswrite writes only the submatrix that fits into range to the file specified by filename.
Note If you specify only three inputs, xlswrite must decide whether the third input refers to a sheet or a range. To specify a range, include a colon character in the input string (such as 'D2:H4'). If you do not include a colon character (such as 'sales' or 'D2'), xlswrite interprets the third input as a value for sheet.
So your string 'K2' is being interpreted as the sheet number, not the cell number.
You must include the final cell as well to define the range
You can think of your watch list as threads that you have bookmarked.
You can add tags, authors, threads, and even search results to your watch list. This way you can easily keep track of topics that you're interested in. To view your watch list, click on the "My Newsreader" link.
To add items to your watch list, click the "add to watch list" link at the bottom of any page.
How do I add an item to my watch list?
To add search criteria to your watch list, search for the desired term in the search box. Click on the "Add this search to my watch list" link on the search results page.
You can also add a tag to your watch list by searching for the tag with the directive "tag:tag_name" where tag_name is the name of the tag you would like to watch.
To add an author to your watch list, go to the author's profile page and click on the "Add this author to my watch list" link at the top of the page. You can also add an author to your watch list by going to a thread that the author has posted to and clicking on the "Add this author to my watch list" link. You will be notified whenever the author makes a post.
To add a thread to your watch list, go to the thread page and click the "Add this thread to my watch list" link at the top of the page.
A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.
Anyone can tag a thread. Tags are public and visible to everyone.
About Newsgroups, Newsreaders, and MATLAB Central
What are newsgroups?
The newsgroups are a worldwide forum that is open to everyone. Newsgroups are used to discuss a huge range of topics, make announcements, and trade files.
Discussions are threaded, or grouped in a way that allows you to read a posted message and all of its replies in chronological order. This makes it easy to follow the thread of the conversation, and to see what’s already been said before you post your own reply or make a new posting.
Newsgroup content is distributed by servers hosted by various organizations on the Internet. Messages are exchanged and managed using open-standard protocols. No single entity “owns” the newsgroups.
There are thousands of newsgroups, each addressing a single topic or area of interest. The MATLAB Central Newsreader posts and displays messages in the comp.soft-sys.matlab newsgroup.
How do I read or post to the newsgroups?
You can use the integrated newsreader at the MATLAB Central website to read and post messages in this newsgroup. MATLAB Central is hosted by MathWorks.
Messages posted through the MATLAB Central Newsreader are seen by everyone using the newsgroups, regardless of how they access the newsgroups. There are several advantages to using MATLAB Central.
Your MATLAB Central account is tied to your MathWorks Account for easy access.
Use the Email Address of Your Choice
The MATLAB Central Newsreader allows you to define an alternative email address as your posting address, avoiding clutter in your primary mailbox and reducing spam.
Most newsgroup spam is filtered out by the MATLAB Central Newsreader.
Messages can be tagged with a relevant label by any signed-in user. Tags can be used as keywords to find particular files of interest, or as a way to categorize your bookmarked postings. You may choose to allow others to view your tags, and you can view or search others’ tags as well as those of the community at large. Tagging provides a way to see both the big trends and the smaller, more obscure ideas and applications.
Setting up watch lists allows you to be notified of updates made to postings selected by author, thread, or any search variable. Your watch list notifications can be sent by email (daily digest or immediate), displayed in My Newsreader, or sent via RSS feed.
Other ways to access the newsgroups
Use a newsreader through your school, employer, or internet service provider
Pay for newsgroup access from a commercial provider
Use Google Groups
Mathforum.org provides a newsreader with access to the comp.soft sys.matlab newsgroup