C# spire.xls 初使用datagridview→.xlsx
首先,添加引用
实现代码如下:
using Spire.Xls;
public class xlsP
{
public string sheetname {
get; set; }
public DataTable dt {
get; set; }
}
private void SetToExcel(List<xlsP> lt_xp)
{
string machineno = cbox_machineno.Text;
if (Directory.Exists(Application.StartupPath + "\\EXCELSAVE"))
{
Directory.CreateDirectory(Application.StartupPath + &#