生成Excel文件过程中,没有赋值,请大家帮忙检查一下,谢谢!
小弟新人一个,完全自学C#编程的。
在写一个生成Excel文件的过程中,发现文件可以生成。但是打开后发现里面并没有我输入的数值,是空白的。看了一晚上都没找到原因。
Excel是添加COM引用的。using Excel = Microsoft.Office.Interop.Excel;
代码如下:
string worktime = DateTime.Now.ToString("yyyyMMddHHmmss");
Directory.CreateDirectory(@"D:\Test\model");
Directory.CreateDirectory(@"D:\Test\save\" + worktime.Substring(0, 4) + "年\\" + worktime.Substring(4, 2) + "月\\" + worktime.Substring(4, 2) + "月" + worktime.Substring(6, 2) + "日\\");
string frompath, exportpath;
frompath = @"D:\Test\model\model.xlsx";
exportpath = @"D:\Test\save\" + worktime.Substring(0, 4) + "年\\" + worktime.Substring(4, 2) + "月\\" + worktime.Substring(4, 2) + "月" + worktime.Substring(6, 2) + "日\\" + worktime.Substring(8, 2) + "-" + worktime.Substring(10, 2) + ".xlsx";
int[] ExcelList = new int[] { };
int num = 12;
if (num > 0)
{
if (!File.Exists(exportpath))
{
for (int i = 1; i < n - 1; i++)
{
ExcelList[i] = i;
}
File.Copy(frompath, exportpath);
Excel.Application app = new Excel.Application();
Excel.Workbooks wkbks = app.Workbooks;
Excel.Workbook wkbk = wkbks.Open(exportpath);
Excel.Worksheet wkst = wkbk.Worksheets["sheet1"];
//Excel.Range xrange = wkst.get_Range("A1");
for (int i = 1; i < n - 1; i++)
{
ExcelList[i] = i;
wkst.Cells[i, 1] = ExcelList[i];
}
wkbk.Save();
wkbk.Close(Missing.Value, Missing.Value, Missing.Value);
wkbks.Close();
wkst = null;
wkbk = null;
wkbks = null;
app.Quit();
app = null;
GC.Collect();
MessageBox.Show(this, "文件保存成功", "保存信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(this, "文件已存在!", "保存信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}