Issues with ExcelML export

[Chris]

I am trying to format a spreadsheet that I am exporting. I have had to add some hidden columns in the grid so I could use the Data.DataItem in the ExcelMLExportRowCreated event to do some calculations to determine if a date should be highlighted or not. In my click event for my export button I am setting them to visible so I have access to the value. It appears if they are hidden I cannot access this value in the ExcelMLExportRowCreated. The issue is that I don't want these values in the actual spreadsheet. I just want to use them in the calculation. Am I going about this the wrong way?

[Chris]

I actually stumbled upon a solution to my issue. I ended up setting the column to hidden in ExportMLRowCreatedEvent using the below code.

ColumnElement testColumn = e.Worksheet.Table.Columns[12];

testColumn.Hidden = true;