xlswrite using different names

Question

Raúl 2013-2-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/65056-xlswrite-using-different-names

Hi all,

I'm trying to create a loop where some data is read in one file and writes it in the copy of a template. The output excel file, should be one generic part plus the name of the source file. I don't know why, but i'm getting some kind of error..

 %Open multiple files from a folder
 myFolder = 'C:\Users';
if ~isdir(myFolder)
  errorMessage = sprintf('Error: The following folder does not exist:\n%s', myFolder);
  uiwait(warndlg(errorMessage));
  return;
end
filePattern = fullfile(myFolder, '*.xls');
xlsFiles = dir(filePattern);
 for k = 1:length(xlsFiles)
  baseFileName = xlsFiles(k).name;  
  fullFileName = fullfile(myFolder, baseFileName);
   drawnow; % Force display to updaclc
 [~,~,RAW] = xlsread(fullFileName,1,'N2:N300'); % EPC
  [~,~,RAW2] = xlsread(fullFileName,1,'O2:O300');  % RSSI MEAN
  [~,~,RAW3] = xlsread(fullFileName,1,'U2:U300');  % READ COUNT
copyfile('C:\Users\U95511\Dropbox\UPF\Matlab\RV\DP\INVENTARIOPISTOLA_template.xls','C:\Users\U95511\Dropbox\UPF\Matlab\RV\DP\INVENTARIOPISTOLA_.xls')
new=1234;
 xlswrite(sprintf('C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_%s.xls',new),RAW,2,'A5');
xlswrite(sprintf('C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_%s.xls',new),3,2,'B5:B300');
xlswrite(sprintf('C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_%s.xls',new),RAW2,2,'F5');
xlswrite(sprintf('C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_%s.xls',new),RAW3,2,'G5');
 end

The error is that one.

 Warning: Escape sequence 'U' is not valid. See 'help sprintf' for valid escape sequences. 
> In DPtoInventoryV3 at 47 
Error using xlswrite (line 220)
Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: Error en el método SaveAs de la clase Workbook.
Help File: C:\Program Files (x86)\Microsoft Office\Office12\3082\XLMAIN11.CHM
Help Context ID: 0
 Error in DPtoInventoryV3 (line 47)
   xlswrite(sprintf('C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_%s.xls',new),RAW,2,'A5');

Could please somebody help me?

Thanks a lot.

BR,

Raúl.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2013-2-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/65056-xlswrite-using-different-names#answer_76611

在 MATLAB Online 中打开

xlswrite(sprintf('%s.xls', 'C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_',new),RAW,2,'A5');

or

xlswrite(['C:\Users\U95511\Dropbox\UPF\Matlab\RV\INVENTARIOPISTOLA_' new '.xls'], RAW, 2, 'A5')

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2013-2-27

在 MATLAB Online 中打开

newfilename = sprintf('%s%04d.xls', 'C:\Users\U95511\Dropbox\UPF\Matlab\RV\DP\INVENTARIOPISTOLA_', new);
copyfile('C:\Users\U95511\Dropbox\UPF\Matlab\RV\DP\INVENTARIOPISTOLA_template.xls', newfilename);
xlswrite(newfilename, RAW, 2, 'A5');