How to export WPF -C# - datagrid control with formatting to excel (.xlsx) file ?

Question

0.00/5 (No votes)

See more:

Problem statement -
WPF Datagrid is formatted with

LoadingRow="DataGrid_OnLoadingRow"

1.Datagrid on full page (100 Rows)
2.Condition rows ID < 50 then cell = light green
else cell = blue

Now when i tried to export the excel, the cell formatted properly.
it is not correctly exporting.it skips rows or alter colors.
the same grid work with 20 rows where i split condition to 10(lightgreen)-10(blue) working perfect with exporting.

What I have tried:

What i tried :
Loop through DataGrid.
1.

public static System.Windows.Controls.DataGridCell GetCell(System.Windows.Controls.DataGrid host, DataGridRow row, int columnIndex)

Copy Cell content to Object
2.xCell =

.ItemContainerGenerator.ContainerFromIndex(rowIndex);

OR
3. xCell =

.ItemContainerGenerator.ContainerFromItem(xDataRow);

4. Also tried

dataGrid.UpdateLayout();
dataGrid.ScrollIntoView(Ldgv.Items[rowIndex]);

5. apply that style to excel cell

the Datagrid formatted correctly. and export perfectly with colors if only of less records which is not required scrolling.
i need to develop one open source datagrid for other developers
which export with same font and colors for any number of rows formatted.

Posted 27-Oct-21 18:12pm

iAnkitBhatt

Updated 27-Oct-21 20:31pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2021-10-27T20:31:00

Solution 1

All you need to do is to loop through the collection of rows in datagridview and export them do Excel via using, for example: EPPlus library[^].

How to use it? See: Home · JanKallman/EPPlus Wiki · GitHub[^]

Posted 27-Oct-21 20:31pm

Maciej Los

Comments

iAnkitBhatt 28-Oct-21 2:50am

Thanks for quick reply.using EPPLUS only.

Exporting + formatting all things works fine.
BUT Formatting on data is issue after certain rows to excel.

i am doing the same with EPPLUS and exporting it including formatting when data is within one page. but when data is large formatting is not working proper.

issue is with "cell-style" which is not copying after certain rows let say 50.
all looping and execution logic is correct.datagrid is formatting all rows. data is also exporting with color formatting for rows which are visible on screen. the issue is when next rows required scroll that are not formatting at Excel side.