How to export excel in left align always?

chandrurec · 2013-08-26

Hi all,

I want to export the data to excel using excel buffer concept. By stand , text will be left aligned and numeric will be right aligned. But I want always to follow the left alignment.

so I read one forum in mibuso and put the following code in excel buffer table.

XlWrkSht.Range(xlColID + xlRowID).HorizontalAlignment := HorzAlign;

but after I put this code , its still works the std way.

if anyone knows how to achieve the scenario, kindly let me know.

Thanks in advance,

Regards,
chandru.

mohana_cse06 · 2013-08-26

You can also add ' before decimal value to make it text which will automatically assign to left.

chandrurec · 2013-08-26

Hi Mohana,

I tried to assign the decimal to text using format but still I found that the alignment is not left aligned.

Thanks & Regards,
chandru.

davmac1 · 2013-08-26

Excel still interprets it as numeric.
Add the ' before the number as recommended and it will be treated as text.

Value:='''' + FORMAT(Number);

geordie · 2013-08-27

Setting the alignment, did you use these values?

XlWrkSht.Range(xlColID + xlRowID).HorizontalAlignment :=  -4108; //Center
XlWrkSht.Range(xlColID + xlRowID).HorizontalAlignment :=  -4131; //Left
XlWrkSht.Range(xlColID + xlRowID).HorizontalAlignment :=  -4152; //Right

MikeConnor13 · 2013-08-28

Have you tried using CStr to convert decimal values to string?

i.e.
aDecimalVariable = Cstr(aDecimalVariable)

should treat the new value of 'aDecimalVariable' as a string.

Howdy, Stranger!

Quick Links

Categories

How to export excel in left align always?

Comments