Export to Excel

Posted on 2005-04-14
Last Modified: 2008-03-06
I used VB6 to export the Crystal Report into Excel, but I got my export in Excel as a picture. There no columns or rows. Which code should I use to export the Crystal into real excel format?
Here is code that I used:

With crReport.ExportOptions
     .DestinationType = crEDTDiskFile
     .FormatType = crEFTExcel97
     .DiskFileName = gsExpFilePath
     .ExcelUseConstantColumnWidth = True
    '.ExcelConstantColumnWidth = 50
     .ExcelExportAllPages = True
 End With

Appreciate your time, DDB
Question by:DDB
    LVL 100

    Accepted Solution

    Which version of Crystal?

    CR9 added a "Data only" capability.  Otherwise it is much more WYSIWYG.

    For help look at

    LVL 4

    Assisted Solution

    LVL 100

    Expert Comment

    My answer {13784803} or jrmn's {13791608} should have solved it.

    LVL 4

    Expert Comment

    yes, I also think so...

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now