or

const string filePath = @"C:\Users\Secure\Downloads\1211Template.xlsx"; var webClient = new WebClient(); webClient.OpenReadCompleted += (senders, eventArgs) => { var formatProvider = new XlsxFormatProvider(); sheet1211.Workbook = formatProvider.Import(eventArgs.Result); }; webClient.OpenReadAsync(new Uri(filePath)); sheet1211.VisibleSize = new SizeI(13, 45); worksheet = sheet1211.Workbook.Worksheets[0]; worksheet.Cells[0, 0, 41, 12].SetFormat(new CellValueFormat("@"));worksheet = sheet1211.Workbook.Worksheets[0];
worksheet.Cells[1, 5].SetValue(DateTime.Parse(issueDate.SelectedDate.ToString()).ToString("ddMMyy"));worksheet = sheet1211.Workbook.Worksheets[0];
worksheet.Cells[currentRow, columnSSN].SetValue(item.SSN);
<ControlTemplate x:Key="ToolWindowControlTemplate" TargetType="telerik:ToolWindow"> <Border x:Name="VisualRoot" BorderThickness="{TemplateBinding BorderThickness}" BorderBrush="{TemplateBinding BorderBrush}" Background="{TemplateBinding Background}" > <Grid> <Grid.RowDefinitions> <RowDefinition Height="Auto" MinHeight="22" /> <RowDefinition Height="*" /> </Grid.RowDefinitions> <Grid.ColumnDefinitions> <ColumnDefinition Width="*" /> <ColumnDefinition Width="Auto" /> </Grid.ColumnDefinitions> <!-- Here, the new command on TOOLWINDOW--> <StackPanel Grid.Column="1" Orientation="Horizontal"> <telerik:RadButton x:Name="SettingsAction" Command="local:RadDockingCommands.OpenSettingsCommand" BorderThickness="0" Height="20" Width="20" Background="Red" Content="Button" ToolTip="Open settings"> </telerik:RadButton> <telerik:RadButton x:Name="CloseButton" Command="telerik:WindowCommands.Close" Margin="0 0 4 0" Content="CLOSE THIS WINDOW" /> </StackPanel> <ContentPresenter x:Name="Content" Margin="{TemplateBinding Padding}" Grid.Row="1" Grid.ColumnSpan="2" Content="{TemplateBinding Content}" /> </Grid> </Border> </ControlTemplate>