如何在使用C＃在asp.net中创建一个Excel文件指定路径和文件名？ [英] how to specify path and filename while creating a excel file in asp.net using c#?

问题描述

我能够用它来创建一个Excel文件：

i am able to create an excel file by using this:

protected void excldwnlbtn4_Click(object sender, EventArgs e)
{
    write_on_excel();
}

public void write_on_excel()
{
    Excel.ApplicationClass excelApp = new Excel.ApplicationClass();
    try
    {

        Excel.Workbook workbook = (Excel.Workbook)excelApp.Workbooks.Add(Missing.Value);
        Excel.Worksheet worksheet;






        // Get first Worksheet
        worksheet = (Excel.Worksheet)workbook.Sheets.get_Item(1);

        // Setting cell values

        ((Excel.Range)worksheet.Cells[1, "A"]).Value2 = "Vendor Code";
        ((Excel.Range)worksheet.Cells[1, "B"]).Value2 = "Vendor Password";
        ((Excel.Range)worksheet.Cells[1, "C"]).Value2 = "Vendor Name";


        workbook.Save();
        workbook.Close(0, 0, 0);
    }
    catch (Exception)
    {
        lblmsg4.Text = "File not Downloaded!!";
    }
    finally
    {
        excelApp.Quit();
    }
}

这个我在我的C创建一个.xlsx文件？：\\文档作为book1.xlsx，但我想指定文件夹的路径和文件名，我怎么能做到这一点。

by this i am creating a .xlsx file in my c:\documents as book1.xlsx but i want to specify the folder path and file name how can i do this?

推荐答案

使用一个<一个href=\"http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas%28v=vs.80%29.aspx\"相对=nofollow>另存为

object missing = System.Reflection.Missing.Value;

workbook.SaveAs(@"c:\documents\book1.xlsx",
            Excel.XlFileFormat.xlOpenXMLWorkbook, missing, missing,
            false, false, Excel.XlSaveAsAccessMode.xlNoChange,
            missing, missing, missing, missing, missing);

这篇关于如何在使用C＃在asp.net中创建一个Excel文件指定路径和文件名？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！