Hi Indy,

Thank you for the provided feedback.

This item has a relatively high priority in our backlog but at this point, I am unable to provide you with a timeframe for solving this issue as it is currently not scheduled for implementation. I apologize for the inconvenience this missing functionality might be causing you. Please, make sure you cast your vote for its implementation as well as subscribe to the task by clicking the Follow button so you can receive updates about status changes.

Regards,
Martin
Progress Telerik

Hi Doug,

Thank you for your feedback. We are tracking the interest for this feature, but still, it is not in our immediate plans for implementing.

While waiting for it you could use this sample code in order to create a Workbook from a DataSet:

private Workbook ImportDataSetToWorkbook(DataSet dataSet)
{
	for (int i = 0; i < dataSet.Tables.Count; i++)
	{
		workbook.Worksheets.Add();

		DataTable currentTable = dataSet.Tables[i];
		Worksheet currentWorksheet = workbook.Worksheets[i];

		currentWorksheet.Name = currentTable.TableName;

		ImportDataFromDataSetToWorksheet(currentTable, currentWorksheet);
	}
}

private void ImportDataFromDataSetToWorksheet(DataTable table, Worksheet worksheet)
{
	for (int col = 0; col < table.Columns.Count; col++)
	{
		CellSelection cell = worksheet.Cells[0, col];
		cell.SetValue(table.Columns[col].ToString());
	}

	for (int row = 0; row < table.Rows.Count; row++)
	{
		var currentRow = table.Rows[row];

		for (int col = 0; col < table.Columns.Count; col++)
		{
			CellSelection cell = worksheet.Cells[row + 1, col];
			var currentCellValue = currentRow.ItemArray[col];

			if (currentCellValue.GetType() == typeof(double) || currentCellValue.GetType() == typeof(int))
			{
				cell.SetValue((double)currentCellValue);
			}
			else if (currentCellValue.GetType() == typeof(DateTime))
			{
				cell.SetValue((DateTime)currentCellValue);
			}
			else if (currentCellValue.GetType() == typeof(bool))
			{
				cell.SetValue((bool)currentCellValue);
			}
			else
			{
				cell.SetValue(currentCellValue.ToString());
			}
		}
	}
}

Regards,
Nikolay Demirev
Progress Telerik

Hi,

Thank you for sharing your feedback. Please, make sure to cast your vote for this implementation and continue following the item so you can receive updates about status changes on it.

Until this task gets implemented, you can add the data from the DataTable by iterating the records and adding them using the SetValue() method of the CellSelection class. More information about this method is available at https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-cells/get-set-clear-properties#value-property .

Regards,
Tanya