How to read bold and underline words from excel file

Question

1.00/5 (3 votes)

See more:

Reading the sentence from excel file and write in TSV in same style.

For reading sentence using :-

C#

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 23-May-17 1:51am

Sudheer Kumar Tiwari

Updated 15-Dec-19 0:57am

CHill60

v2

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Answer 1 · 2019-12-15T00:58:00

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.

Posted 15-Dec-19 0:58am

Maciej Los

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...