How to set excel custom page size with c#

Question

Hi dears,
I want to change (or create new excel file) page Height/Width in custom size for example 7cm*10cm.
I'm using Microsoft.Office.Interop.Excel.
How can I do it?

Answer 1

Hi @hossein tavakoli , Welcome to Microsoft Q&A.

Normally, if your paper size is special, you should add the corresponding format in the printer's paper format, and then select it when printing.

The following is a code that can use c# to open the print pop-up box. After the pop-up box, you can select the printer, print paper, and preview the printed page.

private void button1_Click(object sender, EventArgs e)  
{  
    Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();  
  
    // Open the Workbook:  
    Microsoft.Office.Interop.Excel.Workbook wb = excelApp.Workbooks.Open(  
        @"C:\Users\Administrator\Desktop\123.xlsx",  
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
        Type.Missing, Type.Missing, Type.Missing, Type.Missing);  
  
    // Get the first worksheet.  
    // (Excel uses base 1 indexing, not base 0.)  
    Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];  
  
    // open print dialog  
    bool userDidntCancel =  
    excelApp.Dialogs[Microsoft.Office.Interop.Excel.XlBuiltInDialog.xlDialogPrint].Show(  
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);  
  
    // Cleanup:  
    GC.Collect();  
    GC.WaitForPendingFinalizers();  
  
    Marshal.FinalReleaseComObject(ws);  
  
    wb.Close(false, Type.Missing, Type.Missing);  
    Marshal.FinalReleaseComObject(wb);  
  
    excelApp.Quit();  
    Marshal.FinalReleaseComObject(excelApp);  
}  

Best Regards,
Jiale

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.