更新时间:2023-01-23 09:19:30
要做到这一点,您需要添加一个printableComponentLink到每个gridControl,然后创建一个可以添加每个printableComponent链接的复合链接。
此链接可能会证明DevExpress 知识库文章可能证明是有用的,因为它有一个例子。
然后,您将使用 compositeLink.ExportToXlsx
方法。如果您使用 XlsxExportOptions.ExportMode
属性等于 SingleFilePageByPage $ c $创建
XlsxExportOptions
c>并将其传递给 CompositeLink.ExportToXlsx
方法,每个页面都将导出到单独的工作表。
I've got several XtraGrid Controls each one containing different information, I get some information about the way in which you can export a XtraGrid to an Excel file in the following direction http://www.devexpress.com/Support/Center/p/Q362120.aspx
Now Is there any way to export the each XtraGrid Control to a single Excel file so that every XtraGrid information is exported to a different excel sheet.
I tried setting the exporting path direction to the same Excel file, but when the first exporting process is done, the second exporting process just overrides the excel file and so on.
I tried using the method described in this direction XtraGrid - Export To Excel , but I wanted to know if there is another way whithout using the interop excel libraries because I have experience some problems when using this library (I mean when using this library you create an Excel process but after you created it you cannot kill it, even though you have used the method that is supposed to do that).
Any help would be welcomed.
To do that you will want to add a printableComponentLink to each gridControl, and then Create a compositeLink that you can add each of the printableComponent links to.
This link may prove DevExpress KB Article may prove useful as it has an example of that.
Then you will use the compositeLink.ExportToXlsx
method. If you create XlsxExportOptions
with the XlsxExportOptions.ExportMode
property equal to SingleFilePageByPage
and pass it to the CompositeLink.ExportToXlsx
method, every page will be exported to a separate sheet.