如何从FTP读取excel文件并在不下载的情况下加载到datatable中 [英] How to read the excel file from FTP and load in datatable without downloading
问题描述
Hello Everyone,
我在从FTP读取数据时遇到一些困难。我已从FTP下载文件并在本地保存,当我尝试读取excel时,我收到以下错误。
外部表是不是预期的格式。
如果我保存带有其他名称的文件,另存为,当我正在阅读它的工作时。
我观察到当我保存时文件大小约为33 kb。保存前原始文件大小为9 kb。
能告诉我问题所在并帮助我。
先谢谢。
谢谢,
Sujju
我尝试了什么:
我保存了文件保存为和读取文件工作。但是从FTP下载的原始文件无效。
Hello Everyone,
I am facing some difficulty in reading the data from FTP. I have downloaded the file from FTP and saved locally and when I am try to read to the excel I am getting the below error.
"External table is not in the expected format".
If I am save the file with other name with save as, when I am reading its working.
I observed that when I am save as the file size is coming some 33 kb. Before save as original file size is 9 kb.
Can you please let me know where the issue is and help me.
Thanks in advance.
Thanks,
Sujju
What I have tried:
I saved the file with save as and reading the file its working. But original file downloaded from FTP is not working.
推荐答案
你可能使用了错误的连接字符串。
对于XLSX文件:
Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ [filepath] +; Extended Properties = Excel 12.0;
对于XLS文件:
Provider = Microsoft.Jet.OLEDB。 4.0; &安培; 数据源=+ [文件路径] +;扩展属性=Excel 8.0; HDR = YES;
You're probably using the wrong connection string.
For XLSX files:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + [filepath] + ";Extended Properties=Excel 12.0";
For XLS files:
"Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" + [filepath] + ";Extended Properties="Excel 8.0;HDR=YES;"
这篇关于如何从FTP读取excel文件并在不下载的情况下加载到datatable中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!