Excel stores printer settings in two places: 

1. Standard printer settings: You can set/read this with PrintPaperSize , PrintScale , PrintOptions (Landscape inside printOptions only), PrintXResolution , PrintYResolution and PrintCopies

2. Printer driver settings: You can access this with PrinterDriverSettings.

NOTE THAT THOSE PLACES STORE DUPLICATED INFORMATION. For example, Excel stores the PageSize on both Standard printer settings and Printer driver settings. 

Always that a value is stored on both places, Standard printer settings takes preference. 

If you set PaperSize=A4 on standard settings and PaperSize=A5 on driver settings, A4 will be used. 

Look at the example to see how to copy printer driver settings from one file to other.

To copy the printer driver information from an empty template to the working file, use:

Xls1.PrinterDriverSettings := Xls2.PrinterDriverSettings;

If you have defined a printer specific paper size, and you want to use it, you should call

Xls1.PrintPaperSize := Xls2.PrintPaperSize;

TFlexCelImport Properties