반응형
엑셀파일을 Open 선택하여 DataGridView로 읽어오기
private void btnOpen_Click(object sender, EventArgs e)
{
using (OpenFileDialog openFileDialog1 = new OpenFileDialog())
{
openFileDialog1.Filter = "Excel File|*.xlsx;*.xls";
openFileDialog1.Title = "Import Excel";
openFileDialog1.Multiselect = false;
if (openFileDialog1.ShowDialog() != DialogResult.Cancel)
{
string filePath = openFileDialog1.FileName;
string fileExt = new FileInfo(filePath).Extension;
ExcelDataSource source = new ExcelDataSource();
source.FileName = filePath;
ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings();
//worksheetSettings.WorksheetName = "sheet1";
worksheetSettings.WorksheetIndex = 0;
ExcelSourceOptions sourceOptions = new ExcelSourceOptions();
sourceOptions.ImportSettings = worksheetSettings;
sourceOptions.SkipHiddenRows = false;
sourceOptions.SkipHiddenColumns = false;
sourceOptions.UseFirstRowAsHeader = true;
source.SourceOptions = sourceOptions;
source.Fill();
dgExcel.DataSource = source;
}
}
}
반응형
'개발(IT) > DevExpress(WinForm)' 카테고리의 다른 글
DevExpress DataGrid Master-Detail Scripts (Examples #1) (0) | 2024.04.10 |
---|---|
DevExpress 문서파일 분리작업 (0) | 2023.12.01 |
DevExpress Excel 열기/저장 #1 (0) | 2023.12.01 |
DevExpress Barcode 인쇄하기 (2D QR Code, Data Matrix) (0) | 2023.11.24 |
DevExpress Form Skins(스킨) 변경하기 저장하고 불러오기 (0) | 2023.11.24 |