Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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