Export to excel and open the excel on user machine

[amars]

Hi all,

I wish to do an export to excel on a button click.

On our server we do not have excel installed thus I am using ExportBiff.

So the two questions that I have are

1. Putting ExportBiff without a path, i.e. just a filename, will it gets saved in current path of user or the server.

2. How can I open the file for user to view, without having excel on the server and on the user machine it is present?

The user doesn't wish to export it using export to excel (as 4 charts are there), so a kind request not to suggest that.

Kindly suggest. Thansk in advance.

Amar