The application is reading input from an Excel file using a DataSource and a ADODataset.
1- How can get the table names(names of Excel worksheets) at runtime? i.e. after selecting the excel file to open, it should be a way to select the table name from GetTableNames function, but how?
2-DBGrid is displaying the data. Existing data can be modified and posted, so the original excel file is updated. How is it possible to add a new column to the grid(preferably at any positioin)?
I have tried to add at the end, but as soon the statement DBGrid.Columns.Add is executed the number of columns is reset to 1 and the Excel input data is lost.