从vb.net 2008导出到excel [英] Export to excel from vb.net 2008

问题描述

当我导出到excel文件并使用xlsx格式保存时，它会保存文件。但是当我打开文件时，它给出了如下错误。



Excel无法打开文件''filename.xlsx''因为文件格式或文件扩展名无效。验证文件是否已损坏且是文件扩展名与文件的格式相匹配。





但是当我将扩展名更改为.xls时，它会打开文件。但问题是如果我的行超过65536行之后会被截断。所以这就是我将它保存为.xlsx的原因。




将文件导出到excel 2003和excel之间有什么区别吗2007年来自vb.net 2008？

When i am exporting to excel file and saving it with xlsx format, it saves the file. But when i am opening the file it gives me the error as follows.

"Excel cannot open the file ''filename.xlsx'' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."


but when i change the extension to .xls it opens the file. but the problem is if my rows are going beyond 65536 rows gets truncated after that. So that is the reason i amd saving it as .xlsx.


Is there any difference between exporting a file to excel 2003 and excel 2007 from vb.net 2008?

推荐答案

参考：使用VB.Net导出到Excel [ ^ ]



和 Google too [ ^ ]

Refer: Export to Excel using VB.Net[^]

and Google too[^]

请参阅 MSDN链接 [ ^ ]。

它接受了答案。

Refer this MSDN link[^].
It has accepted answer.

你可能对这个艺术有一个研究：将数据导出到Excel [ ^ ]

You may have a research on this artilce: Exporting Data to Excel[^]

这篇关于从vb.net 2008导出到excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！