Anmelden:     


Forum: General Discussion

Topic: export data to excell

Dieses Thema ist veraltet und kann veraltete oder falsche Informationen enthalten.

hi is there are away to export file name,artist and bpm information of a certain folder to exell.I would like to do it with my wave files.
I tried to open my database file in exell but the bpm information goives weird numbers but all else is correct.

Tks
 

geposted Sat 17 Nov 07 @ 7:50 pm
44100 / bpm * 60

If you drag the xml file into excel, bpm should be in column S. Click the heading for column S and insert a new column (shifting bpm to T). Then use this formula in cell S1

=ROUND(44100/Table1[[#This Row],[Bpm]]*60,2)


Use excels filter functions to wort by wav and directory via the filepath column B.
 

when i open the database with excell it is not in column s.
There are many comuns that say bpm.i don't know wich one is correct
 

ok if found it in the s column like you said but i don't understand how to do the rst

please explain

tks
 



(Alte Themen und Foren werden automatisch geschlossen)