时间戳

首页 > 解决方案 > 生成 Excel 文件，然后将数据输入到单元格中

c# - 生成 Excel 文件，然后将数据输入到单元格中

问题描述

我想用 C# 生成一个 Excel 文件供用户放入数据，例如在 [1,2] [3,4] [5,6] 列中，然后从用户那里保存这些数据，关闭 Excel 文件并使用为某些计算输入的数据。

我能够生成 Excel 文件，但我不知道该怎么做

private void button1_Click(object sender, EventArgs e)
{
    Excel.Application xlApp = new Excel.Application();
    Excel.Workbook xlWorkbook = xlApp.Workbooks.Add();
    Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
    Excel.Range xlRange = xlWorksheet.UsedRange;

    if (xlApp == null)
    {
        MessageBox.Show("Excel is not installed please intsall it first!");

    }

    xlWorksheet.get_Range("A1", "B1").Font.Bold = true;
    xlWorksheet.get_Range("D1", "E1").Font.Bold = true;
    xlWorksheet.get_Range("G1", "H1").Font.Bold = true;

    xlWorksheet.get_Range("A1", "H1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
    xlWorksheet.get_Range("A1", "H1").HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter;


    xlWorksheet.Cells[1, 1] = "Crane Locations";
    xlWorksheet.Cells[1, 4] = "Pick Locations";
    xlWorksheet.Cells[1, 7] = "Set Locations";

    xlWorksheet.Range[xlWorksheet.Cells[1, 1], xlWorksheet.Cells[1, 2]].Merge();
    xlWorksheet.Range[xlWorksheet.Cells[1, 4], xlWorksheet.Cells[1, 5]].Merge();
    xlWorksheet.Range[xlWorksheet.Cells[1, 7], xlWorksheet.Cells[1, 8]].Merge();


    xlWorkbook.SaveAs("C:\\Users\\a_hebiba\\Desktop\\Crane.xlsx", Excel.XlFileFormat.xlWorkbookNormal, Excel.XlSaveAsAccessMode.xlExclusive);
    xlApp.Visible = true;
    xlApp.UserControl = true;

    xlWorkbook.SaveAs("C:\\Users\\a_hebiba\\Desktop\\T-Crane.xlsx", Excel.XlFileFormat.xlWorkbookNormal, Excel.XlSaveAsAccessMode.xlExclusive);
}

标签： c#excel

解决方案

推荐阅读