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

4 次查看（过去 30 天）

Enrico 2023-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1928960-how-to-play-a-map3-file-and-extract-it-from-an-excel-spreadsheet-if-not-how-can-it-be-done

编辑： Enrico 2023-3-17

 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. 

7 个评论
显示 5更早的评论隐藏 5更早的评论

Enrico 2023-3-16

在 MATLAB Online 中打开

 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?

Enrico 2023-3-17

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 2023-3-17

编辑：Enrico 2023-3-17

在 MATLAB Online 中打开

[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. 