ExcelDataSource.FileName Property

Gets or sets a path to the Microsoft Excel workbook or CSV file.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[DefaultValue(null)]
[LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)]
public string FileName { get; set; }

VB.NET

<DefaultValue(Nothing)>
<LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)>
Public Property FileName As String

Property Value

Type	Default	Description
String	null	A String that specifies the path to the Microsoft Excel workbook or CSV file.

Remarks

As an alternative, you can specify the stream containing a Microsoft Excel workbook or CSV file using the ExcelDataSource.Stream property. Specify the format of the document contained in the stream by using the ExcelDataSource.StreamDocumentFormat property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FileName property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/ExcelDataSourceSnippets/Code.cs#L16

ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.FileName = "Northwind.csv";

winforms-grid-open-excel-files/CS/Form1.cs#L19

var source = new ExcelDataSource();
source.FileName = "test.xls";
var worksheetSettings = new ExcelWorksheetSettings("Sheet1", "A1:B3");

reporting-web-forms-report-designer-add-data-sources/CS/WebApplication1/Default.aspx.cs#L39

excelDS.FileName = Server.MapPath("App_Data/Categories.xlsx");
excelDS.Name = "CustomExcelDataSource";

asp-net-mvc-grid-upload-excel-file-using-upload-control-and-display-data-in-grid/CS/T449148/Models/Model.cs#L25

ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.FileName =  fileName;
ExcelWorksheetSettings excelWorksheetSettings = new ExcelWorksheetSettings();

reporting-winforms-bind-to-csv-file/CS/BindingReportToCsvFile/Form1.cs#L29

ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.FileName = "..//..//Northwind.csv";

VB.NET

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/ExcelDataSourceSnippets/Code.vb#L14

Dim excelDataSource As New ExcelDataSource()
excelDataSource.FileName = "Northwind.csv"

winforms-grid-open-excel-files/VB/Form1.vb#L14

Dim source = New ExcelDataSource()
source.FileName = "test.xls"
Dim worksheetSettings = New ExcelWorksheetSettings("Sheet1", "A1:B3")

reporting-web-forms-report-designer-add-data-sources/VB/WebApplication1/Default.aspx.vb#L38

excelDS.FileName = Server.MapPath("App_Data/Categories.xlsx")
excelDS.Name = "CustomExcelDataSource"

asp-net-mvc-grid-upload-excel-file-using-upload-control-and-display-data-in-grid/VB/T449148_VB/Models/Model.vb#L11

Dim excelDataSource As ExcelDataSource = New ExcelDataSource()
excelDataSource.FileName = fileName
Dim excelWorksheetSettings As ExcelWorksheetSettings = New ExcelWorksheetSettings()

reporting-winforms-bind-excel-runtime/VB/BindingReportToExcelWorkbook/Form1.vb#L22

Dim excelDataSource As ExcelDataSource = New ExcelDataSource()
excelDataSource.FileName = "..//..//Northwind.xlsx"
' Select a required worksheet.