Hello Sharad Gawade, Your understanding is correct. Excel is not a supported sink file format for blob storage. But In general, using a Binary dataset both in the source and sink in the copy activity can move the files without any changes. As per the error message, xlsx file/content cannot be identified by Excel (NPOI SDK). Please verify that the source file you are trying to copy is in the .xls or .xlsx format. And please verify the source file is not corrupted or password protected. also please try with dataflow to see if you are able to copy.
How to read .xls file with content type application/octet-stream using copy activity
Sharad Gawade
0
Reputation points
Hi Team,
I am not able to copy .xls file which having content type as application/octet-stream.
Can you please help me to resolve this issue without changing file extension.
1 answer
Sort by: Most helpful
-
BhargavaGunnam-MSFT 26,316 Reputation points Microsoft Employee
2023-04-06T19:15:55.6933333+00:00