This is web application. I hava a form through which I enter some data and on that basis agent runs and fetch data from oracle and export to excel. Now this excel file is creating on the server as application resides on server. Is it possible that this excel file create on client machine. What are the ways?
Thanks
Subject: RE: Excel Report --Very Urgent
Have you tried with Office Web Components (OWC). You can do embedded Spreadsheets, PivotTables and Charts using OWC on a web page. Mind you this only works in ie 4> as far as I know. Please follow this link which might help you a bit more.
HTH
Sai
Subject: RE: Excel Report --Very Urgent
Is it possible without OWC? Is there any code or option which opens the excel sheet on the client machine but not on server? If there is a way then please let me know?
Thanks for helping.
Thankyou very much
Subject: RE: Excel Report --Very Urgent
I’m sure you haven’t done any searches on the 4 and 5 forum. Please do search for “Web and Excel” on both the forums and there are loads of posts relating to your request. Also try this link. This is one of the possible options for generating excel report on the client…
Sai
Subject: RE: Excel Report --Very Urgent
did not find anything write. I am using
Print “Content-Type:application/vnd.ms-excel” tries to transfer file to client and gives error and it does not open the excel on client machine.
Also it is opening the excel file on the server.
Is there any other way?
Subject: RE: Excel Report --Very Urgent
I am sorry I am not able to understand. Can anyone please give me code or an option which I have to enable.
Subject: RE: Excel Report --Very Urgent
There’s an article on how to use owc in domino on the eview website and also a sample database. Go to the following website and search for owc and download the nsf file and have a look which might help you.
HTH
Sai
Subject: RE: Excel Report --Very Urgent
Just send the results back as .csv this will be opened by the browser in whatever spreadsheet the user has, not just Excel.
Subject: Cunning Plan
since most web function run on server, your problem is not unexpected.
However why dont you accept this as teh starting point but extend your current code
the user enters data through a form - and then submits it?
That process has created an unsaved NotesDocument
I assume the Web Query save reads the parameters, & build the file on the server
Suppose you attach the XLS to that document, save it
and then as the next page displayed in the browser client open that document (possibly suing another form )
the user can then detach his results to wherever they want in the LOCAL file system.
Old result documents can be kept for reference or cleaned up at a later date.
(if needed the “results” document could be separate to the one where the user enters parameters.
It could even be in another NSF file)
Subject: RE: Cunning Plan
Basically, I have a form which has a field which has FirstName, LastName. If user select firstname then it will run agent and it will fetch the data firstname wise and export to excel but if user select lastname then it fetch data from oracle lastname wise. This everything is doing fine but it is executing on server not on client.
Subject: RE: Cunning Plan
It opens the new excel sheet and then populate the data and now if user want then can save that sheet. This is functioning but not on client side. I do not want to save and send file as attachment. I want that it opens the new sheet and populate data at client side not at server side. Is there any way to that?
Subject: No need to SEND the file as such
create it
attach it to a document
and make the next page a Notes URL to direcly open that attachment
i.e http:// sever etc /0/Document unid/$file/attachment filename.xls
I believe this will launch LOCAL excel on teh client
but with data from the file stored as an attachment on the server
it can be up to the user to save the fiel to his C: etc.
Subject: RE: No need to SEND the file as such
Is there any other way without attaching file to the document, it will just open excel locally and populate the data from oracle.