Click here to Skip to main content
15,904,023 members
Please Sign up or sign in to vote.
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
Updated 2-May-12 10:27am
v2
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

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

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900