community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Data Issue With Locked Excel Sheet

Meteor

Hello All,

 

I have the following issue while working with locked excel sheets.

 

Application generated locked excel sheets are having string values visually, but when trying to open the sheet with Input Data Tool they either have Null values are invalid date values but read as String.

 

 

Quasar
Quasar

Hello @Thordust16 would you mind sending a sample of the problem that you are facing?

Meteor

HI 

 

Below are the snapshots of the issue I'm facing

 

Actual Excel data

 

Capture14.PNG

 

Data shown in Input Data Tool Preview

Capture12.PNG

 

Error message

 

Capture13.PNG

 

Data Type

Capture15.PNG

 

Quasar
Quasar

Locked in the sense protected with password? @Thordust16

Meteor

Yes the data sheet is password protected and auto generated by another tool.

Labels