Is there a way to define multiple header rows when generating an Excel file? I'm trying to structure the sheet so that each index maps to a specific string, and then hide the row containing the index values.
The reason I'm doing this is that the string values may be duplicated, so using a dictionary (which requires unique keys) won’t work.
For example:
Is there a way to define multiple header rows when generating an Excel file? I'm trying to structure the sheet so that each index maps to a specific string, and then hide the row containing the index values.
The reason I'm doing this is that the string values may be duplicated, so using a dictionary (which requires unique keys) won’t work.
For example: