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