导入 CSV 文件到 Excel 工作簿代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】导入 CSV 文件到 Excel 工作簿

作者:Dezai.CN / 发布于2013/7/13/ 753

你必须在项目中添加对 Microsoft.Office.Core 的引用：from the .NET tab of the Visual Studio Add Reference dialog box, and the Microsoft Excel 12.0 Object Library (you can use 14.0 if you want, too, but nothing lower).


	using Microsoft.Office.Interop.Excel;
	using Microsoft.Office.Core;

	/// <summary>
	/// Takes a CSV file and sucks it into the specified worksheet of this workbook at the specified range
	/// </summary>
	/// <param name="importFileName">Specifies the full path to the .CSV file to import</param>
	/// <param name="destinationSheet">Excel.Worksheet object corresponding to the destination worksheet.</param>
	/// <param name="destinationRange">Excel.Range object specifying the destination cell(s)</param>
	/// <param name="columnDataTypes">Column data type specifier array. For the QueryTable.TextFileColumnDataTypes property.</param>
	/// <param name="autoFitColumns">Specifies whether to do an AutoFit on all imported columns.</param>
	public void ImportCSV(string importFileName, Excel.Worksheet destinationSheet,
	 Excel.Range destinationRange, int[] columnDataTypes, bool autoFitColumns)
	{
	 destinationSheet.QueryTables.Add(
	 "TEXT;" + Path.GetFullPath(importFileName),
	 destinationRange, Type.Missing);
	 destinationSheet.QueryTables[1].Name = Path.GetFileNameWithoutExtension(importFileName);
	 destinationSheet.QueryTables[1].FieldNames = true;
	 destinationSheet.QueryTables[1].RowNumbers = false;
	 destinationSheet.QueryTables[1].FillAdjacentFormulas = false;
	 destinationSheet.QueryTables[1].PreserveFormatting = true;
	 destinationSheet.QueryTables[1].RefreshOnFileOpen = false;
	 destinationSheet.QueryTables[1].RefreshStyle = XlCellInsertionMode.xlInsertDeleteCells;
	 destinationSheet.QueryTables[1].SavePassword = false;
	 destinationSheet.QueryTables[1].SaveData = true;
	 destinationSheet.QueryTables[1].AdjustColumnWidth = true;
	 destinationSheet.QueryTables[1].RefreshPeriod = 0;
	 destinationSheet.QueryTables[1].TextFilePromptOnRefresh = false;
	 destinationSheet.QueryTables[1].TextFilePlatform = 437;
	 destinationSheet.QueryTables[1].TextFileStartRow = 1;
	 destinationSheet.QueryTables[1].TextFileParseType = XlTextParsingType.xlDelimited;
	 destinationSheet.QueryTables[1].TextFileTextQualifier = XlTextQualifier.xlTextQualifierDoubleQuote;
	 destinationSheet.QueryTables[1].TextFileConsecutiveDelimiter = false;
	 destinationSheet.QueryTables[1].TextFileTabDelimiter = false;
	 destinationSheet.QueryTables[1].TextFileSemicolonDelimiter = false;
	 destinationSheet.QueryTables[1].TextFileCommaDelimiter = true;
	 destinationSheet.QueryTables[1].TextFileSpaceDelimiter = false;
	 destinationSheet.QueryTables[1].TextFileColumnDataTypes = columnDataTypes;

	 Logger.GetInstance().WriteLog("Importing data...");
	 destinationSheet.QueryTables[1].Refresh(false);

	 if (autoFitColumns==true)
	 destinationSheet.QueryTables[1].Destination.EntireColumn.AutoFit();

	 // cleanup
	 this.ActiveSheet.QueryTables[1].Delete();
	}

试试其它关键字

　Excel　　工作簿　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)