Hi everyone.I wanna import an excel file in my programs.First I define a template excel,it has list validation in this template.The datasource of the validation is my database from the SQL Server,when I download the file , I put the data for the list validation,the code like this:
WorkbookDesigner designer = new WorkbookDesigner();
designer.Save(fileName, SaveType.OpenInExcel, FileFormatType.Excel2007Xlsm, response);
The "dt" is my datatable from the database,but after download the file,I find the list validation is missing.I don't know the reason.Could you guys please advice.
your wacky zhang