This is a migrated thread and some comments may be shown as answers.

Issues with ExcelML export

1 Answer 23 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 13 Jun 2012, 12:48 PM
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?

1 Answer, 1 is accepted

Sort by
0
Chris
Top achievements
Rank 1
answered on 13 Jun 2012, 04:29 PM
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;
Tags
Grid
Asked by
Chris
Top achievements
Rank 1
Answers by
Chris
Top achievements
Rank 1
Share this question
or