Save Data To A Preformatted Excel File

[John Marshall 8]

Hi,

 

I want to download some data to an excel file which would already have a column with names for the information:

 

Title One

Title Two

Title Three

 

So, the new information would be saved to the second column:

 

Title One       Data 1

Title Two       Data 2

Title Three    Data 3

 

I cannot figure out how to do this (I'm new).   The table will need to be cleared each time and then saved as a new file.  I'd be grateful for some tips on the way forward with this.  I've got the Dev Edition, by the way.

 

 

[darryl561 177]

Not sure if this will help.  After you clear the table each time you can then add the titles to the first column and the data to the second column and save to file.

clear table(&demo)
add list to table as column(&demo,0,0,$list from text("Title One
Title Two
Title Three",$new line))
add list to table as column(&demo,0,1,$list from text("Data 1
Data 2
Data 3",$new line))
save to file("{$special folder("Application")}/demo.csv",&demo)

[John Marshall 8]

Many thanks, Darryl.  I'll give it a go.

[BobbyP 8]

I think he means a already preformatted table from harddrive.The way to go is to load that table with 

create table from file("D:\\EOD\\data\\dax12YEARt2.csv",&table1)

and then save data 1 to list 1 data2 to list two and so on and add them to the table loaded with the prev.command

Hope it helps .

create table from file("D:\\EOD\\data\\dax12YEARt2.csv",&table1)
add list to table as column(&table1,0,0,%list1)
add list to table as column(&table1,0,1,%list2)
add list to table as column(&table1,0,2,%list3)

and so on.

[John Marshall 8]

Thanks, BobbyP.

 

Between the two of you I have been able to achieve this goal.

 

What a great forum!