XLS READER

sandeep87

• October 18, 2009 00:00

• Answered

Follow

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

• 

  avackova

  • October 19, 2009 06:59

  0

  Comment actions Permalink

  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.
• 

  sandeep87

  • October 19, 2009 14:22

  0

  Comment actions Permalink

  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
• 

  avackova

  • October 20, 2009 07:39

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.