我们可以在excel中使用页码吗？ [英] can we have something like page number in excel?

问题描述

HI all



我正在将一个gridview导出到excel，它在网络表单上有分页，但在excel上它显示所有记录而没有分页。 （我知道这是正确的行为）但客户想要的是在excel中也使用分页。我们有什么方法可以解决这个问题。

HI all

i am exporting a gridview to excel which have paging on the web form but on excel it shows all the records without paging. (i know this is the right behaviour) but what client want is to use paging in excel also. is there any way we can manage this.

推荐答案

可能，是的 - 但我没有尝试过，这可能是很多工作。

Excel中有可用的表格： http://office.microsoft.com/en-gb/excel-help/overview-of-forms-form-controls-and-activex-controls-on-a-worksheet- HA010342745.aspx [ ^ ]也许可以做到，但我没试过。



就个人而言，我会在外部报告或完全不同的语言中做同样的事情 - 可能是C＃或VB ......

Probably, yes - but I've not tried, and it's probably a lot of work.
There are Forms available in Excel: http://office.microsoft.com/en-gb/excel-help/overview-of-forms-form-controls-and-activex-controls-on-a-worksheet-HA010342745.aspx[^] which might be able to do it, but I've not tried.

Personally, I'd do something like that either in an external report, or in a different language entirely - probably C# or VB...

这篇关于我们可以在excel中使用页码吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！