public Sheet GetFromBase64Encoded(string base64EncodedFile, char delimiter)
{
var fileBytes = Convert.FromBase64String(base64EncodedFile);
var fileString = Encoding.UTF8.GetString(fileBytes);
var data = fileString
.Split(new[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries)
.Select(l => l.Split(delimiter).ToList())
.ToList();
var csvData = new CsvData {
Values = data
};
return(_csvDataConverter.Convert(csvData));
}
public async Task <Sheet> GetAsync(string authenticationJsonFilePath, string documentName, string sheetId, string range)
{
var service = _googleClientServiceCreator.Create(authenticationJsonFilePath, documentName);
var sheetDataResponse = await service.Get(sheetId, range);
return(_protectedGoogleSheetAdapter.Convert(sheetDataResponse));
}
public Sheet GetFromStream(Stream fileStream, string sheetName, ExcelRange range, bool stopReadingOnEmptyRow = false)
{
using (var excelPackage = new ExcelPackage(fileStream))
{
var workBook = excelPackage.Workbook;
var workSheet = GetSheetFromWorkBook(workBook, sheetName);
var data = CreateDataForRange(workSheet, range, stopReadingOnEmptyRow);
var excelData = new ExcelData {
Values = data
};
return(_excelDataConverter.Convert(excelData));
}
}
public async Task <Sheet> GetAsync(string sheetId, string range, string apiKey)
{
var sheetDataResponse = await _googleSheetApi.GetSheetAsync(sheetId, range, apiKey);
return(_googleSheetAdapter.Convert(sheetDataResponse));
}
