Forum Discussion
Helper IIHexadecimal Value is an Invalid Character from Folder Source (using excel files)
One or more Excel files have xml problems. You can remove all files except one and refresh your query. Then add 2nd file and refresh query. This way, you will be able to know which all files have problems.
You will need to open those files in Excel and save again. Saving again will correct xml problems.
Also, whosoever is sending these files to you, ask the person to generate Excel file in a right way with correct xml. This happens when 3rd party tools/codes are used to generated Excel and they don't generate Excel files with correct xml.
Most Valuable ProfessionalOne or more Excel files have xml problems. You can remove all files except one and refresh your query. Then add 2nd file and refresh query. This way, you will be able to know which all files have problems.
You will need to open those files in Excel and save again. Saving again will correct xml problems.
Also, whosoever is sending these files to you, ask the person to generate Excel file in a right way with correct xml. This happens when 3rd party tools/codes are used to generated Excel and they don't generate Excel files with correct xml.