Hi Chris
Thanks for the prompt reply I shall try and get back to you on the same. Anesh A Kurian ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Ingalls Sent: Monday, November 19, 2007 6:56 PM To: [email protected] Subject: Re: Export Form Data to Excel on Button Action ** Hi Anesh, I did this by creating a hidden view field and a button for generating excel. When you click the button, it sets the view field to a php page that uses a simple ODBC call to pull the data back from Remedy and generate Microsoft excel xml output. The following php calls will popup the Open/Save/Cancel dialog for the excel file. <snippet from php that will open the form on the button click> # This line will stream the file to the user rather than spray it across the screen header("Content-type: application/octet-stream"); # replace excelfile.xls with whatever you want the filename to default to header("Content-Disposition: attachment; filename=\"my_excel_report_$today.xls\""); header("Pragma: no-cache"); header("Expires: 0"); If you haven't done excel xml, all you need to do is create an excel file manually. Add colors, text, formatting, etc. Save it as xml, and then view it in an editor like notepad. That will show you what you need to print using php. Hope that helps, Chris. Anesh A Kurian <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 11/19/2007 07:31 AM Please respond to [email protected] To [email protected] cc Subject Export Form Data to Excel on Button Action ** Hi Listers, I require to perform a data export of a regular form to an excel sheet on click of a button. And also that it shouldnt require the user to interact other than clicking the button. I tried by using the Open window action to run a report but here again it requires the user to select a format to which the data has to be saved as. i require that the workflow automatically opens an excel sheet and displays the exported data on to the excel sheet. i would appreciate if some one could shed some light on this or if anyone has done the same to share the idea. thanks and regards Anesh __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
