Export of WebReport to CSV/Excel

Hi,I exported my WebReports as a csv file. It opens fine in Microsoft Excel 2000, but in Excel 2003, instead of displyaing the records in teh report, the html is displayed instead. Is there a setting in Excel 2003 that needs to be setup in order to properly read the csv file? Thanks!

Find more posts tagged with

Comments

Greg_Petti_(gpetti_(Delete)_2694690)

Hi Michelle,I have Excel 2003 and it works for me. Is it possible that when you install 2003 your file associations are changed? For example in Windows XP you would look from a Windows explorer window under Tools->Folder Options->File Types->CSV to make sure that this extension is set to bring up Excel. Greg Petti

Greg_Petti_(gpetti_(Delete)_2694690)

Is the report view formatted as csv?On re-reading your query I realize that your file type setting must be correct as you are getting Excel 2003 to come up. With this in mind I think that the output from your webreport is probably HTML instead of CSV. The WebReport export option allows the mime type to be set for the file to be exported which influences the opening of the application but does not force a conversion from HTML to CSV. If you want the output to be formatted as CSV you need to use a reportview which is outputting the data in the appropriate format. There is an example default reportview in version 2.0.1 which you can use and or modify. Also if you save the export as a .XLS file (html mime type) and then open it with Excel it will convert it for you. By the way, there is a WebReports discussion group which you can use for WebReports specific questions:https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3684835&objAction=view&sort=NAME mailto:webreports@elinkkc.opentext.com