[AccessD] C# automation of office

Very interesting. John Walk once said he would go to his grave before coding
in VSTO.

I'm interested in knowing if there are any performance "hits" compared to
native Excel/VBA when employing dot-net interop solutions. The incredibly
increased verbosity of the coding required already speaks of lower
development speed.
>
> // This bit shows the using statements you will need
>
> using Microsoft.Office.Interop.Excel;
> using Microsoft.Office.Tools.Excel;
>
>
>
>
> // This bit shows how to op an connection to Excel
>
>             if (grdParts.RowCount > 0)
>             {
>                 if (MessageBox.Show("Export Master Parts
> List?", "Export", MessageBoxButtons.YesNo,
> MessageBoxIcon.Question) == (DialogResult.Yes))
>                 {
>                     this.Cursor = Cursors.WaitCursor;
>                     Int32 intPos = bsParts.Position;
>                     try
>                     {
>                         if (SaveChanges())
>                         {
>
> Microsoft.Office.Interop.Excel.Application xlApp = new
> Microsoft.Office.Interop.Excel.Application();
>
> Microsoft.Office.Interop.Excel.Workbook xlWB =
> xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
>
> Microsoft.Office.Interop.Excel.Worksheet xlWS =
> (Microsoft.Office.Interop.Excel.Worksheet)xlWB.Worksheets[1];
>
>                             xlApp.Visible = true;
>
>                             xlWS.Cells[2, 6] = "Parts List ";
>                             xlWS.Cells[3, 6] = "Date " +
> DateTime.Now.ToLongDateString();
>
>
> // This bit shows how to write comments to excel
>
> Microsoft.Office.Interop.Excel.Range nRange;
>
>                             nRange =
> (Microsoft.Office.Interop.Excel.Range)xlWS.Cells[intRowIndex
> + intRowIncrement, intColumnIndex - 11];
>
> nRange.AddComment(strFullComments.Replace("\r",
> ""));
>
> nRange.Comment.Shape.TextFrame.AutoSize = true;
>
>
>
>
> // This but shows  how to insert a column
>                             Range rng = (Range)xlWS.Cells[1,2];
>                             Range column = rng.EntireColumn;
>
>  column.Insert(XlInsertShiftDirection.xlShiftToRight, false);
>
>  column.Insert(XlInsertShiftDirection.xlShiftToRight, false);
>
>
> // this bit shows how to save the sheet
>                             String strFileName = "C:\\McAfee
> Prd Report_" +
> DateTime.Now.ToLongDateString() + "-" +
> DateTime.Now.ToLongTimeString().Replace(":", "") + ".xls";
>                             xlWS.SaveAs(strFileName,
> Type.Missing, Type.Missing, Type.Missing, Type.Missing,
> Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
>