机器学习：从放置在Blob容器中的Excel文件导入数据时出现问题 [英] Machine Learning : Issue in Import data from Excel file which is placed in Blob container
问题描述
大家好，
我正在尝试从Excel文件中导入数据，该文件位于Blob容器中，但我收到的信息低于错误。
我可以从同一个blob容器加载CSV文件，当我尝试使用excel文件时，测试连接成功。
requestId = c934f93f8c5e4118b90abf68d418cb4f errorComponent = Module。 taskStatusCode = 400。 {" Exception"：{" ErrorId"：" IncorrectAzureBlobName"，" ErrorCode"：" 0065"，" ExceptionType"：" ModuleException"，" Message"：" Error
0065 ：Azure存储blob不正确。"}}错误：错误0065：Azure存储blob不正确。退出过程，错误代码为-2
I遵循以下网址中提供的Microsoft提供的文档中提到的以下步骤
https：// docs .microsoft.com / zh-CN / azure / machine-learning / studio-module-reference / import-from-azure-blob-storage
For Excel文件在指定存储Excel文件的帐户和容器后，必须使用以下选项指示Excel格式和范围或表名：
Excel数据format：指示数据是在Excel工作表范围内还是在Excel表中。
Excel工作表或嵌入表：如果选择Excel工作表选项，请指定工作表的名称（选项卡名称）或工作簿中嵌入的表。读取表格中的所有数据;你不能指定一系列的细胞。如果选择Excel表格选项，
必须获取表格名称而不是表格名称，即使工作表上只有一个表格。要查看表名，请在表内单击，然后在"表工具"选项卡中查看"表名"属性。
如果我们有解决此问题的任何解决方法，请与我们联系。
如果未正确指定Azure blob名称，则会出现Azure计算机机器学习中的此错误。如果出现以下情况，您将收到错误：
blob无法在指定的容器中找到。
完全限定名称为其中一个输出指定的blob 学习计数 modules
大于512个字符。
只有容器被指定为 导入数据 格式为Excel或CSV时请求带编码;这些格式不允许
连接容器内所有blob的内容。
SAS URI不包含有效blob的名称。
解决方案：
重新访问抛出异常的模块。验证指定的blob是否存在于存储帐户的容器中，并且
权限允许您查看blob。验证输入的格式为 containername / filename 在
中的情况下是带有编码格式的Excel或CSV。验证SAS URI是否包含有效blob的名称。
问候，
< span style ="font-family：'Segoe UI'，SegoeUI，'Segoe WP'，'Helvetica Neue'，Helvetica，Tahoma，Arial，sans-serif; font-size：16px">宇通
Hi All,
I am trying to Import data from Excel file which is placed in Blob container but I am getting below error.
I am able to load CSV files from same blob container and when I am trying to use excel files, test connection is successful.
requestId = c934f93f8c5e4118b90abf68d418cb4f errorComponent=Module. taskStatusCode=400. {"Exception":{"ErrorId":"IncorrectAzureBlobName","ErrorCode":"0065","ExceptionType":"ModuleException","Message":"Error 0065: The Azure storage blob is incorrect."}}Error: Error 0065: The Azure storage blob is incorrect. Process exited with error code -2
I have followed the below steps mentioned in Microsoft provided documentation in the below URL
https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/import-from-azure-blob-storage
For Excel files, after specifying the account and container where the Excel file is stored, you must indicate the Excel format and range or table name, using these options:
Excel data format: Indicate whether the data is in an Excel worksheet range, or in an Excel table.
Excel sheet or embedded table: If you select the Excel sheet option, specify the name of the worksheet (the tab name) or a table embedded in the workbook. All data from the sheet is read; you cannot specify a range of cells. If you select the Excel table option,
you must get the table name and not the sheet name, even if there is only one table on a sheet. To view the table name, click inside the table and then view the Table Name property in the Table Tools tab.
Please let me know if we have any workaround for this problem.
Hi,
This error in Azure Machine Learning occurs if the Azure blob name is specified incorrectly. You will receive the error if:
The blob cannot be found in the specified container.
The fully qualified name of the blob specified for output in one of the Learning with Counts modules is greater than 512 characters.
Only the container was specified as the source in a Import Data request when the format was Excel or CSV with encoding; concatenation of the contents of all blobs within a container is not allowed with these formats.
A SAS URI does not contain the name of a valid blob.
Solution:
Revisit the module throwing the exception. Verify that the specified blob does exist in the container in the storage account and that permissions allow you to see the blob. Verify that the input is of the form containername/filename in the case of Excel or CSV with encoding formats. Verify that a SAS URI contains the name of a valid blob.
Regards,
Yutong
这篇关于机器学习：从放置在Blob容器中的Excel文件导入数据时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
