working with excel file in c#

See more:

C#

Hi,

Is this really necessary to do all this stuff for initializing a workbook in c#

object misValue = System.Reflection.Missing.Value;
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkBook = xlApp.Workbooks.Add(misValue);
Excel.Worksheet xlWorkSheet1 = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
Excel._Worksheet xlWorksheet1 = xlWorkBook.Sheets[1];
Excel.Range xlRange1 = xlWorksheet1.UsedRange;

what is this Excel.Range command will do???

How to add new work sheet to work book???

I tried something like this

Excel._Worksheet xlWorksheet2 = xlWorkBook.Sheets[2];

Thanks
John