Well that's wonderful!!!

So post the code so we'll all know how!!



>Gentleman,
>I think both of your solutions create a dependency for Excel to be installed on the machine. I've read data in from Excel using an OleDbConnection with good success, and no dependencies required.
>
>>Here's what I've used before:
>>
>>

>>using System;
>>using System.Data;
>>using System.Net.Mime;
>>using Microsoft.Office.Interop.Excel;
>>using System.Text;
>>using System.Reflection;
>>
>>namespace ConsoleApplication3
>>{
>>    public class ExcelWrapper
>>    {
>>        public DataSet GetExcel(string fileName)
>>        {
>>            //
>>            //  Include a reference to Microsoft.Office.Interop.Excel
>>            //  ExcelWrapper wrap = new ExcelWrapper();
>>            //  DataSet ds = wrap.GetExcel(@"c:\development\rda.xls");
>>            //
>>            //  I just ran this against an old spreadsheet an it worked fine.
>>            //
>>
>>            Application oXL;
>>            Workbook oWB;
>>            Worksheet oSheet;
>>            Range oRng;
>>            try
>>            {
>>                //  creat a Application object
>>                oXL = new ApplicationClass();
>>                //   get   WorkBook  object
>>                oWB = oXL.Workbooks.Open(fileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
>>                        Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
>>                        Missing.Value, Missing.Value);
>>
>>                //   get   WorkSheet object 
>>                oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Sheets[1];
>>                System.Data.DataTable dt = new System.Data.DataTable("dtExcel");
>>                DataSet ds = new DataSet();
>>                ds.Tables.Add(dt);
>>                DataRow dr;
>>
>>                StringBuilder sb = new StringBuilder();
>>                int jValue = oSheet.UsedRange.Cells.Columns.Count;
>>                int iValue = oSheet.UsedRange.Cells.Rows.Count;
>>                //  get data columns
>>                for (int j = 1; j <= jValue; j++)
>>                {
>>                    dt.Columns.Add("column" + j, System.Type.GetType("System.String"));
>>                }
>>
>>                //string colString = sb.ToString().Trim();
>>                //string[] colArray = colString.Split(':');
>>
>>                //  get data in cell
>>                for (int i = 1; i <= iValue; i++)
>>                {
>>                    dr = ds.Tables["dtExcel"].NewRow();
>>                    for (int j = 1; j <= jValue; j++)
>>                    {
>>                        oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i, j];
>>                        string strValue = oRng.Text.ToString();
>>                        dr["column" + j] = strValue;
>>                    }
>>                    ds.Tables["dtExcel"].Rows.Add(dr);
>>                }
>>                return ds;
>>            }
>>            catch (Exception ex)
>>            {
>>                throw;
>>            }
>>        }
>>    }
>>}
>>