In the ActiveX there is an option to export the report to excel as is or to export only the data.
this option does'nt realy works for me.
Does any one can explain how can I export only the report data to Excel
tedi1, it would be nice to see some code (I assume VB?), but here are a few things that may help you.
Make sure you have set the DiskFileName, FormatType, and DestinationType parameters before calling the Export function.
The DiskFileName is pretty easy to do, just pass a string of the filename you want.
The FormatType should be crEFTExcel80, or something similar.
The DestinationType should be crEDTDiskFile.
If I understand your question, your problem may be in the Format type. If I have not understood your question, please be more descriptive.
I'm using the sample activex given by seagate.
When I run the "SmartViewerActiveX.asp" they give there is an option to export the report. Among the option are two options to export to Excel. One is "excel (data only)" and the other is "Excel". When the user chose the first option not only the data is exported but also the design of the report. The second option gives the same kind of result: data + design.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.