exporting data to exiesting excel shhet

[user_1]

I am sending a vi to depict my problem...

No frm previous post cant find solution.

If possible pls help!!!

[chilly_charly]

The problem with the date format is that it depends apparently on the Excel settings. For instance, the codes are dependent on the language (ie : dd/mm/yy in english and jj/mm/aa in french...) and if you don't use the right ones, you'll fire an error !

So my advice is to write the date as string (code is always @), write the data to the sheet, then (try to) format the column as date, as suggested earlier.

Your VI had a number of problems. The main one was that you didn't specify a range for the cells to be formatted. You could have corrected that by yourself if you had wired completely the errors either to an "error out" cluster or to the simple error handler.

Then, if you don't fill in the column headers they will not appear on the Excel sheet !

I also have modified the event structure :

- no need to use the timeout frame, specially at a rate of 500 loops/s !

- place the buttons in their handler frame

Avoid setting the VI to run as a modal dialog, a floating window is enough, and you can see what's going on on the bloc diagram.

Here is your VI after correction.  

[user_1]

Thank U so much for the help.And thanks a lot for the suggestions for improvement.Can u pls send a copy in LV 8.0 version.My labview version is 8.0...

Again thanks a lot

[chilly_charly · Accepted solution]

---

user_1 a écrit:

Thank U so much for the help.And thanks a lot for the suggestions for improvement.Can u pls send a copy in LV 8.0 version.My labview version is 8.0...

---

Sorry, I can't 😞  The Report VIs can't be compiled into LV 8.0. Anyway, as shown in the picture below, the modifications are easy.

 

Message Edité par chilly charly le 01-02-2009 06:54 AM

[user_1]

Thats great...

i tried several ways...But cudnt...Even its easy i failed to locate the cell selection...

Now i cud...

I sent u a sample vi..actually its calling from another vi...so i cant tell how many rows in the selection..But i think that i can solve in some way...

Thank u so much for the help

[user_1]

Yesss...Now i solved the problem...

[chilly_charly]

After a deeper look into the Excel Set Cell Format VI, I found the following issues/properties

- once the sheet has been populated, the cell coordinates can be defined more easily : 

      if you don't wire them, the format will apply to the whole sheet 

      if you dont wire the end input, the format will be applied to the cell designed by the start input. If one of start input coordinates is set at -1, the format will affect all the corresponding row/column cells.

-when the sheet is empty (as in your sample.vi), then you must define the cell range, otherwise only the first cell (A1) is adressed.

- it seems that Excel always interpret a date entry as mm/dd/yyyy, then convert it to the destination format. So, never try to convert the cells to date even after writting them as strings as suggested earlier. This would again scramble the numbers. Alternatively, you could convert your dates to the mm/dd/yyyy format before sending to Excel. However, this will not solve the problem of the localized format string (d(ay) and y(ear) against j(our) and a(nnée) - I wonder what it is in spanish : d(ia) and a(no) ?). 

[user_1]

Hi..

I need one more help pls...

after testing my appln it was found that..in the first run again the date got problem..after that no problem...

am attaching a screen shot

thanks in advance

[user_1]

Hi..

I need one more help pls... after testing my appln it was found that..in the first run again the date got problem..after that no problem... am attaching a screen shot

 thanks in advance