Re: copyfile function - .txt to .xls - xlsread

On Jan 30, 4:20 pm, rober...@xxxxxxxxxxxxxxxxxx (Walter Roberson)
wrote:
In article <60c9cb3b-5af5-4bfe-bede-5d8601bc4...@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,

 <beginner1....@xxxxxxxxxxx> wrote:
I used the copyfile function to change my .txt file to a .xls file.
Then I tried using xlsread and I got an error.  Is there something
else I need to do?

What was the error message?
If you list your directory contents, do you see the .xls file?
If you are in Windows and you are set to hide file extensions,
get the file properties to verify that there isn't some hidden
extension.

--
   "I was very young in those days, but I was also rather dim."
   -- Christopher Priest

The error message is:

??? Error using ==> xlsread
File C:\Documents and Settings\file1.xls not in Microsoft Excel
Format.

The file extension (.xls) is there. If I open it in excel, and saveas
a .xls file, xlsread works fine. Is there something I need to do
during the copyfile function?
.

Relevant Pages

  • Re: copyfile function - .txt to .xls - xlsread
    ... Then I tried using xlsread and I got an error. ... What was the error message? ... If you are in Windows and you are set to hide file extensions, ... -- Christopher Priest ...
    (comp.soft-sys.matlab)
  • Re: Using the xlsread command on a mac
    ... Is 'data1' the actual name of the sheet in 'Data.xls' file where the data is stored? ... xlsread by default reads data from sheet1; the message that you get is caused because some misspecifiation with the sheet names. ... What is the error message that u r getting? ...
    (comp.soft-sys.matlab)
  • Re: opening many files in one time
    ... I made the changes in the code but I still receive the same error message: ... Range argument must a string. ... See HELP XLSREAD. ...
    (comp.soft-sys.matlab)
  • Re: Using the xlsread command on a mac
    ... When I try to run this script: ... Error using ==> xlsread at 234 ... Specified worksheet was not found. ... What is the error message that u r getting? ...
    (comp.soft-sys.matlab)
  • Re: Export to Excel 2007
    ... yes Excel 2007 'protects' users from opening files that do not have the ... format that their file extensions suggest. ... | Yeah sorry Jim I forgot to give the Error Message. ... | On hitting yes everything goes smoothly and opens correctly but the above ...
    (microsoft.public.excel.programming)
Loading