Question

C#创建的excel文件怎么直接保存到网站根目录下的某个文件夹？

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();
Workbook workbook1 = excel1.Workbooks.Add(true);
Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];
excel1.Visible = false;
把excel1 这个创建的excel直接保存的网站的某个根目录下的文件夹？

Answer 1

Worksheet sheet = (Worksheet)book.ActiveSheet;
string savePath = “” //你要保存的路径
.................................
................................
sheet.SaveAs(savePath, miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss);

//下面附上全部代码，自己慢慢研究去，不同的是下面代码是 通过对话框获取保存路径，你改成默认路径就行了
private void ExportExcel(DataGridView dgv)
{
try
{
SaveFileDialog saveFileDialogWin = new SaveFileDialog();
saveFileDialogWin.Filter = "导出Excel(*.xls)|*.xls";
saveFileDialogWin.FilterIndex = 0;
saveFileDialogWin.RestoreDirectory = true;
saveFileDialogWin.CreatePrompt = false;
saveFileDialogWin.Title = "保存到";
saveFileDialogWin.ShowDialog();
string savePath = saveFileDialogWin.FileName;

Missing miss = Missing.Value;
ApplicationClass excel = new ApplicationClass();
excel.Application.Workbooks.Add(true);
excel.Visible = false;
Workbooks books = excel.Workbooks;
Workbook book = (Workbook)books.Add(miss);
Worksheet sheet = (Worksheet)book.ActiveSheet;
sheet.Name = "WorkSheet";

//写入表头
for (int i = 1; i < dgv.ColumnCount; i++)
{
excel.Cells[1, i] = dgv.Columns[i].HeaderText.ToString();
}

//填充内容
for (int i = 0; i < dgv.RowCount; i++)
{
for (int j = 1; j < dgv.ColumnCount; j++)
{

excel.Cells[i + 2, j] = dgv[j, i].Value.ToString().Trim();
}
}
sheet.SaveAs(savePath, miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss);
book.Close(false, miss, miss);
books.Close();
excel.Quit();
Marshal.ReleaseComObject(sheet);
Marshal.ReleaseComObject(book);
Marshal.ReleaseComObject(books);
Marshal.ReleaseComObject(excel);
GC.Collect();
}
catch(Exception e)
{
MessageBox.Show("导出失败," + e.Message);
}
}

追问

不对吧 我这是Web应用程序， SaveFileDialog是什么？

追答

上面代码是WinForm程式 通过对话框获取保存路径，也就是SaveFileDialog
用到WEB程式中 你不要用 string savePath = saveFileDialogWin.FileName; 你直接給
string savePath=“網站根目錄\\存放EXCEL目錄”; 設定一個默認值就行了
再用 sheet.SaveAs(savePath, miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss); 保存EXCEL就行了

Answer 2

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();
Workbook workbook1 = excel1.Workbooks.Add(true);
Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];
worksheet1 = (Worksheet)workbook1.Worksheets.Add(Type.Missing, workbook1.Worksheets[1], 1, Type.Missing);
worksheet1.Activate();
worksheet1.Cells[2, 2] = 3455555;
excel1.Visible = true;
excel1.DisplayAlerts = false;//不显示提示框
workbook1.Close(true, "d:\\1.xls", null);
//关闭
　　 worksheet1 = null;
workbook1 = null;
excel1.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel1);
excel1 = null;
System.GC.Collect();