Card Index Viewer

[netto]

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.

[itsme86]

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:

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:

public override string ToString()
{
  return Name;
}

[netto]

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

[netto]

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.

[itsme86]

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

[netto]

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

[netto]

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?

[itsme86]

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.