TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
kshama parashar
NA
89
0
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
Reply
Answers (
1
)
Thread problem.
DoWork() method not executing