Skip to Content
Jul 16, 2019 at 03:29 PM

Excel column data is not showing for few records in excel workbook format

133 Views Last edit Jul 16, 2019 at 04:50 PM 3 rev

Hi All,

We are facing data extraction issue from excel file.

Excel file has data for few records as shown below, but those values are not showing in excel workbook after creating it in excel formats in BODS. We tried almost all ways like changing code page and respective field content type but didn't work any way.

Data is loading when we change the column type manually to TEXT instead of General, but it might not work in our case because the file will generate on daily basis.

Excel Data:

BODS Excel Data:

Can anyone help us on this if anyone faced this issue.




1.jpg (53.2 kB)
2.jpg (48.8 kB)