自动生成试题和Excel表格
5星
- 浏览量: 0
- 大小:None
- 文件类型：RAR
简介：
本工具能够智能生成符合需求的试题，并将相关信息整理成结构化的Excel表格，便于管理和分析。
以下是经过整理后的代码：
```csharp
private void Save2Excel()
{
string file = F:\\11ck.xlsx;
string path = F:\\11excel;
string time = DateTime.Now.ToString(yyyyMMdd);
if (!Directory.Exists(path))
Directory.CreateDirectory(path);
string saveName1 = path + \\ + DateTime.Now.ToString(yyyyMMddHHmmss) + .xlsx;
excel = new CCExcel(file, saveName1);
excel.Exceldata();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
Form1.name = textBox1.Text;
}
private void Form1_Load(object sender, EventArgs e)
{
comboBox1.Text = 11;
comboBox2.Text = 100;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Form1.comB1 = comboBox1.Text;
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
Form1.comB2 = comboBox2.Text;
}
public class CCExcel
{
public Excel.Application appExcel;
public Excel.Workbooks wbs;
public Excel.Workbook wb;
public Excel.Worksheets wss;
public Excel.Worksheet ws;
private string fileName;
private string saveName;
public CCExcel(string fileName, string saveName)
{
this.fileName = fileName;
this.saveName = saveName;
}
public void Exceldata()
{
Create();
Open(fileName);
Data2Excel(); // 数据写入方法，具体实现未给出
Save(saveName);
appExcel.ActiveWorkbook.SaveCopyAs(fileName); // 判断当前激活的表，并保存这个表。否则，会弹出“是否保存Sheet1.xlsx”的对话框
wb.Close(Type.Missing, Type.Missing, Type.Missing);
wbs.Close();
appExcel.Quit();
wb = null;
wbs = null;
appExcel = null;
GC.Collect(); // 清理内存
}
private void Create() // 创建一个Excel对象
{
appExcel = new Excel.Application();
wb = appExcel.Workbooks.Add(true);
ws = (Excel.Worksheet)wb.ActiveSheet;
ws.Name = ck;
}
public void Open(string fileName)
{
appExcel = new Excel.Application();
wb = wbs.Open(fileName, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
}
}
```
注意，这里假设`Data2Excel()`方法存在并且负责将数据写入到创建的Excel文件中。如果有更多的细节需要添加或修改，请提供进一步的信息或者具体需求说明。
全部评论 (0)
