private static void Fetchlist() { int page = 1; int maxPage = 1; string startPage = "https://mobile-api.rewe.de/mobile/products/search?withFacets=true&storeId=241108&objectsPerPage=250&page="; WebClient client = new WebClient(); QueryList initQuery = JsonConvert.DeserializeObject <QueryList>(client.DownloadString(startPage + page.ToString())); maxPage = initQuery.pageCount; ExcelController excel = new ExcelController(@"XLS PATH"); for (page = 1; page <= maxPage; page++) { Console.WriteLine("=== CRAWLING PAGE " + page + "/" + maxPage + "==="); QueryList query = JsonConvert.DeserializeObject <QueryList>(client.DownloadString(startPage + page.ToString())); foreach (Product product in query.products) { try { ReweProdukt curProduct = new ReweProdukt(product.productId); excel.InsertRow(curProduct); } catch { continue; } } } Console.ReadLine(); }
public void InsertRow(ReweProdukt product) { try { int newRow = lastRow(); //Console.WriteLine(newRow); sheet.Cells[newRow + 1, 1].Value = product.imgUrl; sheet.Cells[newRow + 1, 2].Value = product.productName; sheet.Cells[newRow + 1, 3].Value = product.servingSize + " " + product.servingEinheit; sheet.Cells[newRow + 1, 4].Value = product.kcal.value; sheet.Cells[newRow + 1, 5].Value = product.fett.value; sheet.Cells[newRow + 1, 6].Value = product.kohlenhydrate.value; sheet.Cells[newRow + 1, 7].Value = product.eiweiß.value; sheet.Cells[newRow + 1, 8].Value = product.salz.value; sheet.Cells[newRow + 1, 9].Value = product.price; } catch (Exception ex) { //Console.WriteLine(ex.Message); } }