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})");
}