asked on 5/21/2021

Use VB.NET to export a Crystal Report to Excel with original report formatting.

I want to use VB.NET to export a formatted Crystal Report to a Microsoft Excel worksheet.

The CrystalReportViewer offers 3 options to export to Excel. I would like to export using the Microsoft Excel (97-2003)(*.xls) format programmatically.. I do not want to do a data only export. Thanks!

Visual Basic.NET Crystal Reports Microsoft Excel Microsoft Office

Last Comment

Ron Malmstead

5/21/2021

Ron Malmstead

5/21/2021

Found this code snippet on the webs.

Protected Sub btnExcel_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim Report As ReportDocument = New ReportDocument()
    Report.Load("d:\Test_WebApplication\EmployeeInfo.rpt"))
    Report.SetDatabaseLogon("sa", "password", "Rakesh-PC", "SqlServerTech")
    Response.Buffer = False
    Response.ClearContent()
    Response.ClearHeaders()
    Report.ExportToHttpResponse(ExportFormatType.Excel, Response, True, "EmployeeInformation")
    Response.[End]()
End Sub

Open in new window

As far as what I've read, it will preserve formatting, except it will omit lines and boxes.

Eric Burton

5/21/2021

ASKER

Thanks Ron! It looks like the code is from an ASP.NET app - will it work for the desktop also?

ASKER CERTIFIED SOLUTION

Éric Moreau

5/21/2021

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Eric Burton

5/21/2021

ASKER

Thanks Eric! Are you suggesting from the article that the following would work:

ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, strOutputPath)

Open in new window

SOLUTION

Ron Malmstead

5/21/2021

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial