# XLS null record

**URL:** <https://forum.cloverdx.com/t/xls-null-record/524>\
**Category:** CloverDX Platform\
**Created:** [May 19, 2009, 12:00am UTC](https://forum.cloverdx.com/t/xls-null-record/524 "2009-05-19T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![deshartman](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/deshartman/32/87_2.png) [@deshartman](https://forum.cloverdx.com/u/deshartman)\
**Post date:** [May 19, 2009, 12:00am UTC](https://forum.cloverdx.com/t/xls-null-record/524/1 "2009-05-19T00:00:00Z")

</div>

Hi, I am reading a XLS file and writing this to a Postgres dB. The problem I have is that the last record written has a null value. I presume that this is to indicate that the last record has been reach. Since there is a varying number of records, I cannot set the last record value.

Is there any way I can avoid this last “null” record being written?

Thanks  
Des

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 19, 2009, 7:43am UTC](https://forum.cloverdx.com/t/xls-null-record/524/2 "2009-05-19T07:43:56Z")

</div>

Hello,  
you have empty line in your xls file probably, that is read by clover (manualy removed?). You can put ExtFilter component after reader that allow to pass not null records only.

---

<div class="post-metadata">

**Author:** ![deshartman](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/deshartman/32/87_2.png) [@deshartman](https://forum.cloverdx.com/u/deshartman)\
**Post date:** [May 19, 2009, 11:48pm UTC](https://forum.cloverdx.com/t/xls-null-record/524/3 "2009-05-19T23:48:17Z")

</div>

Yep, that did the trick thanks  
😃