troubleshooting Question

Excel could not be found - missing assembly reference?

Avatar of Rama Tito
Rama TitoFlag for Malaysia asked on
3 Comments1 Solution366 ViewsLast Modified:
Hi, I did get this error in my error list while compiling the project. Previously the project are done with MS Office Excel 2003, and currenlty i am using Excel 2007. In my system i don't have MS office 2003. In my project, my references i did add Excel and Microsoft.Office.Core.

The error is ->
The type or namespace name 'Excel' could not be found (are you missing a using directive or an assembly reference?)      

private int findColumnDept(Excel.Worksheet Ws)

Error was underline in "Excel"

private int findColumnDept(Excel.Worksheet Ws)
			int no=1;
			string CellValue="";
			int retryCount=0;
			bool EmptyCellAllowed=true;
				Excel.Range range1 = Ws.get_Range( "A"+no, "A" + no);
				if (range1.Cells.Value2!=null)

					if (retryCount>15)
			}while ((CellValue.Length>0)||(EmptyCellAllowed)) ;

			return no-1;

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros