如何在使用C#在asp.net中创建一个Excel文件指定路径和文件名?
问题描述:
我能够用它来创建一个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?
答
使用一个另存为
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);