Page History

Export the Historian Database into an CSV File

To retrieve older data that has been archived using SQL Server Historian in Excel, follow the steps below:

Image Modified

To save the historian database to an Excel file, write the following line of code in CodeBehind and set it up so that when the button is clicked, the code is executed:

Image Removed

public void MouseLeftButtonDown1(object sender, System.Windows.Input.InputEventArgs e)
{
	var nowDate = new DateTime(2023, 7, 2, 22, 59, 59);
	var startDate = new DateTime(2021, 7, 2, 22, 59, 59);

	@Historian.Table.Table1.SaveToTextFile(startDate, nowDate, "HistorianFileSave", ";", true, true, false, 2, null);
}

The result will be the data exported as follows:

Image Modified

To access a

solution example that presents an out-of-box solution for exporting historical data to CSV files, visit

 Export Historian

to CSV

Example.

In this section...