Guest User

Untitled

a guest
Oct 23rd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. <DataGrid x:Name="grdExcel" Grid.Row="1" Padding="5,15,5,10" IsReadOnly="True" AutoGenerateColumns="True"
  2. ItemsSource="{Binding MyDataTableFromExcel,Mode=TwoWay,UpdateSourceTrigger=PropertyChanged}"
  3. VerticalAlignment="Center" >
  4.  
  5. public List<CError> ErrorInSheet {get;set;}
  6.  
  7. public void LoadData()
  8. {
  9. Sheets= GetSheetsFromExcel(PathExcel);
  10. SelectedSheet= Sheets.FirstOrDefault();
  11. MyDataTableFromExcel= LoadDataFromSheet(PathExcel, SelectedSheet);
  12. ErrorInSheet=ValidateData(MyDataTableFromExcel);
  13.  
  14. }
  15.  
  16. public class CErrorExcel
  17. {
  18. public int row { get; set; }
  19. public int col { get; set; }
  20. public string Error { get; set; }
  21. }
Add Comment
Please, Sign In to add comment