Add Row to Table in PythonI have an existing table with several rows on it.

[Zahira Melendez]

Add Row to Table in Python

I have an existing table with several rows on it. I want the script to add a row which contain values that the script is generating.I can see that the row is added but new columns are added as well. I want the row to add the values using the existing columns.

Here is what I have:rowData = "08/30/2014t" + Convert.ToString(timeRemaining) + "ttt" + Convert.ToString(manInProject) + "t" + Convert.ToString(multiplier) + "tt0rn"

# Make a stream from the stringstream = MemoryStream()writer = StreamWriter(stream)writer.Write(rowData)writer.Flush()stream.Seek(0, SeekOrigin.Begin)

# Set up the text data reader# The name of these are the same as the existing columnsreaderSettings = TextDataReaderSettings()readerSettings.Separator = "t"readerSettings.SetColumnName(0,"Date")readerSettings.SetColumnName(1,"Man Mins Remaining (from JIRA)")readerSettings.SetColumnName(2,"Task Days Remaining")readerSettings.SetColumnName(3,"Workdays remaining")readerSettings.SetColumnName(4,"Man in Project")readerSettings.SetColumnName(5,"Multiplier")readerSettings.SetColumnName(6,"Column 7")readerSettings.SetColumnName(7,"Man Days Available")

table = Document.Data.Tables[tableName]# Create a data source to read in the streamtextDataSource = TextFileDataSource(stream, readerSettings) #Also tried sending the stream ONLY but it still didn't work

# Add rowrowSettings = AddRowsSettings(table, textDataSource)table.AddRows(textDataSource, rowSettings)

[David Pesante 4]

Did you ever figured out how to do this

[Norbert Ledenyi]

Sorry that I can't provide the solution, but I'm also curious to see how it can be achieved, so I'm leaving a comment here just so I get a notification if someone comments :)

[Manoj Chaurasia]

Did anyone find a solution to this problem I countered this problem only with some data files, not all. I am curious what might be causing this problem as all my data files look very similar.

[Kirsten Gustafson 2]

An example is now available here, for anyone that may come across this thread in the future:

https://community.spotfire.com/wiki/how-append-new-rows-existing-data-table-tibco-spotfirer-using-ironpython-scripting