unable to copy formatted excel data to new excel using a third party DEVX grid

Question

0.00/5 (No votes)

See more:

I'm generating a formatted xlsx in a window app coded in vb.net.
after closing the app When i tries to copy data from generated formatted excel to new excel (created using right click->new excel document). Only text get copied without the formatting. Now we can copy data with formatting if we merge the formatting of the new excel with the copying excel. But I was wonder is there any way that we wouldn't need to merge style every time we copy.
Please suggest some solution for this..

[EDIT]This section was moved from comment - LOSMAC[/EDIT]
I'm using a third party DEVX grid to generate excel data using this method. first i need to fetch the dataset then i programmatically binding it with the grid then simply calling following method, gives me custom formatted excel

VB

gvRuleLineUnBand.ExportToXls(_tempFileLocation, options)

Posted 24-Oct-11 1:44am

Sanjeev Majgotra

Updated 2-May-12 10:27am

Maciej Los

v2

Add a Solution

Comments

Philippe Mori 24-Oct-11 8:18am

You don't say how you create the first file... And why not copy the whole file?

Sanjeev Majgotra 24-Oct-11 11:39am

I'm using a third party DEVX grid to generate excel data using this method.
first i need to fetch the dataset then i programmatically binding it with the grid then simply calling following method, gives me custom formatted excel
gvRuleLineUnBand.ExportToXls(_tempFileLocation, options)

chandanadhikari 22-Nov-11 11:54am

i do not know if you are already doing this but i would first make a blank excel sheet with whatever columns etc i want and then use it as a template to fill the data in .Create a copy of this template at runtime and fill in the data and the template remains unchanged for further use.
just a suggestion.....

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)

wizardzz · Answer 1 · 2012-05-02T11:12:00

Solution 1

I would contact the support for the 3rd party control you are using. They will typically be able to help more than us.

Posted 2-May-12 11:12am

wizardzz