Click here to Skip to main content
15,895,740 members
Home / Discussions / C#
   

C#

 
AnswerRe: string to int, double? Pin
Ista1-Aug-03 5:57
Ista1-Aug-03 5:57 
Generalpress enter anywhere in form to activate button Pin
mikemilano1-Aug-03 5:07
mikemilano1-Aug-03 5:07 
GeneralRe: press enter anywhere in form to activate button Pin
Valeria Bogdevich1-Aug-03 5:33
Valeria Bogdevich1-Aug-03 5:33 
GeneralConvincing web service migration Pin
Steve Severance1-Aug-03 4:36
Steve Severance1-Aug-03 4:36 
GeneralRe: Convincing web service migration Pin
Daniel Turini1-Aug-03 5:00
Daniel Turini1-Aug-03 5:00 
GeneralRe: Convincing web service migration Pin
Ista1-Aug-03 6:03
Ista1-Aug-03 6:03 
GeneralExcel in C# Pin
don7cry1-Aug-03 0:50
don7cry1-Aug-03 0:50 
GeneralRe: Excel in C# Pin
Philip Fitzsimons1-Aug-03 2:28
Philip Fitzsimons1-Aug-03 2:28 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncscol/html/csharp07172003.asp[^]

is pretty good - tells you how to install the PIA.

however you can simplyfy the code to:

using Excel;
using Microsoft.Office.Core;
using System.Reflection;

namespace whaterever
{

class ExcelToWhatever
{
Excel.Application _excel = null;

		[STAThread]
		static void Main(string[] args)
		{
			ExcelToWhatever app = new ExcelToWhatever();

		}

		public ExcelToWhatever()
		{
			_excel = new Excel.ApplicationClass();
			_excel.Visible = true;

			try
			{
				Process();
			}
			finally
			{
				_excel.Quit();
			}
		}

		void Process()
		{
			Workbook workbook = _excel.Workbooks.Open(@"whatever.xls",
				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);
			ProcessSheet((Worksheet)workbook.Worksheets["sheet1"]);
		}		
		void ProcessSheet(Worksheet worksheet)
		{
				Range aCell = (Range)worksheet.Cells[1, 2];
				string cellText = aCell .Value2.ToString().Trim();
		}

}

}





"When the only tool you have is a hammer, a sore thumb you will have."

GeneralRe: Excel in C# Pin
Jesse Squire1-Aug-03 3:07
Jesse Squire1-Aug-03 3:07 
GeneralRe: Excel in C# Pin
Ista1-Aug-03 6:20
Ista1-Aug-03 6:20 
GeneralRe: Excel in C# Pin
sburton@amersham1-Aug-03 7:57
sburton@amersham1-Aug-03 7:57 
Questionsql connection best practise? Pin
isarfraz1-Aug-03 0:34
isarfraz1-Aug-03 0:34 
AnswerRe: sql connection best practise? Pin
Rampas Tomas1-Aug-03 1:51
Rampas Tomas1-Aug-03 1:51 
GeneralRe: sql connection best practise? Pin
isarfraz1-Aug-03 2:20
isarfraz1-Aug-03 2:20 
GeneralRe: sql connection best practise? Pin
Khang Nguyen1-Aug-03 6:19
Khang Nguyen1-Aug-03 6:19 
QuestionNetwork Access? Pin
Rocky Moore1-Aug-03 0:10
Rocky Moore1-Aug-03 0:10 
AnswerRe: Network Access? Pin
Rampas Tomas1-Aug-03 1:25
Rampas Tomas1-Aug-03 1:25 
GeneralRe: Network Access? Pin
Rocky Moore1-Aug-03 21:17
Rocky Moore1-Aug-03 21:17 
GeneralRe: Network Access? Pin
J. Dunlap1-Aug-03 21:21
J. Dunlap1-Aug-03 21:21 
GeneralRe: Network Access? Pin
Rocky Moore1-Aug-03 22:01
Rocky Moore1-Aug-03 22:01 
GeneralRe: Network Access? Pin
J. Dunlap1-Aug-03 22:19
J. Dunlap1-Aug-03 22:19 
GeneralRe: Network Access? Pin
Rocky Moore2-Aug-03 2:56
Rocky Moore2-Aug-03 2:56 
GeneralInvestigating assemblies Pin
Profox Jase31-Jul-03 22:27
Profox Jase31-Jul-03 22:27 
GeneralRe: Investigating assemblies Pin
Profox Jase31-Jul-03 22:29
Profox Jase31-Jul-03 22:29 
GeneralRe: Investigating assemblies Pin
J. Dunlap31-Jul-03 22:49
J. Dunlap31-Jul-03 22:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.