Hi,
I am using a xamSpreadSheet in a WPF application as follows
<Window xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:ig="http://schemas.infragistics.com/xaml" x:Class="spreadsheetTest.MainWindow" Title="MainWindow" Height="350" Width="525"> <Grid Margin="25,31,49.4,17.4"> <Grid.ColumnDefinitions> <ColumnDefinition/> <ColumnDefinition Width="0*"/> </Grid.ColumnDefinitions> <ig:XamSpreadsheet Name="_spreadsheet1" IsEnabled="True" Margin="21,26,0,0" VerticalAlignment="Top" Height="203" RenderTransformOrigin="0.5,0.5" HorizontalAlignment="Left" Width="338"> <ig:XamSpreadsheet.RenderTransform> <TransformGroup> <ScaleTransform/> <SkewTransform AngleY="0.235" AngleX="-0.364"/> <RotateTransform/> <TranslateTransform Y="0.595" X="0.556"/> </TransformGroup> </ig:XamSpreadsheet.RenderTransform> </ig:XamSpreadsheet> <Button Content="Button" HorizontalAlignment="Left" Margin="80,246,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click"/> </Grid></Window>
Code behind: for the button click
private void Button_Click(object sender, RoutedEventArgs e) { string file = @"C:\FileSample.xlsx"; using (var stream = File.Open(file, FileMode.Open, FileAccess.ReadWrite, FileShare.None)) { _spreadsheet1.Workbook = Infragistics.Documents.Excel.Workbook.Load(stream); } }
After I load the excel file, I am unable to edit, on property which I have missed. Please let me know.
Thanks
Hello Boomesh,
I have been looking into you issue and please notice that xamSpreadsheet is released as CTP in 14.1(see this article). XamSpreadsheet in 14.1 is more like a viewer and there is no selection and editing there. If you want to use all functionalities of our xamSpreadsheet you will need to upgrade to 14.2 or above.
If you need further assistance do not hesitate to ask.
Thanks,TeodorSoftware Developerwww.infragistics.com
I am using Infragisitcs 14.1 WPF XamSpreadSheet control.