# Xls reader

**URL:** <https://forum.cloverdx.com/t/xls-reader/611>\
**Category:** CloverDX Platform\
**Created:** [October 18, 2009, 12:00am UTC](https://forum.cloverdx.com/t/xls-reader/611 "2009-10-18T00:00:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandeep87](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@sandeep87](https://forum.cloverdx.com/u/sandeep87)\
**Post date:** [October 18, 2009, 12:00am UTC](https://forum.cloverdx.com/t/xls-reader/611/1 "2009-10-18T00:00:00Z")

</div>

Hello,

I am using XLSReader component to read data from XLS file.

when i give the location of file and other options like parser to XLS instrad of AUTO and other options remaining same.

i also created metadata from XLS file and connected to another component.

Then i use view data by right clicking the node. i used text format not grid while view data ,I get a unreadable format of something.

so can anybody help me in reading XLS file.

I also tried matching rows also.

Thanks in advance

Regards,

Sandeep  
Waiting for reply

---

<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:** [October 19, 2009, 6:59am UTC](https://forum.cloverdx.com/t/xls-reader/611/2 "2009-10-19T06:59:43Z")

</div>

Hello Sandeep,  
text view is only preview of a flat file, so you see the file like it looks in real. To see the data, you have to choose grid view mode. Than data are parsed as defined in metadata and displayed on the screen.

---

<div class="post-metadata">

**Author:** ![sandeep87](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@sandeep87](https://forum.cloverdx.com/u/sandeep87)\
**Post date:** [October 19, 2009, 2:22pm UTC](https://forum.cloverdx.com/t/xls-reader/611/3 "2009-10-19T14:22:34Z")

</div>

i tried grid view… i did not get any output there…i got a blank page or error while i choose grid view…can u give me a sample graph which successfully reads the xls data

---

<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:** [October 20, 2009, 7:39am UTC](https://forum.cloverdx.com/t/xls-reader/611/4 "2009-10-20T07:39:24Z")

</div>

What was the error message? If you create the metadata from xls file by “Extract from XLS(X) file” wizard, view data should work without any error.
