How to print existing excel_file.xls sheet [0] with a button_print click using WPF

Question

0.00/5 (No votes)

See more:

this code I tried is printing me the evaluation warning sheet witch is always activate in any excel file when we try to open it using spire.xls

I tried to remove this unwanted sheet or hide it to print the sheet I want ,but while I'm using Spire.xls it steel shows.

I tried to activate my [0]sheet but the second steel shows !

PS:my excel file have only one sheet + the evaluation warning sheet .

how can I fixe my code to print me my excel file sheet ignoring the spire warning sheet or specify the sheet number !

Thank you for any help!

What I have tried:

private void Print_Click(object sender, RoutedEventArgs e)
{
    System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo
    {
        FileName = @"Path\To\Your\excel_file.xls",
        Verb = "Print"
    });
}

Posted 26-Nov-17 22:54pm

EM_Y

Updated 28-Nov-17 0:46am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

EM_Y · Accepted Answer · 2017-11-27T22:58:00

private void Print_Click(object sender, RoutedEventArgs e)
{
 
Excel.Application APP = new Microsoft.Office.Interop.Excel.Application();
          Microsoft.Office.Interop.Excel.Workbook wb = APP.Workbooks.Open(
     my File path",
     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];
 
    ws.PrintOut(
              Type.Missing, Type.Missing, Type.Missing, Type.Missing,
              Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}