Web app not able to perform xlsread/xlswrite

4 views (last 30 days)
I've compiled a web application with matlab web app compiler. In my code I use both .mat files and .xlsx files which are located in the same folder. While my program is able to access .mat files without any error, xlsx files are not accessible returning the error: Excel couldn't find the specified file. However, when run in matlab environment I do not receive this error. The error appears when I try to run the app from my web server.

Answers (5)

Titus Edelhofer
Titus Edelhofer on 30 Jul 2018
Hi Giulio,
have you tried to first build up the full path to the Excel file? So instead of only the file name provide the full path?
Titus
  1 Comment
Giulio Francesca
Giulio Francesca on 1 Aug 2018
Hi Titus, thanks you for your reply. I realize that the problem could be related xlsread function which uses the 'basic' mode when adopted into a web application. Anyway, I'm not sure about that because sometimes it works, other is not

Sign in to comment.


srinu siliveru
srinu siliveru on 15 Mar 2019
hi Titus, can you please explain with a example.
thank you
  1 Comment
Titus Edelhofer
Titus Edelhofer on 15 Mar 2019
Edited: Titus Edelhofer on 15 Mar 2019
I meant something like
data = xlsread('C:\Data\myfile.xlsx');
instead of
data = xlsread('myfile.xlsx');
Titus

Sign in to comment.


srinu siliveru
srinu siliveru on 16 Mar 2019
thank you very much.
i will try

srinu siliveru
srinu siliveru on 16 Mar 2019
Thanks a lot sir
it worked.

srinu siliveru
srinu siliveru on 16 Mar 2019
Will it works if i want to use the .exe file in another sytem because path will change
can you please help me how to handle that.
thanks in advance
  2 Comments
Titus Edelhofer
Titus Edelhofer on 18 Mar 2019
Hi,
you might use the function isdeployed to distinguish:
if isdeployed
% read from folder A on system where exe runs
else
% read from folder B on your development system
end
Titus

Sign in to comment.

Categories

Find more on MATLAB Web App Server in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!