Card Index Viewer

I have around 6k MTG cards indexed in excel07, with the name and quantity from specific sets. I've been wondering if I could create a windows app with C# that would simply list the card names off the excel file in a scroll box, and when clicked on it would load the image off gatherer.wizards.com, and list the quantity below the image.
I just don't know how to go about this, I can make the window, but I need an idea on how I should code it.

What does the Excel data look like? It's relatively easy to read data in from Excel.

As far as the rest is concerned, I would create a Card struct or class that has properties like Name, Quantity, URL (if necessary), etc.

Then the pseuo-ish code would look like:

Code:

foreach(Row row in excelWorkSheet.Rows)
{
  Card card = new Card();
  card.Name = row[0];
  card.Quantity = row[1];
  listBoxCards.Items.Add(card);
}

Then just make sure you override ToString() in your Card struct or class so it's displayed correctly in the ListBox. Something like:

Code:

public override string ToString()
{
  return Name;
}

Thanks for your input! I'll try to start with this on the upcoming weekend.

Are there any tutorials on reading a .xlsx file into C#?
I found some ways through google but they're not working for me.
edit : I found excel object library 12.0.

I'm interested in seeing the data in Excel. Any way you can post a snippet of a dozen or so rows?

Originally Posted by itsme86

I'm interested in seeing the data in Excel. Any way you can post a snippet of a dozen or so rows?

http://img405.imageshack.us/img405/4641/mtgindex.png

Code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using XL = Microsoft.Office.Interop.Excel;

namespace MTG_INDEX_VIEWER
{
    public partial class Main : Form
    {
        public Main()
        {
            InitializeComponent();
        }

        private void Main_Load(object sender, EventArgs e)
        {

        }

        private void readxls_Click(object sender, EventArgs e)
        {
            XL.Application xlApp;
            XL.Workbook xlWorkBook;
            XL.Worksheet xlWorkSheet;
            XL.Range range;

            string str;
            int rCnt = 0;
            int cCnt = 0;

            xlApp = new XL.ApplicationClass();
            xlWorkBook = xlApp.Workbooks.Open("MTGindex.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (XL.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            range = xlWorkSheet.UsedRange;

            for (rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
            {
                for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
                {
                    str = (string)(range.Cells[rCnt, cCnt] as XL.Range).Value2;
                    MessageBox.Show(str);
                }
            }

            xlWorkBook.Close(true, null, null);
            xlApp.Quit();

            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);
        }
        private void releaseObject(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception ex)
            {
                obj = null;
                MessageBox.Show("Unable to release the Object " + ex.ToString());
            }
            finally
            {
                GC.Collect();
            }
        } 
    }
}

It says MTGindex.xlsx not found, but its in the project folder?

Make sure it's in the same folder as the executable (e.g. MTGApp\bin\Release\MTGindex.xlsx)

If you can't get the Excel thing to work, you can always save the file as a .csv instead. Then it's as easy to read as any other text file.