[解决]导出到excel会产生空白 [英] [Solved] Exporting to excel produces blanks

问题描述

男孩和女孩！我的出口出现了问题.由于某些原因，当我将数据网格从vb.net导出到excel时，工作表具有正确的数据集，然后在其正下方有一堆空白行，然后是#N/A值的行.谁能给我提示为什么会这样吗?我知道我可能提供的信息太少，但这只是一个提示.
在此先感谢

Hi guys and girls! I''ve got an issue with my exports. For some reason when i export a datagrid from vb.net to excel, the sheet has the right set of data and then directly beneath it a bunch of blank rows followed by rows with the value of #N/A. Can anyone give me a hint as to why this happens? I know i''m probably giving too little info but its just a shot.
Thanks in advance

推荐答案

已回答仅从未答复的列表中删除.

原始海报的提示:礼貌地发布您的解决方案作为答案，以便其他有类似问题的人可以共享它.

Answered only to remove from the unanswered list.

Note to the orignal poster: It would be polite to post your solution as an answer, so other people with a similar problem can share it.

这篇关于[解决]导出到excel会产生空白的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！