示例#1
0
        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));
                }
            }
        }
示例#2
0
 private void SearchBtn_Click(object sender, RoutedEventArgs e)
 {
     OutputTxtBox.Text = LastFmApiHelper.GetReleaseDateBySong(SongTitleTxtBox.Text, ArtistTxtBox.Text);
 }