How to convert an Excel sheet into a pdf file in a VB2008 web application ?

  • Thread starter Thread starter Gilbert Tordeur
  • Start date Start date
G

Gilbert Tordeur

Hello !

My web application generates an Excel sheet on the server. Then I would like
to generate a pdf file from this Excel sheet. How can I do ?

Thank you for your help,
Gilbert
 
Hello !

My web application generates an Excel sheet on the server. Then I would like
to generate a pdf file from this Excel sheet. How can I do ?

Thank you for your help,
Gilbert
Click to expand...

Yikes!

My only recommendation would be to use Siberix's report writer to
generate the PDFs separately from Excel. Siberix is not free, though
very inexpensive imo, but it's a C# library and is extremely flexible
and easy to use. This would require you to separate the PDF creation
from the Excel creation, but imo this is a good thing (especially if
you're using an MV? pattern where the views are completely separate
from your business logic).

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/
 
Seth,
Thank you for this information. You are right saying that $300 is not
expensive for a company. I will investigate.

By the way, which reader are you using to access this newsgroup ? I am using
Outlook Express 6 under Windows XP and I do not find :
- how to download newsgroup messages automatically every n minutes,
- how to prefix the original message with "> ".

I can do that with Outlook XP, but this program cannot read news.

Regards,
Gilbert

"rowe_newsgroups" <[email protected]> a écrit dans le message de (e-mail address removed)...
Hello !

My web application generates an Excel sheet on the server. Then I would
like
to generate a pdf file from this Excel sheet. How can I do ?

Thank you for your help,
Gilbert
Click to expand...

Yikes!

My only recommendation would be to use Siberix's report writer to
generate the PDFs separately from Excel. Siberix is not free, though
very inexpensive imo, but it's a C# library and is extremely flexible
and easy to use. This would require you to separate the PDF creation
from the Excel creation, but imo this is a good thing (especially if
you're using an MV? pattern where the views are completely separate
from your business logic).

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/
 
Gilbert said:
By the way, which reader are you using to access this newsgroup ? I
am using Outlook Express 6 under Windows XP and I do not find :
- how to download newsgroup messages automatically every n minutes,
Click to expand...

- Edit your properties for your news server account (Tools / Accounts / News
tab).

- Check the "Include this account when checking for new messages" box

- Configure Outlook Express to automatically check for new messages every
(n) minutes in Tools / Options / General. This will of course download your
email every few minutes as well as news posts, but that's the only way to do
it.
- how to prefix the original message with "> ".
Click to expand...

- Select Tools / Options / Send tab.

- Ensure News Sending Format is set to Plain Text.

- Click Plain Text Settings for News Sending Format and set to Indent the
original text with > when replying or forwarding.

HTH,
 
Seth,
Thank you for this information. You are right saying that $300 is not
expensive for a company. I will investigate.

By the way, which reader are you using to access this newsgroup ? I am using
Outlook Express 6 under Windows XP and I do not find :
- how to download newsgroup messages automatically every n minutes,
- how to prefix the original message with "> ".

I can do that with Outlook XP, but this program cannot read news.

Regards,
Gilbert

"rowe_newsgroups" <[email protected]> a écrit dans le message de (e-mail address removed)...




Yikes!

My only recommendation would be to use Siberix's report writer to
generate the PDFs separately from Excel. Siberix is not free, though
very inexpensive imo, but it's a C# library and is extremely flexible
and easy to use. This would require you to separate the PDF creation
from the Excel creation, but imo this is a good thing (especially if
you're using an MV? pattern where the views are completely separate
from your business logic).

Thanks,

Seth Rowe [MVP]http://sethrowe.blogspot.com/
Click to expand...

I use groups.google.com - no "true" news reader.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/
 
Hello !

My web application generates an Excel sheet on the server. Then I would like
to generate a pdf file from this Excel sheet. How can I do ?

Thank you for your help,
Gilbert
Click to expand...

Even if you're using Express Edition, you can try to add reference to
the type library called "Microsoft Excel X.0 Type Library" where X is
your library's version depending on Office version you have.

Hope this helps,

Onur Güzel
 
Even if you're using Express Edition, you can try to add reference to
the type library called "Microsoft Excel X.0 Type Library" where X is
your library's version depending on Office version you have.

Hope this helps,

Onur Güzel
Click to expand...

Minor correction:
The COM full name must be "Microsoft Excel X.0 Object Library". Also
as i don't have PIAs of Office Interop, i have "Microsoft.Office.Core"
instead of "Microsoft.Office.Interop" and i wonder if absence of PIAs
is the reason of DLL name difference.

Thanks,

Onur Güzel
 
Back
Top