public void Process()
{
using (SpreadsheetDocument document = SpreadsheetDocument.Open(FilePath, true))
{
PopulateRows(document);
InititalizeSheetInfo(document);
SharedStringTablePart stringTablePart = _sheetInfo.Item2;
foreach (XlsxRow row in Rows.Skip(1))
{
_currentRowNumber++;
Dictionary <int, string> songInfo = GetSongInfo(row, stringTablePart);
string releaseDate = LastFmApiHelper.GetReleaseDateBySong(songInfo[0], songInfo[1]);
row.Row.Append(SetCellValue(3, (uint)_currentRowNumber, releaseDate));
}
}
}
private void SearchBtn_Click(object sender, RoutedEventArgs e)
{
OutputTxtBox.Text = LastFmApiHelper.GetReleaseDateBySong(SongTitleTxtBox.Text, ArtistTxtBox.Text);
}