private void button1_Click(object sender, EventArgs e)
{
// Create an empty report.
XtraReport report = new XtraReport();
// Create a new Excel data source.
ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.FileName = "..//..//Northwind.csv";
// Specify import settings.
CsvSourceOptions csvSourceOptions = new CsvSourceOptions();
csvSourceOptions.DetectEncoding = true;
csvSourceOptions.DetectNewlineType = true;
csvSourceOptions.DetectValueSeparator = true;
excelDataSource.SourceOptions = csvSourceOptions;
// Define the data source schema.
FieldInfo fieldCategoryID = new FieldInfo {
Name = "CategoryID", Type = typeof(double), Selected = false
};
FieldInfo fieldCategoryName = new FieldInfo {
Name = "CategoryName", Type = typeof(string)
};
FieldInfo fieldDescription = new FieldInfo {
Name = "Description", Type = typeof(string)
};
// Add the created fields to the data source schema in the order that matches the column order in the source file.
excelDataSource.Schema.AddRange(new FieldInfo[] { fieldCategoryID, fieldCategoryName, fieldDescription });
// Assign the data source to the report.
report.DataSource = excelDataSource;
// Add a detail band to the report.
DetailBand detailBand = new DetailBand();
detailBand.Height = 50;
report.Bands.Add(detailBand);
// Create a new label.
XRLabel label = new XRLabel();
// Specify the label's binding depending on the data binding mode.
if (Settings.Default.UserDesignerOptions.DataBindingMode == DataBindingMode.Bindings)
{
label.DataBindings.Add("Text", null, "CategoryName");
}
else
{
label.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "[CategoryName]"));
}
// Add the label to the detail band.
detailBand.Controls.Add(label);
// Show the report's print preview.
report.ShowPreview();
}
void ExcelDataSourceBindingToCSV()
{
// Create a new Excel data source.
ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.FileName = "Northwind.csv";
// Specify import settings.
CsvSourceOptions csvSourceOptions = new CsvSourceOptions();
csvSourceOptions.DetectEncoding = true;
csvSourceOptions.DetectNewlineType = true;
csvSourceOptions.DetectValueSeparator = true;
excelDataSource.SourceOptions = csvSourceOptions;
}
private static ExcelDataSource CreateMyOrdersDataSource()
{
ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.Name = "My Orders";
excelDataSource.FileName = "Orders.csv";
// Specify import settings.
CsvSourceOptions csvSourceOptions = new CsvSourceOptions();
csvSourceOptions.DetectEncoding = true;
csvSourceOptions.DetectNewlineType = true;
csvSourceOptions.ValueSeparator = '\t';
excelDataSource.SourceOptions = csvSourceOptions;
// Define the data source schema.
FieldInfo fieldID = new FieldInfo {
Name = "ID", Type = typeof(int)
};
FieldInfo fieldDate = new FieldInfo {
Name = "Date", Type = typeof(DateTime)
};
FieldInfo fieldProduct = new FieldInfo {
Name = "Product", Type = typeof(string)
};
FieldInfo fieldCategory = new FieldInfo {
Name = "Category", Type = typeof(string)
};
FieldInfo fieldPrice = new FieldInfo {
Name = "Price", Type = typeof(decimal)
};
FieldInfo fieldQty = new FieldInfo {
Name = "Qty", Type = typeof(int)
};
FieldInfo fieldDiscount = new FieldInfo {
Name = "IsDiscount", Type = typeof(bool)
};
FieldInfo fieldAmount = new FieldInfo {
Name = "Amount", Type = typeof(decimal)
};
// Add the created fields to the data source schema in the order that matches the column order in the source file.
excelDataSource.Schema.AddRange(new FieldInfo[] { fieldID, fieldDate, fieldProduct, fieldCategory, fieldPrice, fieldQty, fieldDiscount, fieldAmount });
excelDataSource.Fill();
return(excelDataSource);
}
