Print Page | Close Window

Code for exprting to excel

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2147
Printed Date: 17 May 2024 at 9:11pm


Topic: Code for exprting to excel
Posted By: chitz
Subject: Code for exprting to excel
Date Posted: 27 Jan 2008 at 10:39pm
Plzzzzzz...Any body help me by pasting the code for exporting a CR ti excel Sheet in VB.NET. Its urgent...Thanks in advance


Replies:
Posted By: hilfy
Date Posted: 29 Jan 2008 at 9:55am
You can find sample code in the Developer Library.  For Crystal XI R2, it's here:
 
http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm - http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm
 
Click on Crystal Reports .NET SDK, then on .NET Developer Guide and API Reference, then on Tutorials and Sample Code, then Report Document Object Model.  You'll find what you're looking for there.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: IdoMillet
Date Posted: 16 Feb 2008 at 7:00pm
Please clarify: do you need to export to a new excel workbook or to an excel sheet inside an existing workbook?

- Ido


-------------
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com

Posted By: BrianBischof
Date Posted: 17 Feb 2008 at 8:52am
It's to a new workbook file.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: IdoMillet
Date Posted: 17 Feb 2008 at 9:28am
Hi Brian,

It's not clear if you providing a clarification on behalf of the original poster or if you are indicating the standard export is to a new workbook. 

There are ways to export to a sheet within an existing workbook, but it's not clear what the original question is because he used the term "excel sheet"  in his question.



-------------
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com

Posted By: BrianBischof
Date Posted: 17 Feb 2008 at 9:41am
You can export to a sheet within a workbook? Cool. I always just created a new workbook and didn't realize there was the option to use an existing workbook.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: IdoMillet
Date Posted: 17 Feb 2008 at 9:49am
It's not a built-in option.  You have to code it.  If it's something you need, you can also consider 3rd-party tools (see list at http://www.kenhamady.com/bookmarks.html).

My Visual CUT software provides that functionality (including the ability to burst a report to multiple sheets or export a report so that it creates a new sheet inside a new/existing workbook (if the sheet already exists, it can be replaced or the data can be appended to it).

- Ido


-------------
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com


Print Page | Close Window