public RunWebCommandResult Execute(ImportFromGoogleSheetParameters importParameters)
{
GoogleCredential credential;
credential = GoogleCredential
.FromFile(importParameters.CredentialsFileNamePath)
.CreateScoped(Scopes);
// Create Google Sheets API service.
var service = new SheetsService(new BaseClientService.Initializer()
{
HttpClientInitializer = credential,
ApplicationName = _applicationName,
});
// Define request parameters.
string spreadsheetId = importParameters.SpreadsheetId;
string range = importParameters.ImportRange;
SpreadsheetsResource.ValuesResource.GetRequest request =
service.Spreadsheets.Values.Get(spreadsheetId, range);
ValueRange response = request.Execute();
IList <IList <object> > values = response.Values;
if (values != null && values.Count > 0)
{
Console.WriteLine("- Reading data from Google sheet: -");
for (int row = 0; row < values.Count; row++)
{
Console.Write("[row {0}] ", row);
for (int col = 0; col < values[row].Count; col++)
{
Console.Write("|{1,5}", col, values[row][col]);
}
Console.WriteLine();
}
}
else
{
Console.WriteLine("No data found.");
}
//Console.Read();
return(new RunWebCommandResult()
{
ResultCode = 0
});
}
public void ImportData()
{
var import = new ImportFromGoogleSheetToExcel();
var importParameters = new ImportFromGoogleSheetParameters()
{
SpreadsheetId = "1DVVmqRWVTn4nQkwVOd5VOucQ_L4fTT4S3EiVR-W13qA",
ImportRange = "Sheet1!A1:E",
CredentialsFileNamePath = @"C:\git\ParserQueueRunner\credentials.json",
ExcelInsertRange = ""
};
var result = import.Execute(importParameters);
Assert.IsNotNull(result);
Assert.AreEqual(0, result.ResultCode);
}