/// <summary>
/// Otwarcie okna dialogowego do wybrania pliku XLS
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OpenFile_Click(object sender, RoutedEventArgs e)
{
//otwarcie okna dialogowego
Service.FileDialog dialog = new Service.FileDialog();
string FileName = dialog.OpenDialog();
//otwarcie pliku XLS
FileStream fileStream = new FileStream(FileName, FileMode.Open, FileAccess.Read);
ExcelParser xlsManager = new ExcelParser(fileStream);
//parsowanie pliku xls
List <ExcelContent> fileContent = new List <ExcelContent>();
fileContent = xlsManager.ParseExcel();
//dodanie wyniku parsowania do kolekcji
ExcelFiles.Add(new ExcelFile()
{
FileName = FileName,
Content = fileContent
});
excelContent.ItemsSource = rows;
FileList.Items.Refresh();
}
public void AddFile(string[] files)
{
if (ExcelFiles == null)
{
ExcelFiles = new List <string>();
}
ExcelFiles.Clear();
for (int i = 0; i < files.Length; i++)
{
if (!ExcelFiles.Contains(files[i]))
{
ExcelFiles.Add(files[i]);
}
ExcelCache.AddExcaleCache(files[i]);
}
}