Click here to Skip to main content
15,885,914 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I am importing excel data into my db. And I would like to export that again to excel. While importing I have few columns formatted in excel. So I store it as rft format text in db. For an Ex:- the content looks sth like this:
({\rtf1\deff0{\fonttbl{\f0 Times New Roman;}{\f1 Calibri;}}{\colortbl\red0\green0\blue0 ;\red0\green0\blue255 ;}{\*\listoverridetable}{\stylesheet {\ql\cf0 Normal;}{\*\cs1\cf0 Default Paragraph Font;}{\*\cs2\sbasedon1\cf0 Line Number;}{\*\cs3\ul\cf1 Hyperlink;}}\sectd\pard\plain\ql{\f1\cf0 Who was an american printed the very first step in Moon?}{\cf0 \tab }\par})


I am able to read the text as rtf format and store it in db. But when I try to export it back to excel, I am not able to convert this rft text into formatted excel cell value.

Note:
I am using Spire.XLS dll to import and export.


Kindly help me!
Posted
Updated 27-Mar-14 2:31am
v2
Comments
Vicidev 9-Jul-14 9:16am    
Have you or somebody else ever found a solution for this problem? I also just want to copy or write rtf text from c# to an excel cell without loosing the format.
I really need this functionality. So please post if you have a solution for this!!! Thanks and looking forward hearing from you!!

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