private void exelSave() { lo.ShowDialog(); Application app = new Application(); Workbook workbook = app.Workbooks.Add(); //workbook.SaveAs(Filename: @"C:\Users\USER\Desktop\이것저것\MyShoping.xlsx"); workbook.SaveAs(Filename: SaveLink + "\\MyShoping.xlsx"); //workbook = app.Workbooks.Open(Filename: @"C:\Users\USER\Desktop\이것저것\test2.xlsx"); workbook.SaveAs(Filename: SaveLink + "\\MyShoping.xlsx"); Worksheet worksheet = workbook.Worksheets.Add(); int r = 1; worksheet.Cells[r, 1] = "상품명"; worksheet.Cells[r, 2] = "최저가"; worksheet.Cells[r, 3] = "URL"; r++; foreach (BuyDate d in buylist) { worksheet.Cells[r, 1] = d.Title; worksheet.Cells[r, 2] = d.Lprice; worksheet.Cells[r, 3] = d.Link; r += 2; } worksheet.Columns.AutoFit(); workbook.Save(); //workbook.SaveAs(Filename: @"C:\Users\USER\Desktop\이것저것\test2.xlsx"); workbook.Close(); }
private void exelSave() { lo.ShowDialog(); Application app = new Application(); Workbook workbook = app.Workbooks.Add(); workbook.SaveAs(Filename: @"C:\Users\USER\Desktop\하기싫어\test2.xlsx"); workbook = app.Workbooks.Open(Filename: @"C:\Users\USER\Desktop\하기싫어\test2.xlsx"); Worksheet worksheet = workbook.Worksheets.Add(); int r = 1; foreach (BuyDate d in buylist) { worksheet.Cells[r, 1] = d.Title; worksheet.Cells[r, 2] = d.Lprice; worksheet.Cells[r, 3] = d.Link; r++; } workbook.Save(); //workbook.SaveAs(Filename: @"C:\Users\USER\Desktop\이것저것\test2.xlsx"); workbook.Close(); }
//출력 private void PlintSearchList() { panel1.Controls.Clear(); x = 0; y = 0; Loading lo = new Loading(); lo.Function = (() => { for (int i = 0; i < bd.buydateList.Count; i++) { string filepath = bd.buydateList[i].Image; byte[] data = new System.Net.WebClient().DownloadData(filepath); System.IO.MemoryStream ms = new System.IO.MemoryStream(data); Image img = Image.FromStream(ms); shopingItem item = new shopingItem(img, bd.buydateList[i].Title, bd.buydateList[i].Lprice_s, bd.buydateList[i].Link.ToString(), this); this.Invoke(new MethodInvoker( delegate() { panel1.Controls.Add(item); } ) ); if (x == 0 && y == 0) { this.Invoke(new MethodInvoker( delegate() { item.Location = new System.Drawing.Point(x, y + 10); } ) ); x = item.Location.X; y = item.Location.Y; } else { this.Invoke(new MethodInvoker( delegate() { item.Location = new System.Drawing.Point(x, y + 180); } ) ); x = item.Location.X; y = item.Location.Y; } item.num.Text = (i + 1).ToString(); } }); lo.ShowDialog(); }