Import data from excel sheet to datatable getting null values using aspose.cells

Aspose.Cells Product Family
1

iam exporting data from database to excel sheet using aspose.cells and next iam deleting some rows in excel sheet and trying to import in datatable..iam getting removed rows with null values....how to import rows without getting null values in datatable from excel sheet?

2

Hi,


If your source datatable has null values for those deleted rows then, surely Aspose.Cells would import the datatable with null values. Aspose.Cells only extract data from DataTable as it is. Please remove the null values in your source datatable by yourself and make sure that there would be no null values there.

Thank you.