How to convert spreadbuilder workbook object to Microsoft interop excel workbook with out saving the file?

Question

0.00/5 (No votes)

See more:

Hi,

We have a windows forms aplicaition written in VB.Net. In the application, we are exporting data from the database into an Spread Builder Workbook and we are saving that workbook on local drive. Now i don't want to save the workbook on local drive and i want to open it for reading to the user. For this i want to do open the workbook of spreadbuilder type into microsoft excel type. but I am unable to convert this casting.

The error message that i am getting is "Unable to cast object of type 'DataDynamics.SpreadBuilder.Workbook' to type 'Microsoft.Office.Interop.Excel.Workbook'."

Can any one suggest me how to convert the datadynamics.spreadbuilder.workbook type to Excel workbook type or is there a way to open the spreadbuilder workbook without saving?

Any suggestions will be appreaciated.

Thanks for your support.

Posted 19-Nov-13 19:26pm

VNMRao

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2013-11-20T05:02:00

You really have no choice but to save and reload it, unless SpreadBuilder exposes some method to do the conversion for you.

You have no shot at casting or converting the one object type to the other because neither of them is in the others inheritence chain.

Your only other method is to write a conversion yourself where you take the properties of one object and copy the values into the properties of an instance of the other. You'll, of course, have to take into account any child object and children of those children.