excel in silverlight4

Jan 8 2010 6:41 AM
I am makimg the project as coding in c# and designing in 

silverlight4...

here is one requirement of making excel sheet in silverlight4..

this is a coding i have done in designing page..

<UserControl x:Class="SilverlightExcel.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    

xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400">


    <Grid x:Name="LayoutRoot" Background="White">
        <Button Content="Create XLS" Width="100" Height="30" 

Click="Button_Click" />
    </Grid>
</UserControl>
***********************************************************************

**********************
 
and this is the coding in  .cs page


 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Windows.Interop;


namespace SilverlightExcel
{
    public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();
        }


        private void Button_Click(object sender, RoutedEventArgs e)
        {
            dynamic excel = 

ComAutomationFactory.CreateObject("Excel.Application");
            excel.Visible = true;


            dynamic workbook = excel.workbooks;
            workbook.Add();
            dynamic sheet = excel.ActiveSheet;


            dynamic range;


            range = sheet.Range("A1");
            range.Value = "Hello from Silverlight";
            range = sheet.Range("A2");
            range.Value = "100";
            range = sheet.Range("A3");
            range.Value = "50";
            range = sheet.Range("A4");
            range.Formula = "=@Sum(A2..A3)";
            range.Calculate();
        }
    }
}
 
 
Where I am doing the mistake ....when i build this project...it 

succeeded...but at run time it is not showing anything...
 
please help me..
as soon as possible..
thanks to all in advance


Attachment: SilverlightExcel.rar

Answers (1)