Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic Input - Loading XLSB file Error as Target file may be corrupt

Sri9
8 - Asteroid

Any solution in this is much appreciated?

I am not able to open XLSB file in Dynamic Input tool. Dynamic Input (16) Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

9 REPLIES 9
BrandonB
Alteryx
Alteryx

Do you already have this driver installed to read in xlsb files? https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

This is a requirement to read xlsb files as seen on our data sources page: https://help.alteryx.com/current/designer/data-sources

Sri9
8 - Asteroid

Yes, installed the driver and able to import XLSB on Input tool but from Dynamic Tool i am not able to import XLSB.

BrandonB
Alteryx
Alteryx

I wonder if a macro based approach might help you here. Take a look at the following article which has a macro you can use for bringing in multiple xlsb files: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...

Sri9
8 - Asteroid

Finally got a solution from Alteryx Support

Sri9_0-1597217186337.png

 

Plus the File path string should be 

[FilePath] +"|||"+ "`" + [SheetName] + "$`"

BrandonB
Alteryx
Alteryx

That will do the trick! Glad you got it figured out.

Sri9
8 - Asteroid

Its loading fine if the file is in Temp or local PC. But, looks like if I load the file from SharePoint and Shared network drive i get error " Dynamic Input (30) Error opening table: Microsoft Access Database Engine: System resource exceeded.\3035 = -66192371. Any idea why?
"

praneshsapmm
8 - Asteroid

Hi Sri9,

 

I have the same issue as you mentioned in this thread . In spite of all the steps followed , i still have the below issue . 

 

 Tool #1: Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

 

Can you help . 

 

Full Path String : [FullPath]+"|||"+"Shee1"+"$"

 

Thanks
 

Sri9
8 - Asteroid

Hi Pranesh,

PLease note after the $ symbol there is a ` added there.

 

[FilePath] +"|||"+ "`" + [SheetName] + "$`"

THanks

Sri9

---------------------------

 

Hi Sri9,

 

I have the same issue as you mentioned in this thread . In spite of all the steps followed , i still have the below issue . 

 

 Tool #1: Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

 

Can you help . 

 

Full Path String : [FullPath]+"|||"+"Shee1"+"$"

 

Thanks

praneshsapmm
8 - Asteroid

Hi ,

 

I tried this . Still the same issue. 

 

 Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

 

Changed full path : [FullPath]+"|||"+ "`" + "Sheet1" + "$`"

 

 

Thanks.

Labels