Help loading csv table

Kevin_Andras

Hi, 

I am in the early stages of converting a very large ArcGIS Desktop Add-In  to the Pro SDK.   My  add-in requires loading of .csv files that are generated by external executables.  These tables have values that ultimately get appended to feature class tables.  I can't figure out how to load .csv files.  Any help would be greatly appreciated. 

Thank you!

Kevin_Andras

public async Task<Table> CSVtoTable()   //Task<Table>
        {
            Table tbl = null;
            try
            {
                var container = MapView.Active.Map;
                await QueuedTask.Run(() =>
                {
                    string csvPath = "c:\\temp\\test.csv";
                    string tblName = System.IO.Path.GetFileName(csvPath);
                    var StTable = StandaloneTableFactory.Instance.CreateStandaloneTable(new Uri(csvPath, UriKind.Absolute), container);
                    tbl = StTable.GetTable();

                    var tables = container.GetStandaloneTablesAsFlattenedList();
                    if (tables.Count() > 0)  //don't need this
                    {
                        var table = tables.First();
                        if (table.Name == tblName)
                            container.RemoveStandaloneTable(table);
                    }
                    using (RowCursor cur = tbl.Search(null, false))
                    {
                        while (cur.MoveNext())
                        {
                            using (Row row = cur.Current)
                            {
                                string id = Convert.ToString(row["ID"]);
                                Debug.Print(id);
                            }
                        }
                    }
                });
                
            }

            catch (Exception ex)
            {
                ErrorLog(ex.ToString());
                GC.Collect();
                return null;
            }
            return tbl;

        }

I figured out how to do what I needed.  This returns a Table object.