3
Answers

How To convert particular row and column of excel to dataset

Raja

Raja

8y
216
1
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.
Answers (3)
0
Sourabh Choubey

Sourabh Choubey

NA 186 9.3k 7y
AVINASH can i implement this in wpf webbrowser control and how??
0
Sourabh Choubey

Sourabh Choubey

NA 186 9.3k 7y
I AM USING WEBBROWSER CONTROL IN WPF .IS IT POSSIBLE TO LOAD THE HTM ELEMENT WHEN I CLICKED ON ANCHOR TAG??
0
Avinash Aher

Avinash Aher

NA 260 594.3k 7y
 $('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


0
rajendra singh

rajendra singh

NA 382 421 7y
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 
0
Sourabh Choubey

Sourabh Choubey

NA 186 9.3k 7y
sorry it is official...i only want how to do that 
0
rajendra singh

rajendra singh

NA 382 421 7y
Can You Share Your Code