xls export problem

>> xls_1

xls_1 =

857_386.xls

>> xlswrite(xls_1,a) ??? Error using ==> xlswrite at 213 Invoke Error, Dispatch Exception: Source: Microsoft Office Excel Description: ???????????????????:

??????????????? ??????????? ??????????????: < > ? [ ] : ? *? ????????????? 218 ????? Help File: C:\Program Files\Microsoft Office\OFFICE11\1028\xlmain11.chm Help Context ID: 0

Answer 1

[Matt Tearle]

OK, your problem is the special characters in the string. You can't have slashes and line breaks in a filename.

When you do xlswrite('xls_1',a); the filename is the literal string 'xls_1', which is why it writes to xls_1.xls. You need the filename stored in the char variable xls_1, so:

xlswrite(xls_1,a);

However, to do that, xls_1 has to be a valid filename string. This works:

xls_1 = sprintf('%i_%i.xls',x,y)

If you're ok with underscores in places of slashes in the dates, this also works:

xls_1 = sprintf('%i_%i_%s_%s.xls',...
   x,y,regexprep(start_day,'/','_'),regexprep(end_day,'/','_'));

Answer 2

[Jan]

I do not see the problem.

a = rand(5);
xls_1 = '857_386.xls';
xlswrite(xls_1, a);

=> The file 857_386.xls is created. Did you use "xlswrite xls_1 a" without parenthesis?!

[Hello Blower]

Really thanks for all of you helping me on this.

actually, the code is to retrieve the input from user and apply them to the export xls file name.

The highlighted code is shown below, unfortunately, I found:

1) matlab will output

"xls_1 =

857_386_482/11/20109502/11/2011

46xls

>> xls_2

xls_2 =

386_482/11/20109502/11/2011

46xls

"

if my inputs are "x=857,y=386,start_day=02/11/2010,end_day='02/11/2011"

That the xls_1 is unable to be "857_386_02/11/2010_02/11_2011.xls"

2) it is even if I erase the start_day and end_day in xls_1, then xls simply equal to "857_386.xls"

xlswrite('xls_1',a); is unable to export the proper filename;

Please help.

***************************************************************

x=input('what is stock 1? [xxxx] ');

y=input('what is stock 2? [xxxx] ');

start_day=input('what is the start day? [mm/dd/yyyy] ','s');

end_day=input('what is the end day? [mm/dd/yyyy] ','s');

a=ones(3,3);

xls_1 = sprintf('%i%s%i%s%i%s%i%s\n',x,'_',y,'_',start_day,'_',end_day,'.xls');

xls_2 = sprintf('%i%s%i%s%i%s\n',y,'_',start_day,'_',end_day,'.xls');

xlswrite('xls_1',a);

xlswrite('xls_2',b);

************************************************************

[Hello Blower]

thanks a lot

Answer 3

[Hello Blower]

Help. I would like to use some variable to make a new excel filename. But xlswrite(filename, M) seems to be unable to read the filename of variable. For example, if I have set xls_1 = 857_386.xls, then run xlswrite(xls_1,a). The created xls file will be xls_1.xls instead of 857_386.xls. How can I solve it?

Thank you so much.

********************************************************** xlswrite(filename, M) writes matrix M to the Excel file filename. The filename input is a string enclosed in single quotation marks, and should include the file extension. The matrix M is an m-by-n numeric or character array. xlswrite writes the matrix data to the first worksheet in the file, starting at cell A1.

[Jan]

Please post the exact Matlab commands you have used.

Answer 4

[Matt Tearle]

Dare I ask... When you say you set xls_1 = 857_386.xls, you do mean xls_1 = '857_386.xls', right?

[Hello Blower]

yes i use the "x=input('what is stock 1? [xxxx] ');" to retrieve the x value, and try to put it in the xls file with start_day and end_day as well.

Thanks for your help

[Hello Blower]

Thanks a lot.

Answer 5

[Cagri Ozcaglar]

File name may be too long. Try to shorten the absolute path of the file by shortening folder names.

Answer 6

[Chidiebere Brendan Obiechefu]

I had same problem. What solved mine was writing the excel file to a desktop location. I don't know if it was because I was trying to save on onedrive (which is what I use normally), or that the file path is too long.