How to insert blank values in a cell

May 20, 2013 at 8:15 PM
Your DLL is amazing. I am able to create excel file which fulfill my requirements. Minor problem occurred below

I want to insert blank values in a cell and merge it but i am unable to do it.
sheet.Cells[A1:A3].Value = "";
sheet.Cells[A1:A3].Merge = true;
Doesn't work

Same i want to add a blank values in datavalidationlist

var listData = sheet.Cells[C1:C3].DataValidation.AddListDataValidation();
                        listData.Formula.Values.Add("");
                        listData.Formula.Values.Add("A");
                        listData.Formula.Values.Add("B");
                        listData.Formula.Values.Add("C");
                        listData.Formula.Values.Add("D");
                        listData.ShowErrorMessage = true;
                        listData.Error = "Please select a value from the list"; 
Pleae let me know how to do this.