I have an excel spreadsheet where row 1 is headers, then all the rows below are the data. What I need to do is export each row starting with row 2 to an individual file, name the file the value in column A for that row, but include all columns (including A) in the XML output where the field names in the XML that hold the values are the names of the header from row 1.
Is that even possible in Excel? I tried to export the whole thing as a xml spreadsheet, but that wasn't helpful as it just listed everything as <Row> and <Cell> without meaningful stuff like the column headings inside the <>
Is that even possible in Excel? I tried to export the whole thing as a xml spreadsheet, but that wasn't helpful as it just listed everything as <Row> and <Cell> without meaningful stuff like the column headings inside the <>