DSXchange

I am trying to read multiple spreadsheet using unstructured stage but I am getting an error."Unstructured_Data_0: An error occurred when reading the specified file" If I click view it is opening blank page

if I have single spreadsheet excel. It is reading fine. any set up is missing?

Please help

How did you configure the stage? Anything like what is detailed here?

Input File : FileName.xls

Range Option: Specify the start row
Range expression: Sheet1!A1:K23
Sheet names to skip: 'Sheet2','Sheet3'
Column header: First Row of data ranges

when I click load it is giving error "An error occurred when reading the specified file"
View is opening the empty excel sheet

I don't work with this stage so not sure how much help I can be but... let's start by clarifying what you mean by "read multiple spreadsheet" and "single spreadsheet excel". Are you talking about reading multiple files or a single spreadsheet file and you need data from multiple worksheets within it?

FYI, the article was about the latter.

If you want to read multiple Excel files by using one unstructured stage, you need to use a wild card. So if you have files like this:

File1.xls
File2.xls
File3.xls

you need to put:

File*.xls

in the "File name" box after clicking the Configure button. In that case, you also need to check "Use template file for design time" and specify a "Template file name:". All the files need to be just like the template file in structure.