Skip to content
This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

Don't work PrinterSettings with net core 3.1 #622

Closed
veliev opened this issue Feb 19, 2020 · 1 comment
Closed

Don't work PrinterSettings with net core 3.1 #622

veliev opened this issue Feb 19, 2020 · 1 comment

Comments

@veliev
Copy link

veliev commented Feb 19, 2020

Test Epplus version 5.0.1 and 4.5.3.3

FileInfo fileInfo = new FileInfo(Program.ReportsFolder + nameReport);
using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
{
        ExcelWorksheets worksheets = excelPackage.Workbook.Worksheets;
        foreach (ExcelWorksheet worksheet in worksheets)
        {
                Console.WriteLine(worksheet.Name);
                worksheet.PrinterSettings.Orientation = eOrientation.Portrait;
                worksheet.PrinterSettings.FitToPage = true;
                worksheet.PrinterSettings.FitToHeight = 1;
                worksheet.PrinterSettings.FitToWidth = 1;
        }
        excelPackage.Save();
}

After excelPackage.Save() print setting don't change

@veliev
Copy link
Author

veliev commented Feb 19, 2020

Sorry, PrinterSettings work good.
This is my error, incorrectly re-saved xls with markup html (re-saved with interop).
Its OK now!!

@veliev veliev closed this as completed Feb 19, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant