Method SendToExcel

src/parametric.cpp:1506–1576

}

void ParametricViewer::SendToExcel()
{
	wxBusyInfo busy("Processing data table... please wait");

#ifdef __WXMSW__
	wxExcelAutomation xl;
	if (!xl.StartExcel())
	{
		wxMessageBox("Could not start Excel.");
		return;
	}

	xl.Show(true);

	if (!xl.NewWorkbook())
	{
		wxMessageBox("Could not create a new Excel worksheet.");
		return;
	}

	for (int col = m_grid_data->GetNumberCols()-1; col >= 0; col--) { // reorder to match list of Excel sheets with parametric table
		if (VarValue* vv = m_grid_data->GetVarValue(0, col)) {
			wxString sheetName = m_grid_data->GetColLabelValue(col).ToAscii(' ');
			// valid sheet names - no \ / ? * [ ] and 31 characters max
			sheetName.Replace("\\", "_");
			sheetName.Replace("/", "_");
			sheetName.Replace("?", "_");
			sheetName.Replace("*", "_");
			sheetName.Replace("[", "_");
			sheetName.Replace("]", "_");
			if (m_grid_data->IsInput(col)) sheetName = "IN_" + sheetName;
			sheetName = sheetName.Left(31);

			if (vv->Type() == VV_STRING) {
				wxString header = "Index\t";
				wxString dat = "0\t";
				for (int row = 0; row < m_grid_data->GetNumberRows(); row++) {
					header += wxString::Format("Run %d", row + 1);
					dat += m_grid_data->GetValue(row, col);
					if (row < m_grid_data->GetNumberRows() - 1) {
						header += '\t';
						dat += '\t';
					}
					else {
						header += '\n';
						dat += '\n';
					}
				}
				dat = header + dat;
				dat.Replace(",", "");
				xl.PasteNewWorksheet(sheetName, dat);
			}
			else {
				std::vector<std::vector<double> > values_vec;
				wxArrayString labels;
				for (int row = 0; row < m_grid_data->GetNumberRows(); row++)
				{
					std::vector<double> vec = m_grid_data->GetArray(row, col);