MATLAB Central Newsreader - Using Compiled XLS File

Using Compiled XLS File

Brian — Mon, 27 Oct 2008 02:06:02 -0400

I have a MS Excel file that serves as a template for data reporting.

In my m-file, I create a new Excel file by copying the template with the COPYFILE command. The name of the new file varies by input. Following analysis, fields of the new file are populated with results. The process repeats several times.

Everything works beautifully from the command window within MATLAB.

When I compile my code to create a stand-alone application, I always include the template source file along with the m-file and it compiles without error. However, upon executing the stand-alone application, I receive an error at the COPYFILE command: it can not find the source file.

Please let me know if you have any suggestions to resolving this issue.

Re: Using Compiled XLS File

Ashish Uthama — Mon, 27 Oct 2008 13:07:19 -0400

How are you specifying the template file path to the COPYFILE function?

I believe you should just addresss it by name since all included files in
the projec will be on the MATLAB path.

On Sun, 26 Oct 2008 22:06:02 -0400, Brian <ceo21mil@hotmail.com> wrote:

> I have a MS Excel file that serves as a template for data reporting.
>
> In my m-file, I create a new Excel file by copying the template with the
> COPYFILE command. The name of the new file varies by input. Following
> analysis, fields of the new file are populated with results. The
> process repeats several times.
>
> Everything works beautifully from the command window within MATLAB.
>
> When I compile my code to create a stand-alone application, I always
> include the template source file along with the m-file and it compiles
> without error. However, upon executing the stand-alone application, I
> receive an error at the COPYFILE command: it can not find the source
> file.
>
> Please let me know if you have any suggestions to resolving this issue.

Re: Using Compiled XLS File

Peter Webb — Mon, 27 Oct 2008 14:25:49 -0400

If you can post the exact text of the error message, and the command that
generated it, we can probably offer more precise diagnostics.

"Brian " <ceo21mil@hotmail.com> wrote in message
news:ge37ma$7rk$1@fred.mathworks.com...
>I have a MS Excel file that serves as a template for data reporting.
>
> In my m-file, I create a new Excel file by copying the template with the
> COPYFILE command. The name of the new file varies by input. Following
> analysis, fields of the new file are populated with results. The process
> repeats several times.
>
> Everything works beautifully from the command window within MATLAB.
>
> When I compile my code to create a stand-alone application, I always
> include the template source file along with the m-file and it compiles
> without error. However, upon executing the stand-alone application, I
> receive an error at the COPYFILE command: it can not find the source file.
>
> Please let me know if you have any suggestions to resolving this issue.

Re: Using Compiled XLS File

Brian — Mon, 27 Oct 2008 16:30:03 -0400

Thank you for the responses.

Below is the relevant portion of my code:

% Excel Summary File
directoryName = ['Lot ', lotSummary.LotID, '\'];
mkdir(directoryName);
fileName = ['Lot ', lotSummary.LotID, ' Summary.xls'];
copyfile('WTASummary.xls', [directoryName, fileName]);
cd(directoryName);

And the error message from the compiled stand alone application:

??? Error using ==> copyfile
No matching files were found.

MATLAB:COPYFILE:FileDoesNotExist

Best regards,
Brian

Re: Using Compiled XLS File

Ashish Uthama — Mon, 27 Oct 2008 18:27:48 -0400

How do you include WTASummary.xls? The recommended approach is to place it
under 'Other files' in DEPLOYTOOL.

File under this section will be extracted to the CTF root directory, under
a subdirectory which has the same name as the project.
You should then use the CTFROOT function to build up the path to this
excel file. Something along the lines of:

copyfile(fullfile(ctfroot,'yourProjectName','WTASummary.xls'),
[directoryName, fileName]);

Also:
> directoryName = ['Lot ', lotSummary.LotID, '\'];
> mkdir(directoryName);
Note: this creates the dir in the 'current working directory'. This might
not be what you expect on a deployed application, ensure you CD to a
specific directory first or use absolute path names.

On Mon, 27 Oct 2008 12:30:03 -0400, Brian <ceo21mil@hotmail.com> wrote:

> Thank you for the responses.
>
> Below is the relevant portion of my code:
>
> % Excel Summary File
> directoryName = ['Lot ', lotSummary.LotID, '\'];
> mkdir(directoryName);
> fileName = ['Lot ', lotSummary.LotID, ' Summary.xls'];
> copyfile('WTASummary.xls', [directoryName, fileName]);
> cd(directoryName);
>
> And the error message from the compiled stand alone application:
>
> ??? Error using ==> copyfile
> No matching files were found.
>
> MATLAB:COPYFILE:FileDoesNotExist
>
> Best regards,
> Brian

Re: Using Compiled XLS File

Brian — Mon, 27 Oct 2008 19:32:01 -0400

Thank you Ashish.

Your suggestion to use
> copyfile(fullfile(ctfroot,'yourProjectName','WTASummary.xls'),
> [directoryName, fileName]);
solved the problem.

In my program I also access another "Other file" - specifically a perl script - but without using ctfroot. It is interesting that it is necessary in one case but not the other.

Again, thank you for your help.

Best regards,
Brian