public static Task <ExitCode> CreateReport(ExcelReportOptions opts, TextWriter stdErr)
{
if (!File.Exists(opts.PathToHealthExportFile))
{
return(Task.FromResult(ExitCode.ExportFileNotFound(opts.PathToHealthExportFile)));
}
if (File.Exists(opts.OutputFilename))
{
return(Task.FromResult(ExitCode.ExportFileExists(opts.OutputFilename)));
}
var loader = Usable.Using(new StreamReader(opts.PathToHealthExportFile), reader =>
ZipUtilities.ReadArchive(
reader.BaseStream,
entry => entry.FullName == "apple_health_export/export.xml",
entry => new XmlReaderExportLoader(entry.Open()))
.FirstOrDefault());
var settings = GetSettings(opts, stdErr);
var(package, customSheets) = GetCustomSheets(opts, stdErr);
using (var excelFile = new ExcelPackage())
using (package)
{
var timeZone = DateTimeZone.ForOffset(Offset.FromHours(-5));
ExcelReport.BuildReport(loader.Records, loader.Workouts, excelFile.Workbook, settings, timeZone, customSheets);
excelFile.SaveAs(new FileInfo(opts.OutputFilename));
}
return(Task.FromResult(ExitCode.Success));
}
static Settings GetSettings(ExcelReportOptions opts, TextWriter stdErr)
{
if (opts.PathToSettingsFile == null)
{
stdErr.WriteLine($"Settings file not specified. Using default settings.");
return(Settings.Default);
}
if (!File.Exists(opts.PathToSettingsFile))
{
stdErr.WriteLine($"Could not find specified settings file: {opts.PathToSettingsFile}. Using default settings.");
return(Settings.Default);
}
return(SettingsFileHelpers.FromFile(opts.PathToSettingsFile));
}
static (IDisposable package, IEnumerable <ExcelWorksheet> customSheets) GetCustomSheets(ExcelReportOptions opts, TextWriter stdErr)
{
var disposableNop = Disposable.Create(() => { });
if (opts.PathToCustomSheetsExcelFile == null)
{
stdErr.WriteLine($"Custom sheets file not specified. Not using custom sheets.");
return(disposableNop, Enumerable.Empty <ExcelWorksheet>());
}
if (!File.Exists(opts.PathToCustomSheetsExcelFile))
{
stdErr.WriteLine($"Custom sheets file not found: {opts.PathToCustomSheetsExcelFile}. Not using custom sheets.");
return(disposableNop, Enumerable.Empty <ExcelWorksheet>());
}
var customs = new ExcelPackage(new FileInfo(opts.PathToCustomSheetsExcelFile));
var customSheets = customs.Workbook.Worksheets
.Where(w => w.Name.StartsWith("custom", StringComparison.CurrentCultureIgnoreCase))
.ToList();
return(customs, customSheets);
}
