1
Answer

How to convert only particular row and column as dataset?

Photo of Raja

Raja

8y
268
1
i have  one excel document and Multiple sheets i ahve upload and convert to data table using below code
FileStream stream = File.Open(SourceUpload.Fullpath, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);//xlsx file format
ds = excelReader.AsDataSet();
this code convert whole excel if 100000 rows is available.i want only 1000 rows and 1000 columns only how to get this one i will refer many codes i dont get any solution.is this possible how to do it.

Answers (1)

0
Photo of Sam Hobbs
NA 28.7k 1.3m 14y
More input please.
0
Photo of Dorababu Meka
NA 8.2k 1.2m 14y
What you exactly want to do on key press