EPPlus: How to add space in a cell value in C#

Question

I am currently working in an export to Excel of a hierarchical grid using EPPlus. So all child rows should be displayed with padding (space). As shown below:

As shown in the above, you can see I have added four spaces before Software, QA, Analyst, etc.

I have used the below code to add space:

worksheet.cells[1, 1].value = "    Software";

But this doesn't seem to be the proper way to me. I have tried with \t, but that doesn't work.

Is there a better approach I can use here?

Answer 1

Use Style.Indent like this:

ws.Cells["A4"].Style.Indent = 5;

Here is a reference for how it is done inside the actual Excel UI:

How to indent cell data in Excel 2010

Answer 2

Another way would be to use an Excel formula to pad left, like:

string str = "SampleString";
objWorksheet.Cells[3, 1].Formula = string.Format("=REPT(\" \",1)&\"{0}\"", str);

Or pad the string directly like

string str = "SampleString";
objWorksheet.Cells[2, 1].Value = str.PadLeft(str.Length + 1, ' ');

Answer 3

If you just want padding on the left and right side, you can also do this dynamically like this:

foreach (var cell in worksheet.Cells[1, 1, 1, 1])
{
    cell.Value = $"   {cell.Value}   ";
}

Just change the range.