I have a task to read a excel file using asp.net.

Question

Hello,
I have a task to read a excel file using asp.net. My problem is that I have excel file containing text in different fonts like some text in "Times New Roman" and some text in "Shri Dev 078e". I didn't get any solution how to achieve the desire result. Example the below text:

eãX "OFFICES" Ho$ Ajam| H$mo AbJ-AbJ {H$VZo VarH$m| go gOm`m Om gH$Vm h¡?

In the above text containing font "SHREE-DEV-0708E" as well as "OFFICES" in Times new roman.
when i store that text in my db i have to store the text with font name as well.

Is their any logic to put some kind of special character within start and end of the word which is in different font.

Abhijit Patil · Answer

Hey MB Change the DB filed type is NVarchar ,Ntext .and when you insert into the database the use the N Sufficex to the control data. eg insert into values(N'"+textbox1.text+"') Hope you understand. thank and regards, Abhijit Patil http://dotnetbyabhipatil.blogspot.in

M B · Answer

Thanks Abhijit, I already store that text in my database but my actual problem is that i want to add some special character (before(!!) and after (!!!)) to the words that is in another font. for example :- eãX OFFICES Ho$ Ajam| H$mo AbJ-AbJ {H$VZo VarH$m| go gOm`m Om gH$Vm h¡? above line in SHREE-DEV-0708E font but that text in "OFFICES" (bold text) in Times New roman font. and I want below text as an result. eãX !! OFFICES !!! Ho$ Ajam| H$mo AbJ-AbJ {H$VZo VarH$m| go gOm`m Om gH$Vm h¡? I want to add special character double before the starting the word (word in Times New Roman Font) (!!) and triple after ending the word (word in Times New Roman Font)(!!!) by coding. Hope now you understand my problem.

I have a task to read a excel file using asp.net.

Answers (2)