Export2Excel
Screenshots
What is it?
This Yahoo! Music Engine DLL plugin installs a new item in the service drawer called
“Export to Excel”. This new page has a button, which if clicked will
dump the contents of your media database to an Excel worksheet and then
autoformat it.
It may take a couple of minutes for Excel to import all of the data,
depending on how many items you have in your media database. During the
import, the A2 cell will display a “please wait…” message and when the
import is done, the message will change to say “DONE”.
Use cases
The main use for this is so that you can print out your list of songs
and share it with friends to see what you have in common. Folks who are
comfortable with VBScript could also use that to perform tasks on their
data (e.g.: do stats, graphing, etc.), which may be a win for people who
are skilled with VBScript and don’t want to learn to program the YME API.
Requirements
- Microsoft Excel (I tested with Excel 2003)
- .NET 2.0 Runtime
Download
- Latest version: YMEExcelPlugin-1.0.1-setup.exe
- YMEExcelPlugin-0.0.1-setup.exe
Release notes
1.0.1
- Fixed swapped column headings and rearranged columns.
- Added ability to dump the contents of a single playlist. GUI rearranged a bit.
- Fixed issue in installer that caused uninstall from Control Panel | Add and Remove Programs to not work.
- Assembly is now signed with a strong name, preventing (very briefly visible) warning from
regasm /codebaseduring install. - Rebuilt using Interop DLLs from Yahoo! Music Jukebox 2.0.1.037, .NET Framework 2.0.50727, Microsoft Visual C# 2005 Express Edition 8.0.50727.42, and NSIS 2.21
- Checked source code into Subversion at http://svn.marc.abramowitz.info/projects/yahoo_music_engine/YMEExcelPlugin/
0.0.1
- Initial version.
Development notes
This plugin was created with Microsoft Visual C# 2005 Express Edition Beta and the Nullsoft Scriptable Install System (NSIS).
The source code is under Subversion at http://svn.marc.abramowitz.info/projects/yahoo_music_engine/YMEExcelPlugin/.
Want more plugins?
Check out http://plugins.yme.music.yahoo.com/
Want to write your own plugin?
Check out http://plugins.yme.music.yahoo.com/plugins/docs/
This site hosted by
Donate
If you like this plugin and want to see more like it in the future (suggestions?), I invite you to check out my sponsors, such as DreamHost and the Yahoo! Publisher Network ads in my sidebar. Or if you prefer, donate with PayPal whatever you think it’s worth to you.
Ian linked to me on the YME plugins site.
This plugin is also on the Yahoo! Gallery site.
RSS 2.0 feed
Very helpful plug in. Thanks! I did noticed for some reason on my system (excel 2003 sp2) the headers only for “Track Name” and “Artist” where switched. Easy typing fix.
Cool. Glad to see someone getting good use out of it.
I must’ve mislabeled the columns in my code. I can fix that in the next release. Thanks for reporting it!
Very nice. Any hopes of seeing an enhancement to extract by playlist? The ability to extract/export a playlist to a wpl or m3u playlist file would also be great.
Probably not anytime soon. I am very busy lately with work and don’t have a lot of time to devote to my freeware projects, particularly as I’m spending most of my time on a Mac these days so I’d have to do my development inside of Virtual PC (slow).
Sorry.
Sources are available if somebody wants to muck around with it.
I would be interested in looking at the source code for Export2Excel and possibly adding the m3u export functionality. Could you send me the source or direct me to a download source?
Very nice. Was just about to code the exact same thing myself. Thanks for saving me the time!
Very nice. Was just about to code the exact same thing myself. Thanks for saving me the time! (Check your PayPal account.)
Nice Plugin. There seems to be a limit to 65,536 rows per sheet in excel. It gives a error once it reaches that many rows.
My full length music has been cut to 30 seconds…I pay my account when due. I am having problems tring to download new songs…Chuck kerr, Pleas fix this for me…
Any possibility of adding the track number to the downloaded excel spreadsheet??
I downloaded it and it says “.net runtime library 2.0 is required. You have 1.1.4322″. What do I do to fix this?
Where is version 2.0?????
I got an error from NetFramework:
System.InvalidCastException: Unable to cast COM object of type ‘Excel.ApplicationClass’ to interface type ‘Excel.Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Library not registered. (Exception from HRESULT: 0×8002801D (TYPEELIBNOTREGISTERED)).
at Excel.ApplicationClass.setVisible(Boolean RHS)
at YMEExcelPlugin.YMEExcelPlugin.getExcelWorksheet()
at YMEExcelPlugin.YMEExcelPlugin.button1_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Any Ideas?
Marc,
Thanks for the plug-in. I was scratching my head on what the “service bar” was, as the Yahoo page doesn’t have the good screen shots, and I came across your own page. I had to shut down and re-start YMU to have the plug-in display. A 2 line readme.txt file would be helpful.
How difficult would it be to add a column that shows your song ratings (0 to 4 stars)? That’s actually why I downloaded the plug-in, hoping it would show that.