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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
