Printing an excel file
-
Hi,
How can i print an excel file ? I need to keep cell format (color, ...)
Or can i convert the excel file to PDF ?Thx
@Zoptune
Not tried, I think you can use QPrintDialog and select selection radio button to print the selected content from excel file.
However you can print in PDF http://stackoverflow.com/questions/8296021/how-to-print-pdf-file-in-qt. -
this is a very complex task.
You need a library to render your Excel file. Once you are able to render it the printing stuff is easy.Take a look at this.
Probably the best would be to use the mentioned ActiveX (Windows only) method and let Microsoft Software do all the work.
-
Can you explain a little bit more about the QPrintDialog and the radio button, i didn't understand.
How can i convert my excel file to a pdf file ? Is there a lib for that ?
I need that process to be automatic and invisible for the user, the user just click on a "print" button.
Thx
-
this is a very complex task.
You need a library to render your Excel file. Once you are able to render it the printing stuff is easy.Take a look at this.
Probably the best would be to use the mentioned ActiveX (Windows only) method and let Microsoft Software do all the work.
@raven-worx I and thx for the reply
I have already seen the ActiveX method to deal with excel file but it seems to difficult for me ^^
Would it be more easy with Open Doc rather than Excel ?
I' trying to find an excel to pdf lib, or a command line soft that i can start with my app.
