LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

transfer data into excel????

i want transfer data (in format date) from multicolumn listbox into microsoft excel..the data can transfer,but date format had changed..

for example:-

in multicolumn listbox,the date in format dd/mm/yyyy. after transfer to microsoft excel,the date format had changed into mm/dd/yyyy...

why this happened???

any solution???/

0 Kudos
Message 1 of 8
(2,865 Views)

I believe that Excel default date formats are taken from Windows general settings.

 

Go to Control Panel > Regional and Language Options and change the "Short Date" format.

0 Kudos
Message 2 of 8
(2,849 Views)
Or, instead of changing the format for the entire operating system, simply change the format for that column in the Excel sheet.
Message 3 of 8
(2,843 Views)

There is another thread dealing with exactly the same problem ! There are several issues with the date format in Excel, related to the default settins and language used. Format the destination cells as string (fortunately the code format - @ - seems to be universal) and you will avoid a lot of problems.

 

Chilly Charly    (aka CC)
Message 4 of 8
(2,840 Views)
CC, I think you meant this thread.
Message 5 of 8
(2,834 Views)

smercurio_fc a écrit:
CC, I think you meant this thread.
Yes of course. Sorry for the recursivity ! Anyway that gave a good idea of the closeness of the two threads ! :D:D

 

Chilly Charly    (aka CC)
Message 6 of 8
(2,830 Views)

if my date; 01/12/2008 (dd/mm/yyyy) the problem will be coming...

it's will transfer to excel and display 12/01/2008

that's my problem now...

0 Kudos
Message 7 of 8
(2,783 Views)

snta1806 a écrit:

if my date; 01/12/2008 (dd/mm/yyyy) the problem will be coming...

it's will transfer to excel and display 12/01/2008

that's my problem now...


Have you tried the solution proposed in the other thread (see above - that solved definitively the date problem for me) ? What's the issue with this solution your specific case ? Can you post a short sample VI that shows the problem ?

 

Chilly Charly    (aka CC)
0 Kudos
Message 8 of 8
(2,772 Views)