Excel reading onlyrows and columns that contains text

Question

0.00/5 (No votes)

See more:

Hi Guys,

I am accessing Excel sheet from my C# Code.
I am storing all rows in DataSet.

But I have a problem.
After getting entire Excel contents in DataSet I am getting some empty rows also.
Is there any short cut to remove that empty rows in DataSet?
I can use loop or I can dump into other Dataset but other than this any method.

I'm using Ms-Sql

[edit]Spurious code block removed, spelling and some capitalisation - OriginalGriff[/edit]

Posted 15-Feb-11 23:09pm

ranjeetkr01@hotmail.com

Updated 15-Feb-11 23:29pm

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 16-Feb-11 5:29am

Edited for Grammar and Readability.

2 solutions

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)

OriginalGriff · Answer 1 · 2011-02-15T23:32:00

Solution 1

Hang on a moment: Your name is Alim Basha and you posted exactly the same question on MSDN in 2007.
http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/0385aa4a-1db2-41e6-8431-f0a2835ae317[^]

And when I say "exactly the same question" I mean just that: capitalisation errors, spelling error, exact wording and format, the lot.

What is going on here?

BTW: change your username: never post your email to a public forum.

Posted 15-Feb-11 23:32pm

OriginalGriff

Comments

Indivara 16-Feb-11 7:42am

Just a minute Sherlock, how do you figure its the same person?
(I don't see the connection... am I blind?)

OriginalGriff 16-Feb-11 8:25am

Would you copy-and-paste that question? Or write your own if you have the same problem? Or even - shock idea - read further down past the original question for the solutions? :laugh:

Ashishmau · Answer 2 · 2011-02-16T18:12:00

Solution 3

while selecting data from excel remove empty rows by select query giving condition like columnname <>string.Empty

Posted 16-Feb-11 18:12pm

Ashishmau

Updated 16-Feb-11 18:14pm

v2