public void ChangeExcel2Image(string filename)
{
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
workbook.LoadFromFile(filename);
Spire.Xls.Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToImage("性能报表.jpg"); //图片后缀.bmp ,imagepath自己设置
}
private void modernButton1_Click(object sender, EventArgs e)
{
Spire.Xls.Workbook wb;
Spire.Xls.Worksheet ws = null;
wb = new Spire.Xls.Workbook();
wb.LoadFromFile("Data\\Test\\c5.xlsx");
wb.ActiveSheetIndex = 0 + 1;
ws = wb.ActiveSheet;
//var dgv=new DataGridView();
//dgv.Dock = DockStyle.Fill;
//dgv.DoubleBuffered(true);
//try { dgv.DataSource = ws.ExportDataTable(); } catch(Exception ex) { Log(Logger.GetExceptionInfo(ex));}
//Form frm = new Form();
//frm.Controls.Add(dgv);
//frm.ShowDialog();
ScoreTable st = new ScoreTable(new Dictionary <string, ScoreModel>(), new InputDataIndicator());
var data = ws.ExportDataTable();
//for (int i = 0; i < data.Rows.Count; i++)
//{
// data.Rows[i][1] = Convert.ToInt32(data.Rows[i][1].ToString());
//}
GridEditWindow gew = new GridEditWindow("编辑成绩");
gew.DataGridView.DataSource = data;
gew.Show();
}
/// <summary>
/// 添加材料
/// </summary>
/// <param name="input"></param>
/// <returns></returns>between types 'System.String' and 'System.Nullable`1[System.Guid]'.”
public IListResult <MaterialDto> AddMaterial(string input)
{
try
{
// var material = new Material
// {
// Name = input.Name,
// Model = input.Model,
// Strength = input.Strength,
// MaterialType = input.MaterialType,
// Date = input.Date,
// TypicalPartId = input.TypicalPartId,
// ManufactoryId = input.ManufactoryId,
// FileString = input.FileString
//};
//创建Workbook对象
Workbook wb = new Workbook();
//加载Excel文档//@"C:\Users\Administrator\Desktop\新建 XLSX 工作表.xlsx"
wb.LoadFromFile(input);
//获取第一个工作表
Worksheet sheet = wb.Worksheets[0];
//获取指定单元格的值
string value = sheet.Range["A2"].Value2.ToString();
//自定义时间格式
DateTimeFormatInfo dtFormat = new DateTimeFormatInfo();
dtFormat.ShortDatePattern = "yyyy/MM/dd";
var material = new MaterialDto
{
Name = sheet.Range["A2"].Value2.ToString(),
//Model = sheet.Range["C2"].Value2.ToString(),
TypicalPartId = new Guid(sheet.Range["a2"].Value2.ToString()),
//Date= Convert.ToDateTime(sheet.Range["b2"].Value2.ToString(), dtFormat)//注意:string格式有要求,yyyy/MM/dd
};
//释放资源
wb.Dispose();
//await _materialRepository.InsertAsync(material);
return(null);
}
catch (Exception)
{
return(null);
}
}
private void button1_Click(object sender, EventArgs e)
{
try {
if (openFileDialog1.ShowDialog().Equals(CancelButton) == false)
{
textBox1.Text = openFileDialog1.FileName;
Spire.Xls.Workbook wb = new Spire.Xls.Workbook();
wb.LoadFromFile(textBox1.Text);
Spire.Xls.Worksheet ws = wb.Worksheets[0];
dataGridView1.DataSource = ws.ExportDataTable();
}
else
{
}
}catch (Exception ex)
{
MessageBox.Show("Cagaste en algo chavon");
}
}
