How to convert an excel file (.csv) to a .wav format/any other audio format file?

66 次查看（过去 30 天）
Giggs B.
Giggs B. 2022-3-11
评论： Giggs B. 2022-3-14
Hi,
I have an excel file which has ~200k data samples stored in one column and I want to convert the data from that file into an audio file. But whenever I use the excel file, there is almost no sound. I want to play it at 40khz frequency.
I am just using this code:
clearvars
a=xlsread('w3.csv'); %read the xls table
figure,plot(a) %this is your signal
xlim([0 200704])
sound(a,40000) %play the signal
audiowrite('w3.wav',a,40000,'BitsPerSample',16);
Can someone help? Thanks.

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

采纳的回答

Scott MacKenzie
Scott MacKenzie 2022-3-11
编辑：Scott MacKenzie 2022-3-11
I was able to play your audio data and save it as a .wav file. It's some sort of noise along with a dripping sound. But, I had to first rescale the data to fall between -1 and 1:
clearvars
a = xlsread('temp.csv'); % this is your w3.csv file
a = rescale(a, -1, 1);
figure,plot(a) %this is your signal
xlim([0 200704])
sound(a,40000) %play the signal
audiowrite('w3.wav',a,40000,'BitsPerSample',16);
  1 个评论
Giggs B.
Giggs B. 2022-3-12
Hi,
Yes! Thanks, it the sound of waterflow from a pipe. However, I wanted to know the logic behind that why would I need to convert it to -1 to +1. I also checked other ranges such as 0 to 1 or -5 to +5 or -10 to 10 and they all gave expected results.

请先登录，再进行评论。

更多回答（1 个）

Peter Perkins
Peter Perkins 2022-3-14
This
should give a hint that xlsread is not the right way to go. In this case, you want to use readmatrix:
a = readmatrix("w3.csv")
  5 个评论
显示 3更早的评论
Scott MacKenzie
Scott MacKenzie 2022-3-14
@Giggs B. Hmm, well I'm not sure then. In the code in my answer, if I change xlsread to readmatrix, it works fine.
This sounds like a fairly simple debugging problem. So, for you, it works with xlsread, but it doesn't work with readmatrix. So, try to use both:
n1 = xlsread('3.csv');
n2 = readmatrix('3.csv');
and have a look in n1 and n2 and see what the difference is. That's a good starting point.
Giggs B.
Giggs B. 2022-3-14
Oh I see, yes then that looks some problem on my end. I will try to figure it out, starting from where you suggested. Thanks!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by