Exporting to Excel format is a process similar to printing grid data, in that you have control over how Layouts and Appearances are applied to the data before export, and which data is included or excluded. Exporting to Excel supports saving the Grid data to either legacy. Add an UltraWinGrid to a form in your application, or open an existing application and display a form that contains the UltraWinGrid. Add a control to your form such as a command button or a menu item to initiate the export function.
|Published (Last):||11 June 2018|
|PDF File Size:||15.97 Mb|
|ePub File Size:||9.93 Mb|
|Price:||Free* [*Free Regsitration Required]|
I need to hide some columns during the exporting process, so that this columns are not exported to the excel sheet anymore. Workbook; if hWorkbook! But does not suppress the column with the index 0 in the excel sheet. It looks like that the Worksheet is only prepared and not filled in with any data at this event. Column; if hCol. This does also not hide the column with index 0 in the excel sheet. Has anybody an idea how a suppressing of one or more columns during the excel export can be achieved?
Thank you for any help! You can use the ExportStarted event to hide the column. ExportStartedEventArgs e. Your Privacy Matters : We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use.
Please let me know if you have any additional questions. Reply Reject Answer Cancel. Offline Franco Pederiva posted over 5 years ago in reply to Dimitar.
Hello Dimitar, Yes, your solution is working perfectly. Thank you very much indeed! Reply Verify Answer Cancel.
Export WinGrid to a New PDF Document
I need to hide some columns during the exporting process, so that this columns are not exported to the excel sheet anymore. Workbook; if hWorkbook! But does not suppress the column with the index 0 in the excel sheet. It looks like that the Worksheet is only prepared and not filled in with any data at this event. Column; if hCol.
Export Grid Data to Excel
I use Windows Forms Pack Export dgReport, report ; gridSection. Landscape; gridSection. AddText 0, 0 ; headerText. I made some changes to the code and wrapped it up in a small project. Please take a look at it and let me know if you have any questions, I will be glad to assist you further on this.
It is highly unlikely that your grid will be in perfect form for a printable document such as a PDF file. Some important events covered in this walkthrough are listed below:. BeginExport — Fires when the entire exporting process first begins. This is where you would set Section-specific properties and modify the ExportLayout by hiding a few columns.