当导出到excel时数据超过65k时，导出到excel中的多个工作表 [英] export to multiple sheets in excel when data exceeds 65k when exporting to excel

问题描述

我需要将数据从gridview导出到excel.但是我遇到了错误.

数据超过65k时如何导出到同一Excel中的多张纸.


请帮助我.

hi ,

i need to export data from gridview to excel . but i am getting error.

how to export to multiple sheets in same excel when data exceeds 65k .


please help me.

推荐答案

您必须将excel格式更改为.xlsx，以便保存更多记录.目前，如果我没记错，您将其另存为.xls

You have to change the excel format to .xlsx, So that you can save more records. Currently if i am not wrong you are saving it as .xls

这篇关于当导出到excel时数据超过65k时，导出到excel中的多个工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！