As you said i have stored the excel rows and columns in a dataset.Now i want to run a select a Query in dataset but it stores all the excel rows into dataset rows .
I want first excel rows should be the header of the dataset. Is it possible ?
Here is my code .
FileStream fstream = new FileStream(@“C:\AsposeTest.xlsx”, FileMode.Open);
Workbook workbook = new Workbook(fstream);
Worksheet worksheet = workbook.Worksheets;
DataTable dataTable = worksheet.Cells.ExportDataTable(0, 0, 100, 30);
DataSet ds =new DataSet();
ds.Tables.Add(dataTable.Select(" [EmpID] <> null").CopyToDataTable());
thank you so much
Now it is working fine.
Is it possible to get excel sheet name collections ?