J
James Palmer
Guest
So this is how I do it. I read the excel headers using the com object stuff - I'm in Windows so I can. I then go and look at the format of the next cell down and parse the format so I can work out a data type for it. I then create a column in my dynamic table that's named after the column header (with non-alphanumeric characters removed), with a datatype we just calculated. I then do this for the rest of the columns in the sheet until I come to a column with no header.
Continue reading...
Continue reading...