Data Loss from Excel
-
Hello I'm reading an excel file, Now the problem is that when reading it make some cells blanks. THe reason is that if the first column value is of type text ("0.98ad") then it'll show only data like this format or when it is numeric (0.8) then it shows only numeric values. Any idea about it? Thanks
Syed Shahid Hussain
-
Hello I'm reading an excel file, Now the problem is that when reading it make some cells blanks. THe reason is that if the first column value is of type text ("0.98ad") then it'll show only data like this format or when it is numeric (0.8) then it shows only numeric values. Any idea about it? Thanks
Syed Shahid Hussain
The Excel driver determines type of a the column by scanning first few rows. Later it ignores all data not matching this type. I don't now a workaround for this other that preparing the excel file before (convert all data in the workbook to strings) or use an application code to import data (automating Excel or using a component like Aspose.Cells)
Pavel