HELP!!! I am trying to save data in a spreadsheet

[Noman]

I have tried several things but can not get this, should be pretty simple.
1) I have a loop which sends command and read serail buffer and parse data. This works fine and my program is 3 seconds behind my actual device. Now I want to save the data I parse out in a spreadsheet but only every minute becasue my program will be running for 8 hours. Do you guys think that Excel would be handel such a big matrix.
my data is something like this:
I am receiving the day of the year which is 338 as string. the time which is also a string but updates as my loop is running which is approximately 3 seconds behind my actuall hardware shows but thats not a problem because I acutally want to save the data rather than viewing purpos
e.
2) If some one can show me a approach where user is asked to save-as file option (where to save the file) when I am start my loop when I am actually sending command and receving data and parsing data and if the file exist already then name another file.

3) the format I want to put my data to spreadsheet is as:
day-time (actual number)
01 70
02 80
03 90
04 76

so on untill i read 36 channels and their corresponding temperatues. Next time i append the next data set after a minutes should look like:

day-time day-time
01 70 01 72
02 80 02 81
03 90 03 95
04 76 04 78
.. .. .. ..
36 90 36 98

this would be a pretty big metrix if i append data every minute and my program would run for 8 hours.

As I mentioned I want to save the data only every minutes while my program acquiring data every 3 seconds. Thanks for your help

[MPBC]

Hi,
My name is Michel Carrière, from montreal.
I save directly to excel large amounts of data all the time. My first solution is a VI called "SAVE TO EXCEL". With this subroutine, you can open excel dump data and save your file.

Secondly, I have a small VI that acquires data and saves it when I want, check it out. ("WattmetreHP_1CHAN_V2.vi")

[Noman]

Your excel Vi has subvis that are open excel and open sheet which looks for existing workbook and worksheet if i am correct but what I wanna do is before my loop runs for when user press start program , the user should be asked to save file as "name" of the file to be saved which should not need the .xls that should be in my program and also when i am running my loop is it possible to view the excel where it is saving the data. Also how would I make it to get data every minute and update my excel file. Thanks

[MPBC]

Send me your program and I will see what I can do...
michel.carriere@mpbc.ca

[RL]

M. Carrière de Montréal,
Thank you for contributing "WattmetreHP_1CHAN_V2.vi" unfortunately there are some VI that are not included.
Can you indicate where I can find the following:
AddresseHP.vi
HPaddressedialog.vi
FILE EXISTS OR NOT.VI

I am trying to setup something that will save data when it appears interesting on the graphs (Save on demand if you wish).

Regards,
RL