{
bool excel;
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "*.xls|*.xls";
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
new UserInfoBLL().Sqlite(System.IO.Directory.GetCurrentDirectory() + "/sqlite3/park.db");
var strCmd = "Select * from user";
DataTable dt = new UserInfoBLL().btnSave_check(strCmd);//查找数据库里是否有该车牌
excel = new UserInfoBLL().IntoExcel(dt,sfd.FileName);
if (excel)
{
MessageBox.Show("导出成功");
}
else
{
MessageBox.Show("导出失败");
}
}
}
BLL文件里
namespace BLL
{
public class UserInfoBLL
{
public System.Data.DataTable btnSave_check(string strCmd)
{
DBHelper dbHelp = new DBHelper();//DBHelper文件网上可下载
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append(strCmd);
SQLiteParameter[] parameter =
{
};
return dbHelp.ExecuteDataTable(sqlStr.ToString(), parameter);
}
public bool IntoExcel(System.Data.DataTable dt, string inFile)
{
string path = string.Empty;
MsExcel.Application excelApp; //excel应用程序
MsExcel.Workbook excelDoc; //excel工作簿
Worksheet wSheet;
path = inFile;
excelApp = new MsExcel.Application();
if (File.Exists(path))
{
File.Decrypt(path);
}
object nothing = Missing.Value;
excelDoc = excelApp.Workbooks.Add(nothing);
//在sheet3后面新建一个sheet4
//excelDoc.Sheets.Add(Missing.Value, excelDoc.Worksheets[3], Missing.Value, Missing.Value);
//user
wSheet = excelDoc.Worksheets[1] as Worksheet;
int i = 1;
wSheet.Cells[i, 1] = "编号";
wSheet.Cells[i, 2] = "姓名";
wSheet.Cells[i, 3] = "手机号";
wSheet.Cells[i, 4] = "类型";
wSheet.Cells[i, 5] = "日期";
foreach (DataRow item in dt.Rows)
{
i++;
wSheet.Cells[i, 1] = item["id"];
wSheet.Cells[i, 2] = item["name"];
wSheet.Cells[i, 3] = item["mobile_num"];
wSheet.Cells[i, 4] = item["user_type"];
wSheet.Cells[i, 5] = item["valid_date"];
}
try
{
excelDoc.SaveAs(path, MsExcel.XlFileFormat.xlExcel7, nothing, nothing, nothing, nothing,
MsExcel.XlSaveAsAccessMode.xlNoChange, nothing, nothing, nothing, nothing, nothing);
excelDoc.Close();
excelApp.Quit();
return true;
}
catch (Exception)
{
return false;
}
}