How To convert particular row and column of excel to dataset

Question

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

 

 

I have used this code to convert excel to dataset.excel have(1,048,576 rows by 16,384 columns) in that time (Exception of type 'System.OutOfMemoryException' was thrown.) exception is thrown so i want to convert only 1000 rows and columns to dataset how to do it.

i understand to delete the empty columns and rows using (ctrl -) key but the user is not well knowledged in excel so i want to convert only 1000 rows and columns how to do it.

Answer 1

AVINASH can i implement this in wpf webbrowser control and how??

Answer 2

I AM USING WEBBROWSER CONTROL IN WPF .IS IT POSSIBLE TO LOAD THE HTM ELEMENT WHEN I CLICKED ON ANCHOR TAG??

Answer 3

 $('a').click(function(e)

{      

   e.preventDefault();   

   $("#content").append('<div>Test Content</div>');

 });

OR 

 $('a').click(function(e)
{ 
   e.preventDefault(); 
   $("#content").load('test.html');
 });
and test.html have your own html which you want to load in page

Answer 4

You Want Load Html Content Of Div when you click on anchor tag if this right

 

so you can do with jquery using display none and block property 

Answer 5

sorry it is official...i only want how to do that 

Answer 6

Can You Share Your Code