I have a short question.
When I set the property “DisplayName” with the following text “Test Test”, than Excel open the file with an error.
It is probably due to the spaces.
Is it possible to normalize the string and return a error message when set the property?
var workBook = new Workbook(@"C:\Users\MBerthold\Downloads\Test.xlsx");
var table = workBook.Worksheets.ListObjects.DisplayName = "Test Test";
InputFile.zip (6.1 KB)