Error 21352 accessing .xlsx file from blob storage in ADF

Mike Langlois 15

Hi there, I have a copy activity in ADF that is set to use a .xlsx file in our blob storage as its 'source'. When connecting to the .xlsx file, I can see it in adf just fine: User's image

But when trying to select a sheet within the .xlsx file, it gives me an error:

User's image

The error message is:

Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at NPOI.SS.Util.SimpleDateFormat.ParseObject(String source, Int32 pos) at NPOI.OpenXml4Net.OPC.Internal.PackagePropertiesPart.SetDateValue(String s) at NPOI.OpenXml4Net.OPC.Internal.PackagePropertiesPart.SetCreatedProperty(String created) at NPOI.OpenXml4Net.OPC.Internal.Unmarshallers.PackagePropertiesUnmarshaller.Unmarshall(UnmarshallContext context, Stream in1) at NPOI.OpenXml4Net.OPC.OPCPackage.GetParts() at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1) at NPOI.Util.PackageHelper.Open(Stream is1) at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1) at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'. String was not recognized as a valid DateTime.

Has anyone come across this and would know how to solve it? Its a pretty bog-standard .xlsx file, but it comes from a third party supplier into our blob storage so can't make any amendments to it.

Nandan Hegde 32,336 Reputation points MVP

2024-09-25T12:30:52.36+00:00

What is the size of your excel file? And is it password protected?
Mike Langlois 15 Reputation points

2024-09-25T12:32:46.11+00:00

Hi @Nandan Hegde it is not password protected, and is about 220kb in total
Nandan Hegde 32,336 Reputation points MVP

2024-09-25T12:42:57.41+00:00

Is it possible to attach the excel file (by getting rid of any confidential data)?And share the screenshot of your sheet name
Mike Langlois 15 Reputation points

2024-09-25T12:55:41.4633333+00:00

Unfortunately not as the file would just be empty, even some headers would be deemed confidential.

I did find that if I removed the first sheet in the workbook, it is able to read the rest of the workbook. My guess is its getting stuck on reading this column:

which is date time but in a weird format. I don't need it to read it as a date/time though, and happy for it to just read it as a string but it seems to just be trying to read it as date/time regardless. I can't amend the file each time going forward so would need to have a way to either ignore the first sheet so the rest can be read or have it read this column as a string
Nandan Hegde 32,336 Reputation points MVP

2024-09-25T13:27:57.5266667+00:00

can you try sheetnumber rather than sheetname and check whether excluding the 1st sheet is working via it?
Smaran Thoomu 15,765 Reputation points Microsoft Vendor

2024-09-26T20:22:00.7866667+00:00

@Mike Langlois We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mike Langlois 15 Reputation points

2024-09-27T09:18:37.5066667+00:00

Thanks @Nandan Hegde sorry would sheet number just be like 1,2,3 or is there a certain syntax?
Nandan Hegde 32,336 Reputation points MVP

2024-09-27T10:06:06.2533333+00:00

yes, it starts from 0
Smaran Thoomu 15,765 Reputation points Microsoft Vendor

2024-09-27T21:37:53.27+00:00

@Mike Langlois We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 15,765 Reputation points Microsoft Vendor

2024-09-30T10:12:07.23+00:00

@Mike Langlois Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

Share via

Error 21352 accessing .xlsx file from blob storage in ADF

Your answer