[RESOLVED] Searching Excel Document For String

[Jumpercables]

I am trying to use C# and VS2005 to find a string in the document then using that range I will start population on the next cell.

I have the most of everything working, I can open the correct excel document and go the correct sheet, but when I try to execute the find method it always fails.

public void ExportMeasurements()
        {
            // A new application needs to be created.
            Excel.Application excelApp = new Excel.ApplicationClass();
             
            // See if the file exists and has correct extension
            if (!File.Exists(this.cExcelFile))
            {
                excelApp.Quit();
                excelApp = null;
                throw new FileNotFoundException("{0} does not exist.", this.cExcelFile);
            }
 
            if (excelApp == null)
            {
                throw new Exception("Error! Excel Failed to Initailize");
            }
 
            // Open an existing document into a Workbook object:
 
                Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(this.cExcelFile,
                    Excel.XlUpdateLinks.xlUpdateLinksUserSetting, false, 5, "", "", false, Excel.XlPlatform.xlWindows,
                    "", true, false, 0, true, false, false);
     
 
            // Count the sheets in collection.
            if (cSheets.Count == 0 || cSheets == null)
            {
                throw new NotSupportedException("No Sheet Specified.");
            }
 
            // Get all of the sheets in the workbook opened.
            Excel.Sheets excelSheets = excelWorkbook.Worksheets;
 
            // Now that you have the collection of Worksheets, you must get an individual sheet edit data within.
            Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(cSheets[0].ToString());
 
            ICollection IMasterKeys = cMasterDrill.GetKeys();
            ICollection ISlaveKeys = cSlaveDrill.GetKeys();
            
            // Make sure that the key counts match for both drils.
            if (ISlaveKeys.Count != IMasterKeys.Count)
            {
                excelApp.Quit();
                excelApp = null;
                throw new ArgumentOutOfRangeException("IMasterKeys (" + IMasterKeys.Count + ") != (" 
                    + ISlaveKeys.Count + ") IBaseKeys.");
            }
 
            foreach (object itMaster in IMasterKeys)
            {   
                // Load well stats into arraylist.
                ArrayList masterList = GetMeasurements(itMaster.ToString());
                
                foreach (object itSlave in ISlaveKeys)
                {
                    // Load well stats into arraylist.
                    ArrayList slaveList = GetMeasurements(itSlave.ToString());
                    [b]//ERRORS HERE
                    //Finding the cell containing the specified string
                    try
                    { 
                        Excel.Range rng = excelWorksheet.Cells.Find("LA 10004", null, null,
                            Excel.XlLookAt.xlWhole, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext,
                            null, null, null);
                    }
                    catch (Exception e)
                    {
                       
                    }[/b]
                    
                     
                }
            }
 
            // Close out of excel.
            excelWorkbook = null;
            excelWorksheet = null;
            excelSheets = null;
 
            excelApp.Quit();
            excelApp = null;
        }
    }

I always throw this exception "Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))"

I know the string is in the file. Any ideas?

[vbcode1980]

Hmm, I did some searching on the function but can't find anything wrong.
Are you sure the arguments you made Null are optional?

[Jumpercables]

I got it working I had to yse Type.Missing instead of null.