Page 1 of 1

Error reading an excel data file

Posted: Thu Jan 22, 2015 10:26 pm
by charikrv
I have a graph that reads an excel data file. The input xlsx has only one sheet of data. The graph works fine in my desktop computer. But when I ftp it to the Linux server and run it, it throws the following error:
Node READ_PART_SHEET error details:
Element [READ_PART_SHEET:Read Part Sheet]-Component pre-execute initialization failed.
....
... the file will be ignored caused by: There is no sheet conforming sheet pattern
My Desktop Version: 3.5.1.018
Server version 3.3.1.11

I tried using the XSL reader. It did not work. I changed it to spreadsheet reader. Still, it gives the same error.

What is causing this error?
Thanks
Chari

Re: Error reading an excel data file

Posted: Fri Jan 23, 2015 10:09 am
by kubosj
Hi Chari,

Please do not mix Server and Designer version - such combination is not supported because graphs are not compatible. Also Server API changes during time. So that may be one issue.

Other problem may be field "Sheet" of SpreadsheetReader. There you can specify which sheets should be read (please consult documentation). Maybe your "Sheet" does not correspond with sheet name in file. If I do that intentionally I get same exception.

I hope this helps.