Hello,

If you believe that that was not the proper answer to your question, you can go back and unmark that answer. This is in case that reply was marked as the answer by mistake.

Please let me know if I can further assist you.

Shaolin,

You are right, and I misspoke. Freezing panes is possible to do through the Infragistics ExcelEngine, and the UltraGridExcelExporter will honor that in the Excel file that it saves. However, the UltraGrid does not automatically send the exporter which columns/rows are fixed, and consequently where the ExcelEngine will freeze the pane. This last step is what I meant would have to be handled through code.

I've been working on a sample which demonstrates how one would handle this through code, and have attached it below. Please take a look if you need more info about how to freeze the correct columns/rows in the ExcelEngine.

Please let me know if I can assist you further.

Hello Shaolin,

The UltraGridExcelExporter does not currently support exporting fixed rows/columns, and that is a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at <>.

Submitting your idea will allow you to communicate directly with our product management team, track the progress of your idea at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.

Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it.  You can also link back to this thread for additional details. Thank you in advance to submitting your product idea.

Outside of adding this as a feature to the UltraGridExcelExporter, you could manually handle freezing the rows/columns in Excel through code by capturing which cell would have to be frozen according to your locked grid rows/columns.

Please let me know if I can further assist you.

Hello Jurgen,

There is no built in feature to copy a worksheet. Please take a look at Copy Worksheet to see how Mike Dour explains how to do this manually.

Please let me know if I can further assist you.