How to play a map3 file and extract it from an Excel spreadsheet. If not, how can it be done?

 if strcmpi(UserSelection,'randomly')
        Songlength = length(MusicDatabase);
        Pickrand = randi([2,Songlength], 1,1);
        fprintf("\t \n");

        fprintf(' The information on the song selected by the software is the following: \n');
        InfoSongName = MusicDatabase{Pickrand, 1};
        fprintf( ' The song name is %s. \n', InfoSongName);
        InfoSongSinger = MusicDatabase{Pickrand, 2};
        fprintf(' The song singer is %s. \n', InfoSongSinger);
        InfoSongTime = MusicDatabase{Pickrand, 3};
        fprintf(" The song time is %s. \n", InfoSongTime);
        InfoSongGenre = MusicDatabase{Pickrand, 4};
        fprintf(' The song genre is %s. \n', InfoSongGenre);
        InfoSongLanguage = MusicDatabase{Pickrand, 5};
        fprintf(" The song langauge is %s. \n",InfoSongLanguage);
        fprintf("\t \n");

        UserRandSong = input(' Select Yes if desired to play song; if not select No. ','s');
        while strcmpi(UserRandSong, 'Yes') ~=1 && strcmpi(UserRandSong, 'No') ~=1
            fprintf(' Select Yes or No NERD!!! \n');
            UserRandSong = input(' Select Yes if desired to play song; if not select No. ','s');
        end
        % My idea is the following since the variable with song equals a row in the Excel spreadsheet, 
        % column 7 of the same Excel spreadsheet is a link to the mp3 file. But I don't know how to 
        % implement it or if it works. 

[Rik]

What exactly is your question?

[Mathieu NOE]

hello

what have you done so far ?

code to share ?

[Jan]

Import the excel file, let the user pick the wanted mp3, import the mp3, let it play. Which detail are you struggling with?

[Enrico]

 if strcmpi(UserSelection,'randomly')
        Songlength = length(MusicDatabase);
        Pickrand = randi([2,Songlength], 1,1);
        fprintf("\t \n");

        fprintf(' The information on the song selected by the software is the following: \n');
        InfoSongName = MusicDatabase{Pickrand, 1};
        fprintf( ' The song name is %s. \n', InfoSongName);
        InfoSongSinger = MusicDatabase{Pickrand, 2};
        fprintf(' The song singer is %s. \n', InfoSongSinger);
        InfoSongTime = MusicDatabase{Pickrand, 3};
        fprintf(" The song time is %s. \n", InfoSongTime);
        InfoSongGenre = MusicDatabase{Pickrand, 4};
        fprintf(' The song genre is %s. \n', InfoSongGenre);
        InfoSongLanguage = MusicDatabase{Pickrand, 5};
        fprintf(" The song langauge is %s. \n",InfoSongLanguage);
        fprintf("\t \n");

        UserRandSong = input(' Select Yes if desired to play song; if not select No. ','s');
        while strcmpi(UserRandSong, 'Yes') ~=1 && strcmpi(UserRandSong, 'No') ~=1
            fprintf(' Select Yes or No NERD!!! \n');
            UserRandSong = input(' Select Yes if desired to play song; if not select No. ','s');
        end
        % My idea is the following since the variable with song equals a row in the Excel 
        % spreadsheet, column 7 of the same Excel spreadsheet is a link to the mp3 file. 
        % But I don't know how to implement it or if it works. 
%How to play a map3 file and extract it from an Excel spreadsheet. If not, how can it be done?

[Jan]

The question is still not clear. Which is "the variable with song"? How can a variable equal a row in an Excel spreadsheet? How is the "link" stored in Excel?

Is "MusicDatadase" the imported Excel file already? Then all details concerning Excel do not matter.

Do you really mean "map3" or "mp3"? Is the data of the MP3 included in the Excel file or stored on the disk? Does the column 7 contain the file name of the MP3 files? Then audioread reads the file and audioplayer will play it.

[Enrico]

The song is stored in the variable Pickrand. Yes, "MusicDatabse" is the imported Excel file. I mean MP3 (apologies for my spelling). Column 7 of the excel file "MusicDatabase" has the link of the MP3 files.

[Enrico]

[VariableSong, Variable] = audioread(MusicDatabase{SongPlay, 6});
Song = audioplayer(VariableSong, Variable);
PlaySong = input(' Will you like to play the song Yes or No ','s');
if strcmpi(PlaySong ,'Yes')
    soundsc(VariableSong, Variable);
end
% This is was I thinking but it does not work, in the columns 6 are the
% links of the songs.