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

M B

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

M B11y ago
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.
0
Abhijit Patil11y ago
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
0