using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using RKLib.ExportData; // (需要这个引用)
namespace xxxx.xxxxx.MBusiness
{
public class DbToExcel
{
/// <summary>
///
/// </summary>
/// <param name="fileName">fileName</param>
/// <returns>DataSet</returns>
/// <remarks>
/// </remarks>
public static string ConvertDsToCSV(DataSet ds, string exportType, string destinationPath, string execelname)
{
string state = "";
int[] iColumns;
try
{
DataTable dtCSV = ds.Tables[0];
iColumns = new int[dtCSV.Columns.Count];
//?????????????????:int[] iColumns ={0,1,2,3,4,5,6};
for (int i = 0; i < dtCSV.Columns.Count; i++)
{
iColumns[i] = i;
}
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
if (exportType == "CSV")
{
objExport.ExportDetails(dtCSV, iColumns, Export.ExportFormat.CSV, destinationPath); //输出csv格式
}
else
{
objExport.ExportDetails(dtCSV, Export.ExportFormat.Excel, destinationPath); //输出Execl 格式
}
state = "Successfully exported to " + destinationPath;
}
catch (Exception Ex)
{
state = Ex.Message;
}
return state;
}
}
}