public async Task Run()
{
var result = await Timer.TimeFuncAsync(async() =>
{
var sheet = await _sheetProvider.GetAsync(
_appSettings.SheetId,
"'Herstructurering Filters Data'!A1:H9",
_appSettings.ApiKey);
return(_sheetMapper.Map <EpicTracking>(sheet));
});
foreach (var error in result.Item1.ValidationErrors)
{
Console.WriteLine($"Column: {error.ColumnName} | Row: {error.RowIndex} | Message: {error.ErrorMessage}");
}
Console.WriteLine($"Mapped {result.Item1.ParsedModels.Count} models in {result.Item2.ToString()} " +
$"with {result.Item1.ValidationErrors.Count} validation errors");
Console.WriteLine("===============================================================");
}
public async Task Run()
{
var result = await Timer.TimeFuncAsync(async() =>
{
var sheet = await _sheetProvider.GetAsync("SheetToObjects-a96682815641.json",
"SheetToObjects demo",
"1cxAOIdNlb2UJ8h5ADUyqiolQt7znf-S7AAEKJV8VpJc",
"'store'!A1:U9995");
return(_sheetMapper.Map <Superstore>(sheet));
});
foreach (var error in result.Item1.ValidationErrors)
{
Console.WriteLine($"Column: {error.ColumnName} | Row: {error.RowIndex} | Message: {error.ErrorMessage}");
}
Console.WriteLine($"Mapped {result.Item1.ParsedModels.Count} models in {result.Item2.ToString()} " +
$"with {result.Item1.ValidationErrors.Count} validation errors");
Console.WriteLine("===============================================================");
}
private async Task <Sheet> ReadSheetAsync(string range)
{
return(await _adapter.GetAsync(_pathCredential, null, _spreadSheetId,
range));
}
