Hi,
I am trying to read a number of excel files. Some of these files have a sheet called content. In cell A1 there is a name which is different for each file with the content sheet. On the second row there are attribute headers, and from the third row each row contains data.
The problem I have is that the first file I read from a directory does not have the content sheet. So I can not specify start row 0 when reading attributes. The result I now get is that the first file with a content sheet is read but the first attribute has the name of the value in cell A1. Every file coming after this tries to read the same attribute name as the first one which is missing in this next file.
Does somebody know a solution other than removing the first row from content sheet.