Untitled
unknown
plain_text
a year ago
3.8 kB
12
Indexable
try { var workbook = new XLWorkbook(file.FileName); var worksheet = workbook.Worksheet(1); if (worksheet == null) return; int i = 1; string typecount = worksheet.Cell("D1").GetValue<string>(); if (string.IsNullOrEmpty(typecount)) typecount = worksheet.Cell("D2").GetValue<string>(); while (true) { i++; string idpage = worksheet.Cell("A" + i).GetValue<string>(); PostInfo post = new PostInfo(); post.PageID = idpage; post.IdPost = worksheet.Cell("B" + i).GetValue<string>(); post.TypePost = worksheet.Cell("C" + i).GetValue<string>(); if (string.IsNullOrEmpty(post.TypePost)) break; if (!typecount.IsContains("View Count")) { try { post.Like_Count = worksheet.Cell("D" + i).GetValue<int>(); post.Share_Count = worksheet.Cell("E" + i).GetValue<int>(); post.Comment_Count = worksheet.Cell("F" + i).GetValue<int>(); } catch { } post.Content = worksheet.Cell("G" + i).GetValue<string>(); post.ListUrlImage = new List<string>(); post.ListUrlImage = worksheet.Cell("H" + i).GetValue<string>().GetAllLine(); post.Url_video = worksheet.Cell("I" + i).GetValue<string>(); post.preset_id = worksheet.Cell("J" + i).GetValue<string>(); post.Linkshare = worksheet.Cell("K" + i).GetValue<string>(); post.Comment = worksheet.Cell("L" + i).GetValue<string>(); post.ID = DataGetPost_Thucong.Count + 1; post.attachments = false; if (post.ListUrlImage.Count > 0 || !string.IsNullOrEmpty(post.Url_video) || !string.IsNullOrEmpty(post.Linkshare)) post.attachments = true; } else { try { post.Play_Count = worksheet.Cell("D" + i).GetValue<int>(); } catch { } numViewTT = numViewTT + post.Play_Count; post.Content = worksheet.Cell("E" + i).GetValue<string>(); } post.ID = DataGetPost_Thucong.Count + 1; this.Dispatcher.Invoke(() => { DataGetPost_Thucong.Add(post); }); } workbook.Dispose(); this.Dispatcher.Invoke(() => { MessageBoxShow("Load thành công"); }); } catch (Exception ex) { this.Dispatcher.Invoke(() => { MessageBoxShow(ex.ToString()); }); }
Editor is loading...
Leave a Comment