public void WriteToExcel(string info, SettingsInfo settingsInfo, DownloadedPartOfPageSettingInfo downloadedPart)
{
if (writingPath != null)
{
Directory.CreateDirectory(writingPath);
}
var file = new FileInfo($"{writingPath}{settingsInfo.NameOfFileToWriteInfo}");
using (var excelPackage = new ExcelPackage(file))
{
if (file.Exists)
{
excelPackage.File.Attributes = FileAttributes.Normal;
}
ExcelWorksheet workSheet;
InitializeWorkSheet(excelPackage, out workSheet);
InstallCurrentWritingPositionIfIsNull(downloadedPart, settingsInfo, workSheet);
workSheet.Cells[downloadedPart.CurrentWritingPosition.Row, downloadedPart.CurrentWritingPosition.Column].Value = info;
if (settingsInfo.HorizontalOrientationOfWritingInfo)
{
downloadedPart.CurrentWritingPosition.Column += settingsInfo.BetweenLineDistance;
}
else
{
downloadedPart.CurrentWritingPosition.Row += settingsInfo.BetweenLineDistance;
}
excelPackage.Save();
excelPackage.File.Attributes = FileAttributes.ReadOnly;
}
}
private void InstallCurrentWritingPositionIfIsNull(DownloadedPartOfPageSettingInfo downloadedPartInfo, SettingsInfo settingsInfo, ExcelWorksheet workSheet)
{
if (downloadedPartInfo.CurrentWritingPosition == null)
{
if (!string.IsNullOrWhiteSpace(downloadedPartInfo.Header))
{
workSheet.Cells[downloadedPartInfo.StartPositionOfWriting.Row, downloadedPartInfo.StartPositionOfWriting.Column].Value = downloadedPartInfo.Header;
if (settingsInfo.HorizontalOrientationOfWritingInfo)
{
downloadedPartInfo.CurrentWritingPosition = new Position
{
Row = downloadedPartInfo.StartPositionOfWriting.Row,
Column = downloadedPartInfo.StartPositionOfWriting.Column + settingsInfo.BetweenLineDistance
};
}
else
{
downloadedPartInfo.CurrentWritingPosition = new Position
{
Row = downloadedPartInfo.StartPositionOfWriting.Row + settingsInfo.BetweenLineDistance,
Column = downloadedPartInfo.StartPositionOfWriting.Column
};
}
workSheet.Cells[downloadedPartInfo.StartPositionOfWriting.Row, downloadedPartInfo.StartPositionOfWriting.Column].Style.Font.Color.SetColor(Color.Blue);
}
else
{
downloadedPartInfo.CurrentWritingPosition = (Position)downloadedPartInfo.StartPositionOfWriting.Clone();
}
}
else
{
if (settingsInfo.HorizontalOrientationOfWritingInfo)
{
downloadedPartInfo.CurrentWritingPosition.Column += settingsInfo.BetweenWritingNewInfoDistance;
}
else
{
downloadedPartInfo.CurrentWritingPosition.Row += settingsInfo.BetweenWritingNewInfoDistance;
}
}
}
