public int getLastRowNumber() { var gsh = new GoogleSheetsHelper("swing-293507-ca9c2651b2d1.json", "13I2pgJbXZjuqX8EbI3WnNCCuK8j3HpFNbqyAQypEYYg"); var gsp = new GoogleSheetParameters() { RangeColumnStart = 17, RangeRowStart = 2, RangeColumnEnd = 17, RangeRowEnd = 2, FirstRowIsHeaders = false, SheetName = "관심종목" }; var rowValues = gsh.GetDataFromSheet(gsp); string result = "2"; foreach (var item in rowValues) { var dict = (IDictionary <string, object>)item; foreach (var d in dict) { result = d.Value.ToString(); } } return(int.Parse(result) + 1); }
public void updateCodeListToGoogleSheet(Opt10001VO opt10001VO, string conditionName) { var gsh = new GoogleSheetsHelper("swing-293507-ca9c2651b2d1.json", "13I2pgJbXZjuqX8EbI3WnNCCuK8j3HpFNbqyAQypEYYg"); var row = new GoogleSheetRow(); var cells = new List <GoogleSheetCell>(); cells.Add(new GoogleSheetCell() { CellValue = conditionName }); cells.Add(new GoogleSheetCell() { CellValue = DateTime.Now.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.종목명 }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.종목코드 }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.시가총액.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.통주식.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.시가.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.고가.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.저가.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.현재가.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.등락율.ToString() }); cells.Add(new GoogleSheetCell() { CellValue = opt10001VO.거래량.ToString() }); row.Cells.AddRange(cells); var rows = new List <GoogleSheetRow>() { row }; gsh.AddCells(new GoogleSheetParameters() { SheetName = sheetName, RangeColumnStart = 1, RangeRowStart = rangeRowStart }, rows); rangeRowStart++; logger.Info($"{opt10001VO.종목명} 업데이트 완료 ({rangeRowStart})"); }