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