prevent spotfire interpreting first row as column names

[Sundaram Sridharan]

I use theCreateFileDataSource method in ironpython to bring in a variety of file types into analysis

https://spotfired.blogspot.com/2014/05/replace-data-tables-from-file.html

if it is xls, then the file comes in with column names as "column1,column2 " etc. But for txt and csv file types it interprets the first row as column names - I want to force it to treat all rows as data rows - is there an option in ironpython to do that

[Jose Leviaguirre]

Hello SidSri,

 

Have you tried changing all those settings through the DataManager class before calling theCreateFileDataSource method Spotfire needs to know how to replace the DataSource when calling theReplaceData on your Spotfire table.

[Sundaram Sridharan]

can someone point me to an example of how to use DataManager to change settings in CreateFileDataSource I am currently interested in reading in a file and skip the header lines and set data types automatically using this method.