Creating an Excel document from .NET + C#

[volume]

Hi all,

In an effort to try to impress the boss, I would like to log accounting information to an Excel spreadsheet using C# and .NET. This would be a mockup only, not a real solution - yet!

We are a small ticketing company - not a bunch of IT whiz kids. ...but I do have an IT background.

I have been successful in logging (printing) tickets to a word document, and it all works kinda cool.
However, I wish to log to same information to an Excel document. For example, I want to log each ticket on a new row of a spreadsheet. Alas, writing to an excel document is not as easy as writing to Word.

So I would need to (1) create a new Excel document, if it did not exist, (2) Write the ticket information on the NEXT row of a spreadsheet, (3) Save and close the file. I am looking at writing a new function/method called "public void Log" to do this.

How would I do this? Can someone provide an example of how to create and save a new Excel document? And then write data to the rows?

Thankyou so very much in advance!

Ticketing printing code using .NET and C#:

class Ticket

{

public Event e;

public String Section;

public String Type;

public String Price;

public String Comment;



private Word.Applicatio nClass WordApp = null;

private Word.Document Paper = null;



public void Open()

{

if (WordApp == null)

{

object Missing = System.Reflecti on.Missing.Valu e;

object FileName = "normal.dot ";

object NewTemplate = false;

object DocType = 0;

object isVisible = true;



WordApp = new Word.Applicatio nClass();

Paper = WordApp.Documen ts.Add(ref FileName, ref NewTemplate, ref DocType, ref isVisible);



WordApp.Visible = true;



Paper.Activate( );

}



return;

}



public void Close()

{

if (WordApp != null)

{

object Missing = System.Reflecti on.Missing.Valu e;

object FileName = "ticket.doc ";



Paper.SaveAs(re f FileName, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing);



Paper.Close(ref Missing, ref Missing, ref Missing);

WordApp.Quit(re f Missing, ref Missing, ref Missing);



WordApp = null;

}



return;

}



public void Print()

{

if (WordApp != null)

{

WordApp.Selecti on.ParagraphFor mat.Alignment = Word.WdParagrap hAlignment.wdAl ignParagraphCen ter;

WordApp.Selecti on.Font.Bold = (int) Word.WdConstant s.wdToggle;

WordApp.Selecti on.TypeText("Ti cket Information");



InsertBlankLine s(1);



WordApp.Selecti on.Font.Bold = (int) Word.WdConstant s.wdToggle;

WordApp.Selecti on.ParagraphFor mat.Alignment = Word.WdParagrap hAlignment.wdAl ignParagraphLef t;

WordApp.Selecti on.TypeText("\n Event:\t" + e.Name);

WordApp.Selecti on.TypeText("\n Theatre:\t" + e.Venue);

WordApp.Selecti on.TypeText("\n Date:\t" + e.DateAndTime);

WordApp.Selecti on.TypeText("\n Section:\t" + Section);

WordApp.Selecti on.TypeText("\n Type:\t" + Type); WordApp.Selecti on.TypeText("Pr ice:\t" + Price);

WordApp.Selecti on.TypeText("\n Additional Information: " + Comment);

WordApp.Selecti on.TypeText("\n Date Printed:\t"); InsertTimeDate( );



InsertBlankLine s(2);

}



return;

}



private void InsertBlankLine s(int number)

{

if (WordApp != null)

{

int iCount = 0;



for (iCount = 0; iCount < number; ++iCount)

{

WordApp.Selecti on.TypeParagrap h();

}

}



return;

}



private void InsertTimeDate( )

{

if (WordApp != null)

{

object Missing = System.Reflecti on.Missing.Valu e;

object False = false;

object objDate = "dddd, MMMM dd, yyyy at HH:mm:ss";



WordApp.Selecti on.InsertDateTi me(ref objDate, ref False, ref Missing, ref Missing, ref Missing);

WordApp.Selecti on.TypeParagrap h();

}



return;

}

}