Paragraph Indent in Cell

[p.meertens]

Hi,

What is the code to set Cell Indent, as shown in the provided attachment?

Kind regards,
Perry

[rachel.lei]

Hello,

Sorry for the late reply as weekend.
Please refer to the following code to achieve your needs. If you have further questions, please feel free to contact us!

Code: Select all

            Workbook wb = new Workbook();
            Worksheet sheet = wb.Worksheets[0];
            sheet.Range["A1"].Value = "Line1";
            sheet.Range["A1"].Style.HorizontalAlignment = HorizontalAlignType.Left;
            sheet.Range["A1"].Style.IndentLevel = 0;
            sheet.Range["A2"].Value = "Line2";
            sheet.Range["A2"].Style.HorizontalAlignment = HorizontalAlignType.Left;
            sheet.Range["A2"].Style.IndentLevel = 1;
            sheet.Range["A3"].Value = "Line3";
            sheet.Range["A3"].Style.HorizontalAlignment = HorizontalAlignType.Left;
            sheet.Range["A3"].Style.IndentLevel = 2;
            sheet.Range["A4"].Value = "Line4";
            sheet.Range["A4"].Style.HorizontalAlignment = HorizontalAlignType.Left;
            sheet.Range["A4"].Style.IndentLevel = 3;
            wb.SaveToFile("out.xlsx", FileFormat.Version2013);

Sincerely,
Rachel
E-iceblue support team

[p.meertens]

Hi Rachel,

Thank you for your solution!

Kind regards,
Perry

[rachel.lei]

Hi Perry,

Thanks for your response.
If you encounter any issues related to our product, just feel free to contact us.
Have a nice day!

Sincerely,
Rachel
E-iceblue support team