export excel

medTUN

I Want to export item No. to excel report,
"item No." is code eg. item No.= 0014525
after export i have in excel report 14525
how method to obtein 0014525

wonmo

How are you exporting it into excel. If you are just copying and pasting then set the column that this field will go into as a text field. If you are importing into excel via a text file then make sure that you set that field property as text.

medTUN

Hi,
no i develop unit code,
contain some information between item and post order's
but i obtain in excel item No =14525
in unit code
xlWorkSheet.Range('E' + FORMAT(RowNoCount)).Value :=Format(Ite."No.");
xlWorkSheet.Range('D' + FORMAT(RowNoCount)).Value :=FORMAT(Postord."posting Date");
i obtain in column "D" 02/01/2003 but in column "E" 14525
but i would obtain in column "D" 02/01/2003 but in column "E" 0014525

kailou

if you are writting directly to excel worksheet append a single quotation:
eq ''''+format(000123444)

kailou

so you need to change Format(Ite."No.") to ''''+Format(Ite."No.")

hope that helps



mahannokoy@yahoo.com

wonmo

You don't need the FORMAT statement for Item."No.". First of all, it is a code field and secondly, if you use the value property you don't have to convert to text.

Another way is this:

xlWorkSheet.Range('E' + FORMAT(RowNoCount)).Text :=Item."No.";

medTUN

hi,
no all this method are don't work, is it another method to convert the rows E to text i.e before export i would change the format cellule fronm standard to text?

janpieter

If you want a number to be 00124 instead of 124, the same thing happens when you insert a number manualy into excel.

I think you can try 2 things:
1. In your excel template document select column 'E' and go to cell properties. Change the category in 'text'.
2. - Make a tekst constant QOUTE containing the text ' (single quote)
- xlWorkSheet.Range('E' + FORMAT(RowNoCount)).Value :=Format(QOUTE + Ite."No.");

Don't know for sure if it works, good luck!

giulio.cipo

if you want cells like text the solution is the follow code
XlWorkSheet.Range(xlColID + xlRowID).NumberFormat := '@';
you could use the standard function table excel buffer