Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <DataGrid x:Name="grdExcel" Grid.Row="1" Padding="5,15,5,10" IsReadOnly="True" AutoGenerateColumns="True"
- ItemsSource="{Binding MyDataTableFromExcel,Mode=TwoWay,UpdateSourceTrigger=PropertyChanged}"
- VerticalAlignment="Center" >
- public List<CError> ErrorInSheet {get;set;}
- public void LoadData()
- {
- Sheets= GetSheetsFromExcel(PathExcel);
- SelectedSheet= Sheets.FirstOrDefault();
- MyDataTableFromExcel= LoadDataFromSheet(PathExcel, SelectedSheet);
- ErrorInSheet=ValidateData(MyDataTableFromExcel);
- }
- public class CErrorExcel
- {
- public int row { get; set; }
- public int col { get; set; }
- public string Error { get; set; }
- }
Add Comment
Please, Sign In to add comment