Q:

Writing a whole list in a CSV row-Python/IronPython

Right now I have several  long lists : One called variable_names. 
Lets say Variable names= [ Velocity, Density, Pressure, ....] (length is 50+)
I want to  write a row that reads every  index of the list, leaves about 5 empty cells, then writes next value, and keeps doing it until list is done. 
As shown in  row1 Sample picture

The thing is I can't use xlrd due to compatibility issues with Iron Python and I need to dynamically write each row in the new csv , load data from old csv , then append that data in the new csv, the old csv keeps changing once I append the data in the new csv, so I need to iterate all values in the lists for every time I write the row, because it is much more difficult to append columns in csv. 
What I basicall want to do is :
 with open('data.csv','a') as f:
     sWriter=csv.writer(f)
     sWriter.writerow([Value_list[i],Value_list[i+1],Value_list[i+2].....Value_list[end])

But I can't seem to think of a way to do this with iteration

A:

Because writerow method takes a list argument, you can first construct the list and then write the list so everything in the list will be in one row. 
Like, 
with open('data.csv','a') as f:
     sWriter=csv.writer(f)
     listOfColumns = []
     for i in range(from, to): # append elements from Value_list
          listOfColumns.append(Value_list[i])
     for i in range(0, 2): # Or you may want some columns with blank
          listOfColumns.append("")
     for i in range(anotherFrom, anotherTo): # append elements from Value_list
          listOfColumns.append(Value_list[i])
     # At here, the listOfColumns will be [Value_list[from], ..., Value_list[to], "", "", Value_list[anotherFrom], ..., Value_list[anotherTo]]
     sWriter.writerow(listOfColumns)

