/// <summary>
/// 导出正式Excel文件,用于导入盘点数据
/// </summary>
/// <param name="ds"></param>
public static Byte[] ToExcel(DataSet ds)
{
string filePath = "";
bool check = false;
try
{
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
string filename = "File_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xlsx";
//临时存放路径
filePath = "C:/2020Roy/" + filename;
//Excel模版
string masterPath = "C:/2020Roy/Templete.xlsx";
//复制Excel模版
File.Copy(masterPath
EXCEL NPOI 打开失败解决办法
最新推荐文章于 2023-03-29 12:29:34 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)