on 09-19-2008 5:18 PM
When I use the CRViewer to view a report and press the Export button, there are options for exporting to Microsoft Excel 97-2000 (XLS) and Microsoft Excel 97-2000 - Data Only (XLS).
How do these map to the ExportOptions? I'm using ExportOptions to programmatically specify the type of export for a report. I can see that there is a formatType setting with values for things like crEFTExactRichText and crEFTPortableDocFormat and crEFTExcel97, etc. Which value do I use for exporting to Microsoft Excel 97-2000 - Data Only? The documentation doesn't list a constant for a 'data only' formatType.
By trial and error I was able to determine that using crEFTExcel80Tabular will produce the Data Only output I need.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jackie,
/*Code for Export in Data only*/
{
ReportDocument Rdoc = new ReportDocument();
Rdoc.ExportToDisk(ExportFormatType.ExcelRecord,"C:\\Windows\\temp\\CrystalReport1"));
}
/*Code for Export in Excel format*/
{
ReportDocument Rdoc = new ReportDocument();
Rdoc.ExportToDisk(ExportFormatType.Excel,"C:\\Windows\\temp\\CrystalReport1"));
}
Hope that helps!!
Regards,
Shweta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.