Click here to Skip to main content
14,601,062 members
Rate this:
Please Sign up or sign in to vote.
See more:
Reading the sentence from excel file and write in TSV in same style.

For reading sentence using :-
ExcelReaderFactory.CreateOpenXmlReader(fileContent.InputStream); 
method
e.g.
input :-Hello , How are you
Output :Hello , How are you
The format(style) of text should be remain same as input.

What I have tried:

Gone through some articles from google but not able to resolve my issues.
Posted
Updated 15-Dec-19 0:57am
v2
Comments
CHill60 23-May-17 9:04am
   
By "TSV" do you mean "CSV" - i.e. a comma-separated text file?
If so then you cannot copy the formatting.
If TSV does not mean CSV then what is it exactly?
Sudheer Kumar Tiwari 23-May-17 23:59pm
   
Hi CHill, It's TSV( Tab Separated Values) tab-delimited file
CHill60 24-May-17 5:38am
   
Same answer I'm afraid. TSV and CSV are just plain text files and cannot store the formatting that was present in the excel spreadsheet.
A method I've used in the past has been to use XML to represent the data columns and included formatting descriptions within the XML nodes. I'm not sure that that would lend itself to picking up formatting at the cell level though. Why not just leave it as an Excel file if you want the formatting?
Maciej Los 26-May-17 11:00am
   
My virtual 5!
[no name] 23-May-17 9:27am
   
Text is neither bold nor underlined.
Richard MacCutchan 23-May-17 9:30am
   
No? :)
[no name] 23-May-17 13:24pm
   
Nyet
Sudheer Kumar Tiwari 24-May-17 0:03am
   
Where ?
Richard MacCutchan 23-May-17 9:30am
   
The text format is separate from the actual text, and cannot be read directly through a stream. You need to check the documentation of the library you are using to see how to extract format information.
Sudheer Kumar Tiwari 24-May-17 0:01am
   
Thanks Rechard. doing same. but not got the expected results.
Richard MacCutchan 24-May-17 2:57am
   
"not got the expected results."
Well we have no idea, and cannot guess, what that is supposed to mean. If you want help with your problem then please edit your question(use the Improve question link), show the failing code, and explain exactly what is happening.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

I'd suggest to read the documentation from: GitHub - ExcelDataReader/ExcelDataReader: Lightweight and fast library written in C# for reading Microsoft Excel files[^] or ask a question on that GitHub repository.
   
Comments
Richard MacCutchan 15-Dec-19 9:17am
   
A little late Maciej. :(
Maciej Los 15-Dec-19 10:52am
   
Oouupss...
I paid not much attention on the date of creation of question...

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100