public GoogleSheetService( IOptions <GoogleSheetCredential> googleSheetCredential, IOptions <GoogleSheetModel> googleSheetModel) { var credentialString = googleSheetCredential.Value.Ext_ToJson(); _sheetsService = OpenSheet(credentialString); _googleSheetModel = googleSheetModel.Value; }
public void Init() { var googleSheetCredential = new GoogleSheetCredential(); var googleSheet = new GoogleSheetModel(); IConfigurationRoot config = new ConfigurationBuilder() .AddJsonFile(@"appsettings.json", false) .AddUserSecrets("136c518e-7f41-48ab-b641-3facb3f2782c") .Build(); config.GetSection("GoogleSheetCredential").Bind(googleSheetCredential); config.GetSection("GoogleSheet").Bind(googleSheet); _googleSheetCredential = Options.Create(googleSheetCredential); _googleSheet = Options.Create(googleSheet); _googleSheetService = new GoogleSheetService(_googleSheetCredential, _googleSheet); }