Excel auf dem Client PC ansteuern und als Angebot Druckvorlage mit Daten füllen? Möglich? Wie? - Microsoft Dynamics CRM 3.0: Technische Tipps, Tricks und Codeaustausch

Hallo allerseits,

ich habe folgende Frage:

Ist es möglich Excel auf der jeweiligen Client Maschiene über "Regel anwenden" anzusteuern?

Den Code um das excel Client seitig zu erzeugen habe ich schon.

Die Frage ist nur kann ich Excel Problemlos über "Regel anwenden" von einem Angebot aus aufrufen und die korrespondierenden Daten übergeben?

Gibt es Methoden im der CrmService.cs die ein weitegeben von Daten an excel oder andere Programme unterstützt?

Hat jemand so etwas schon einmal gemacht? Oder einen Link für mich?

Ich bin für jede Hilfe dankbar

Ich arbeite mit Visual Studio 2005 und Microsoft Visual C# 2005

Der Code für den Excel Aufruf funktioniert soweit

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Excel = Microsoft.Office.Interop.Excel;

using System.Reflection;

using System.Text.RegularExpressions;

namespace CRM_EXCEL

class TestAufruf

public static void Main()

ExcelPrintOffer TestObject = new ExcelPrintOffer();

class ExcelPrintOffer

protected Excel.Application VarExcelAppplication;

protected Excel._Workbook VarExcelWorkbook;

protected Excel._Worksheet VarExcelSheet;

protected Excel.Range VarExcelRange;

// generate Offer Base Document

public ExcelPrintOffer ()

try

//Start Excel and get Application object.

VarExcelAppplication = new Excel.Application();

VarExcelAppplication.Visible = true;

//Open existing Workbook

//VarExcelWorkbook = (Excel._Workbook)(VarExcelAppplication.Workbooks.Open(VarExcelWorkbookPath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing));

//Create a new workbook.

VarExcelWorkbook = (Excel._Workbook)(VarExcelAppplication.Workbooks.Add(Missing.Value));

//Set active Sheet of the Woorkbook as VarExcelSheet

VarExcelSheet = (Excel._Worksheet)VarExcelWorkbook.ActiveSheet;

catch (Exception theException)

String errorMessage;

errorMessage = "Error: ";

errorMessage = String.Concat(errorMessage, theException.Message);

errorMessage = String.Concat(errorMessage, " Line: ");

errorMessage = String.Concat(errorMessage, theException.Source);

MessageBox.Show(errorMessage, "Error");

protected void WriteStringToSheetCell(int VarExcelSheetZeileMethodenAufruf, int VarExcelSheetSpalteMethodenAufruf, string ZellenInhaltMethodenAufruf)

//Set up the generell Layout of the offer

public void SetUpOffer()

WriteStringToSheetCell(1, 2, "Simi system offer");

VarExcelSheet.get_Range("B1", "B1").Font.Bold = true;

VarExcelSheet.get_Range("B1", "B1").HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter;

VarExcelSheet.get_Range("B1", "B1").Font.Size = 14;

WriteStringToSheetCell(4, 2, "SIMI Reality Motion Systems GmbH / Postfach 1518 / 85705 Unterschleissheim / Germany");

VarExcelSheet.get_Range("B4", "B4").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

//Array for the "A" vertical Column

string[] AColumnWordsVertical = { "Partner", "Contact", "Quotenumber", "Revisionsnummer", "Customer", "Adress", "Fon", "Fax", "Simi project offers"};

//Format as bold, vertical alignment = center.

VarExcelSheet.get_Range("A4", "A12").Font.Bold = true;

VarExcelSheet.get_Range("A4", "A12").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

//VarExcelSheet.get_Range("A4", "A12").Font.Background =;

//Array for the Row16 horizontal

string[] Row16WordsHorizontal = { "Simi software", "Description", "Amount", "Product", "Price" };

//Format as bold, vertical alignment = center.

VarExcelSheet.get_Range("A16", "E16").Font.Bold = true;

VarExcelSheet.get_Range("A16", "E16").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

//Array for the Row17 horizontal

string[] Row17WordsHorizontal = { "Simi hardware", "Description", "Amount", "Product", "Price" };

//Format as bold, vertical alignment = center.

VarExcelSheet.get_Range("A17", "E16").Font.Bold = true;

VarExcelSheet.get_Range("A17", "E16").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

//Array for the Row18 horizontal

string[] Row18WordsHorizontal = { "Simi project offers", "Description", "Amount", "Product", "Price" };

//Format as bold, vertical alignment = center.

VarExcelSheet.get_Range("A18", "E16").Font.Bold = true;

VarExcelSheet.get_Range("A18", "E16").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

//Array for the Row19 horizontal

string[] Row19WordsHorizontal = { "Simi service", "Description", "Amount", "Product", "Price" };

//Format as bold, vertical alignment = center.

VarExcelSheet.get_Range("A19", "E16").Font.Bold = true;

VarExcelSheet.get_Range("A19", "E16").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

//AutoFit columns

VarExcelRange = VarExcelSheet.get_Range("A1", "H1");

//Make sure Excel is visible and give the user control

//of Microsoft Excel's lifetime.

VarExcelAppplication.Visible = true;

VarExcelAppplication.UserControl = true;

//Writes stringarrays to the offer determined by array column and startingrow

private void WriteArraysTopDownToOffer(String[] ArrayToReadFrom, int ColumnToRunThrough, int RowToStartWritingTo)

int CurrentPositionInArray = 0;

int VarCurrentRow = RowToStartWritingTo;

String CallerString;

while (CurrentPositionInArray < ArrayToReadFrom.Length)

private void WriteArraysLeftRightToOffer(String[] ArrayToReadFrom, int RowToRunThrough, int ColumnToStartWritingTo)

int CurrentPositionInArray = 0;

int VarCurrentColumn = ColumnToStartWritingTo;

String CallerString;

while (CurrentPositionInArray < ArrayToReadFrom.Length)