How to read particular excel document rows and columns using ASP.NET C#?

Question

0.00/5 (No votes)

See more:

I have upload one excel file with the multiple sheets.And convert the excel document to data table and validate the data table.many validation process in this case.in this excel have many heading like item number,manufacturer number ... i have validate if any empty cell in mandatory field to store the error message in one table and the finally i will show the error table and correct the cells against the heading.Now the problem is i convert the excel to data table some excel files have more rows and columns(65536,1048576 actual excel row) on that time (Exception of type 'System.OutOfMemoryException' was thrown.) exception is thrown.how to fix the particular row column of the excel document.

What I have tried:

C#

FileStream stream = File.Open(SourceUpload.Fullpath, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
ds = excelReader.AsDataSet();

Above code i can't fix the particular rows and columns. How to do it.

Posted 27-Nov-16 18:54pm

Raja Ganapathy

Updated 27-Nov-16 19:39pm

Add a Solution

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)

Mehdi Gholam · Answer 1 · 2016-11-27T19:39:00

Solution 1

Try using the 5th method from the readme :

C#

//5. Data Reader methods
while (excelReader.Read())
{
    //excelReader.GetInt32(0);
}

Posted 27-Nov-16 19:39pm

Mehdi Gholam

Comments

Raja Ganapathy 28-Nov-16 2:12am

Inside the method i give the row,column value excelReader.GetInt32(1000,1000)?

Mehdi Gholam 28-Nov-16 2:35am

Read the documentation, but I presume it is like reading from any other data source and you provide the column index as a parameter (0 in the above example = column 0 in the row just read)